Find the table relations of production order and sales order

[Former Member]

Dear everyone:

I want to find the relations of production order and sales order through "sap Transp. Table". using the table ,

i want to find the sales order number from production order number.

[hymavathi_oruganti]

u can see AFKO(PP header table)

AFPO(PP item table)

VBAK(SALES HEADER TABLE)

VBAP(SALES ITEM TABLE)

AUFNR- PRODUCTION ORDER NUMBER

VBELN- SALES ORDER NUMBER

AUFNR (PRODUCTION ORDER NUMBER ) in both the tables VBAK(SALES HEADER), VBAP(SALES ITEM TABLE).

also, u can find sales order number in the PP table AFPO.

the field is KDAUF (sales order number)

i think now u got the relation

[Former Member]

Hi,

I have a doc which gives you relation amongest different tables..

I shall send it to you..

Give me your email id..

Regards,

Tanveer.

<b>Please mark helpful answers</b>

[Former Member]

refer this link...

[Former Member]

Thanks everyone .

But my applicatioin is not make-to-order type. If belong to make-to-order type ,yes, i can find them in the table which you told me.

In production order (co03) ,i can find the plan order in the item of "assignment" ,but i could not find them in table(AFPO,...),because, after run MRP from sales order and transfer to plan order and production order,the plan order have been deleted in application level.

[hymavathi_oruganti]

check table PLAF,

U CAN FIND AUFNR and KDAUF(SALES OEDER NUMBER) here.

[Former Member]

there is no value in PLAF for that planned order which has been converted to Production order.

[Former Member]

The link between the Sales Order & Prod. Order in Make-to-Stock is very difficult. Mr. Shao did u find that link if it is let me know, our Planning team is facing same kind of Situation thanks in advance . My email ID is tr.pr@rediffmail.com