sales order and Production order relation

[Former Member]

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......?

[Former Member]

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....!!!

[Former Member]

i need relation between sales order number and production order..in order confirmation table i dont see any sales order number?????

[Former Member]

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

[Former Member]

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....!!!

[Former Member]

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????

[Former Member]

Hi

Make use of AFPO_AUFNR / AFKO-AUFNR and VBAK-AUFNR

also AFKO-RMANR and VBAK-VBELN

Regards

Shiva

[Former Member]

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.

[Former Member]

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

[Caetano]

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

[KarthikeyanN]

In table AFPO ( ORDER ITEM TABLE ), U CAN GIVE KDAUF (SALES ORDER NO.) AND GET THE RESPECTIVE AUFNR (PRODUCTION ORDER NO. )