How to read mseg from bseg!

[Former Member]

Hi forum!

I need to read from my bseg table (BUZEI) the corresponding item in the mseg table (ZEILE). the mseg table have the BELNR and BUZEI fields , but they are empty. can this be possible? i'm working with R/3 4.7

thanks in advance.

John.

[Former Member]

you can get FI document reading BKPF by fields AWTYP and AWKEY.

The value of AWTYP is MKPF, while you can obtain the value of AWKEY concatenating the keys of MKPF (MBLNR and MJAHR).

[Former Member]

Thanks Max.

I'm using AWTYP and AWKEY to get de material document number, But, i need to know the relationship at the item level, i mean, wich ZEILE(MSEG) correspond to my BUZEI(BSEG)

Thanks again.

John.

[Former Member]

Ah! Ok...

I think it isn't a relationship between the mseg item and bseg item, but you can get a relationship knowing the G/L account linked to the material of mseg item.

You can know the account by Valuetion Class (MBEW-BKLAS).

[Former Member]

There is no direct relationship between one item on the material document to one item on the accounting document. it is only at the header level, but if these two are related to a PO or a sales order, then there is a reference to the corresponding PO line item or the sales order line item. So may be indirectly you can derive a relationship, but not directly and accurately.