topic sales order and Production order relation in Application Development and Automation Discussions

sales order and Production order relation

Former Member — Wed, 19 Mar 2008 05:42:05 GMT

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

Re: sales order and Production order relation

Former Member — Wed, 19 Mar 2008 05:46:25 GMT

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

Re: sales order and Production order relation

Former Member — Wed, 19 Mar 2008 05:53:16 GMT

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

Re: sales order and Production order relation

Former Member — Wed, 19 Mar 2008 05:57:56 GMT

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

Re: sales order and Production order relation

Former Member — Wed, 19 Mar 2008 05:58:24 GMT

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

Re: sales order and Production order relation

Former Member — Wed, 19 Mar 2008 06:15:19 GMT

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

Re: sales order and Production order relation

Former Member — Wed, 19 Mar 2008 06:23:56 GMT

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

also AFKO-RMANR and VBAK-VBELN

Regards

Shiva

Re: sales order and Production order relation

Former Member — Wed, 19 Mar 2008 06:35:14 GMT

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.

Re: sales order and Production order relation

Former Member — Wed, 26 Aug 2015 10:00:00 GMT

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

Re: sales order and Production order relation

Caetano — Wed, 26 Aug 2015 13:50:42 GMT

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

Re: sales order and Production order relation

KarthikeyanN — Wed, 28 Oct 2015 05:51:51 GMT

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