Showing results for 
Search instead for 
Did you mean: 


Former Member
0 Kudos

HI Experts,

I am developing a report for Material Receipts where I have to display the Material, Material Desc, Qty, Rate, Value, GL Accout and GL Description.

Can anyone suggest a suitable table for getting Material Receipts.

How do we link Material and GL Account.

PLease suggest.

Thank You


View Entire Topic
Former Member
0 Kudos

Hi ,

You can use following tables :

MARA - For material basics

MAKT - for material description

MSEG - with movement Bwart - 101 for receipts use menge field for qty

DMBTR for value of receipts

for GL account i want toa sk you want which GL account here ?? if you are looking for Materials GL account get the same from Materials valuation class or from MSEG entry concatenate MBLNR+IETME no. and pass to AWKY field in BKPF table and from there get to BSEG table line items to get any HKONT as Gla ccount no for that entry