sales Order, Production Order, Purchase order

[former_member156446]

Hi ppl..

I have a req to pull and report with Pro order # and status

Purchase order # and status

for a given sales order .... item level...

need tables and relations between Production order, sales Order and Purchase Order and there status's.

[Former Member]

<b>Sales Order Tables:</b>

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

<b>Production Order Tables:</b>

AFKO Production Order Header

AFPO Production Order Position (details)

MAST Material BOM

STKO BOM Header

STPO BOM Positions (detail)

<b>Purchase Order Tables:</b>

EKKO Purchasing Document Header

EKPO Purchasing Document Item

MKPF Header- Material Document

MSEG Document Segment- Material

Regards,

Maha

[former_member156446]

how can I relate sales order vbak, vbap to these tables?

[Former Member]

Hi,

Start with VBAK & VBAP table, get the Purchase order and Production order details from corresponding Master tables.

Regards,

Maha

[former_member181962]

Go to VBAP table

Give the SO Number in VBELN and ITEM in POSNR to get the Production Order Number in AUFNR.

To get the PO for a Sales rder, go to VBAK and give the Sales Order Number to VBELN and get the PO Number in BSTNK.

Regards,

Ravi Kanth Talagana

[former_member156446]

in VBAP AUFNR is not maintained.... so any more options plz

[former_member156446]

close