on 10-22-2008 11:33 AM
hi
when you go to the /sapapo/rrp3 transaction ( product view ) in SCM system you will get lot of views for a given product and location like elements, periods, pegging overview etc.,. . In the pegging overview for example we have recpt element and reqmt element colums which contain the sales order number and purchase req number. I want to know the database tables names where i can get this information. basically i want to what are purchsae reqs or purchase orders linked to a given sales order or material.
thanks
Please find requested data in respective tables in SAP APO:
/SAPAPO/SDORD - SOs
/SAPAPO/MM_DOC - RPs
or in SAP ERP :
VBAK / VBAP - SOs header / item data
EBAN - RPs
Hope it suits your needs,
Regards, Victor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can go to SE11 and see all field of table /SAPAPO/MM_DOC and their description.
It will tell you details of GUID.
Than you have to go to individual table and read actual product from GUID.
like MATKEY for Material GUID.
/SAPAPO/ORDER_GUID CHAR 22 0 GUID of an Order Object
/SAPAPO/LOCID CHAR 22 0 Internal Location Number (Customer, Supplier, or Plant)
/SAPAPO/MATID CHAR 22 0 Internal Number (UID) for Product
Manish
HI
Ok My question is for a given order id or guid can i know the order number. for example in RRP3 transaction ( in pegging overview tab) u can see the sales order numbers , purchase requistion numbers right. I want to know where these numbers are stored in SCM I want those table names.
thanks
Hi
thank you veyr much it really helped. Now i have one final question. Now i am able to get the purcase requistion number given the orer guid to the FM /SAPAPO/OM_ORDER_GET_DATA. I want to now find out the sales order corresponding to this. if you see in the pegging overview tab in RRP3, you can see the sales order numbers created in R/3 in the coloumn ' reqmt element" and purcase req in the "recpt coloumn". i want to get that link between them in ABAP program
thanks
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.