topic Purchase Order , Materials in Application Development and Automation Discussions

Purchase Order , Materials

Former Member — Tue, 03 Oct 2006 10:17:39 GMT

Hi All,

I am look for a link (tables) for a sales order --> purchase order number --- > purchased materials ...

The report has to pull the <b>purchased materials</b> for <b>sales orders</b> .....sales order does not produce a production order , it generates a purchase order..

Thanks,

Vind.

Re: Purchase Order , Materials

Former Member — Tue, 03 Oct 2006 10:22:11 GMT

Please avoid opening duplicate threads. Help to close one thread.

Do let us know what more info do you need apart from the one that has been provided earlier.

Kind Regards

Eswar

Re: Purchase Order , Materials

Former Member — Tue, 03 Oct 2006 10:25:05 GMT

Try your luck in EKKN Table

Re: Purchase Order , Materials

Former Member — Tue, 03 Oct 2006 10:26:17 GMT

Hi Eswar,

The Code you send me earlier is not pulling up the data in the internal table ...

thxs,

vind..

Re: Purchase Order , Materials

Former Member — Tue, 03 Oct 2006 10:31:22 GMT

sales order information is in VBAK while purchase order information is stored in EKKO with item details in EKPO. In short you have to get the details from EKPO, but in your case you need to get a bit more information on the linkage between your Sales order and Purchase order.

U need to find out the way two are linked !!