03-19-2008 5:42 AM
i hav a requirement to display list of production order against each sales order....VBAP table has field AUFNR but i do not find any entry in this field....
is there anyway to determine the production order number for the particular sales order......?
03-19-2008 5:46 AM
Hi,
u will find the same AUFNR as Order No. in AUFNR Order Confirmations Table.
u can have join with these...!!!
Hope it will help u...!!!
Pls Reward if Helpful....!!!
03-19-2008 5:53 AM
i need relation between sales order number and production order..in order confirmation table i dont see any sales order number?????
03-19-2008 5:57 AM
Hi,
Check Table AFPO
KDAUF is the SO Number
You can even check this link
Production order and sales order can be made by using the KDAUF KDPOS fields of AUFK or AFPO and linking them to VBELN and POSNR of VBAP.
Regards,
Satish
03-19-2008 5:58 AM
Dear Ramchadran,
Sales order AUFNR in Sales Becomes Production Order in PP module.
so, u won't see any sales order there ,becoz u have to match these Business Process.
Pls reward if helpful....!!!
03-19-2008 6:15 AM
Hi ... thanks i found the field but no entry exists there....are there any function modules or bapis which returns the production order for a sales order????
03-19-2008 6:23 AM
Hi
Make use of AFPO_AUFNR / AFKO-AUFNR and VBAK-AUFNR
also AFKO-RMANR and VBAK-VBELN
Regards
Shiva
03-19-2008 6:35 AM
the bapi is BAPI_PRODORD_GET_DETAIL ....but in my case i get the sales order number is blank...as there is a conversion as said above i dont its possible to determine the sales order no for a production order.
08-26-2015 11:00 AM
Hi Ramachandran,
For your requirement, you can use table 'AUFK'.
Input sales order document number (KDAUF) and sales order line item (KDPOS), you will get list of all production order created against the sales order and item combination.
Regards,
Anuj
08-26-2015 2:50 PM
Hello
Please observe that there no direct link between the sales order and the production order, only in case of make-to-order and assembly-to-order scenarios.
If you are using one of those scenarios, you will find the sales order number on table AUFK, as already mentioned here.
You may try to develop your own report using function module MD_SALES_ORDER_STATUS_REPORT, however, you should consider that this not a BAPI, therefore, it is not supported by SAP on custom programs.
Best regards
Caetano Almeida
10-28-2015 5:51 AM
In table AFPO ( ORDER ITEM TABLE ), U CAN GIVE KDAUF (SALES ORDER NO.) AND GET THE RESPECTIVE AUFNR (PRODUCTION ORDER NO. )