11-21-2007 9:20 AM
Hi all,
If any table level link avilable for Sales order ' Item ' level to purches order
' item' level.
Issue is in Sales order there are 10,20,30 ... like that items are there, They are create PO for 10,30 items not on 20th item for using purches request no .
I want shows my report :
20th item - Purches order is not created - statous.
how to do this.
Here only link between EKPO and VBAP is VBAP-VBELN = EKPO-BEDNR. Not on item level .
how to solve this plz help me,,
Thanks advance,,
11-21-2007 9:24 AM
11-21-2007 9:24 AM
11-21-2007 9:24 AM
Hi
Try to check EKKN table, if a purchase order is created from sales order the field EKKN-VBELN and EKKN-POSNR should be filled.
Max
11-21-2007 9:57 AM
Hi ,
Vbap is the sales Document item table &
Ekpo is the Purchase Document item table.
there r Similar fields : AEDAT,MATNR,MATKL,POSNR,BEDNR,MEINS,WERKS,LGORT
U can link the two on the basis of posnr of vbap & bednr of Ekpo.
plz check & revert.......
11-21-2007 11:01 AM
Thanks all for reply,
Ekpo doesn't have field posnr and vbap is didn't have bednr. Also vbap-vbeln is only eq ekpo-bednr.
Kindly tell me any other possible solutons ,,,,,,
Thanks advance,,,
11-21-2007 11:05 AM
Durai,
Check this
VBAP-POSEX = EKKN-VBELP.
EKKN-EBELN = EKPO-EBELN.
Regards,
Satish
11-21-2007 11:45 AM
11-21-2007 11:54 AM
hi check
vbkd-vbeln = sale order number
vdkd-posnr= item position
move vbkd-bstkd to ( purchase order number header level)
move vbkd-bstkd_e to( purchase order number postion level)
hope this will help
11-22-2007 4:23 AM
Hi satish,
Here vbap-posex has no values in table entries,so if any other way to solve this issue,,,