Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table level link between Sales order ' Item ' to Purches order 'item'

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

u can check the posnr s of respective vbeln and bednr

8 REPLIES 8

Former Member
0 Kudos

u can check the posnr s of respective vbeln and bednr

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Durai,

Check this

VBAP-POSEX = EKKN-VBELP.

EKKN-EBELN = EKPO-EBELN.

Regards,

Satish

Former Member
0 Kudos

Hi,

Did you check with my answer?

Regards,

Satish

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi satish,

Here vbap-posex has no values in table entries,so if any other way to solve this issue,,,