2006 Oct 03 9:30 AM
Hi All,
I am look for a link (tables) for a sales order --> purchase order number --- > purchased materials ...
Thanks,
Vind.
2006 Oct 03 9:49 AM
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
Hi All,
I am look for a link (tables) for a sales order --> purchase order number --- > purchased materials ...
Thanks,
Vind.
2006 Oct 03 9:32 AM
2006 Oct 03 9:33 AM
VBAP-VBELN = LIPS-VGBEL
VBAP-POSNR = LIPS-VGPOS..
EKPO-EBELN = LIPS-VGBEL
EKPO-EBELP = LIPS-VGPOS..
2006 Oct 03 9:35 AM
check this <a href="http://www.erpgenie.com/sap/abap/tables_sd.htm">link</a>
2006 Oct 03 9:40 AM
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..
2006 Oct 03 9:49 AM
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
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |