link between mblnr and kdauf fields

[Former Member]

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

[Former Member]

Hi

Check this table - AFRU

May be it'll help you.

Regards.

[Former Member]

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

[former_member387317]

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