Material document number and accounting document

[Former Member]

Hi,

Which tables can you find the accouting number (BSEG-BELNR) from a given material document #? I know there is a transaction MB03 we can look up, but I'm coding an user exit, I need to loop up tables.

Thanks

Lily

[Former Member · Accepted solution]

Hi,

You can use the table BKPF.

pass AWTYP = 'MKPF'

and AWKEY = 'Material document number' (MKPF-MBLNR) + 'Year'(MKPF-MJAHR).

basically concatenate 'Material document number' (MKPF-MBLNR) + 'Year'(MKPF-MJAHR) to get the awkey...and then use that value in the BKPF select.

Thanks

Naren

[Former Member · Accepted solution]

Great!! Thanks.

I'll mark this thread as "answered".

[former_member188685]

<ignore>

Edited by: Vijay Babu Dudla on Oct 8, 2008 2:56 PM

[Former Member]

Hi,

Check table MSEG.

Regds,

Senthil