Purchase Materials

[Former Member]

Hi All,

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

Thanks,

Vind.

[Former Member]

Hi

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

[Former Member]

check VBKD-BSTKD for Purchase Order

regards

Prabhu

[Former Member]

VBAP-VBELN = LIPS-VGBEL

VBAP-POSNR = LIPS-VGPOS..

EKPO-EBELN = LIPS-VGBEL

EKPO-EBELP = LIPS-VGPOS..

[gopi_narendra]

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

[Former Member]

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..

[Former Member]

Hi

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