topic Re: Purchase Materials in Application Development and Automation Discussions

Purchase Materials

Former Member — Tue, 03 Oct 2006 08:30:43 GMT

Hi All,

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

Thanks,

Vind.

Re: Purchase Materials

Former Member — Tue, 03 Oct 2006 08:32:24 GMT

check VBKD-BSTKD for Purchase Order

regards

Prabhu

Re: Purchase Materials

Former Member — Tue, 03 Oct 2006 08:33:35 GMT

VBAP-VBELN = LIPS-VGBEL

VBAP-POSNR = LIPS-VGPOS..

EKPO-EBELN = LIPS-VGBEL

EKPO-EBELP = LIPS-VGPOS..

Re: Purchase Materials

gopi_narendra — Tue, 03 Oct 2006 08:35:06 GMT

check this <a href="http://www.erpgenie.com/sap/abap/tables_sd.htm">link</a>

Re: Purchase Materials

Former Member — Tue, 03 Oct 2006 08:40:27 GMT

Hi,

Thaks for the reply..am looking for sales order that does not produce a production order indeed creates a purchace order and the matrails required , does the above links meet these condition...If not can any one suggest to how to get these pls ...

Thxs,

vind..

Re: Purchase Materials

Former Member — Tue, 03 Oct 2006 08:49:51 GMT

You can even use table VBFA.

Check for entries with VBTYP_N = 'V'. You can get details like SO number, SO Item, PO Number & PO Item.

Maybe your select query should look as below:

select b~ebeln b~ebelp b~matnr a~vbelv a~posnv
       into table itab
       from vbfa as a
       inner join ekpo as b
       on a~vbeln = b~ebeln
       and a~posnn = b~ebelp
       where a~vbtyp_n = 'V'
       and   a~vbelv in s_vbeln.

Hope this helps you.

Kind Regards

Eswar