08-18-2007 6:43 AM
hi
i want production order no.(AFUNR) against sales order no.(VBELN) .
i searched in TABLES : AFKO, AFPO, VBAK, VBAP.
BUT problem is that in all 4 tables field is common but in (AFKO, AFPO ) there is no value for SALES ORDER (VBELN) , and vice-versa.
plz guide me.
08-19-2007 9:29 AM
08-19-2007 11:37 AM
Hi
Check the AUFNR field in VBAP table?
What is the functional link between sales order and Production order? based on that we have to search.
See the AUFK table also for sales Order VBELN field
<b>Reward points for useful Answers</b>
Regards
Anji
08-19-2007 2:55 PM
AUFNR (Internal Order) is an account assignment element used mainly in FI/CO.
In SD, accounting detail is often generated at the billing stage.
Check the billing documents associated with the sales order and see if they provide the link (VBRP, VBRK).
Andrew