Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 21, 2007 at 09:24 AM

    u can check the posnr s of respective vbeln and bednr

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2007 at 09: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2007 at 09: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.......

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2007 at 11:45 AM

    Hi,

    Did you check with my answer?

    Regards,

    Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2007 at 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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2007 at 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,,,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2007 at 11:05 AM

    Durai,

    Check this

    VBAP-POSEX = EKKN-VBELP.

    EKKN-EBELN = EKPO-EBELN.

    Regards,

    Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2007 at 04:23 AM

    Hi satish,

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

    Add comment
    10|10000 characters needed characters exceeded