Skip to Content
avatar image
Former Member

link between mblnr and kdauf fields

Hi Guru's,

i am find link between Number of Material Document and sales order no .i found that in mseg table but there is no relation between in to table anybody tell me what are the other table in dictionary.

Thanking you.

Regards.

Sam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 18, 2008 at 05:43 AM

    Hi

    Check this table - AFRU

    May be it'll help you.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2008 at 06:35 AM

    chek that table mseg in that .while the MM people creating GR item data will be stored to mseg table.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2008 at 06:54 AM

    Hi Sam,

    In Table MSEG

    KDAUF = VBELN Sales Order Number

    KDPOS = POSNR Item Number in Sales Order

    So get the VBELN and POSNR from VBAP and pass it to KDAUF and KDPOS in MSEG respectively and get the MBLNR ....

    write a select like below...

    select MBLNR from mseg where KDAUF = VBAP-VBELN and KDPOS = VBAP-POSNR.

    Hope it will solve your problem..

    Thanks & Regards

    ilesh 24x7

    Add comment
    10|10000 characters needed characters exceeded