Tables and fields for historic stock values of materials

[Former Member]

Hello Gurus,

I have a requirement to have the capability of generating  a report that provides material stock values and quantities

for any given posting period and fiscal year. I would like to know what tables can provide these data.

I have used tables MARD, MARDH, MBEW, MBEWH, MSLB,MSLBH, but these tables are not providing all the

needed data. Could there be any other tables i am still missing?

Pls help.

Thank you.

Ahm.

[Former Member]

Thanks for your responses, but i seem to be unable to tag which response was helpful.

@G. Lakshmipathi, your response was very handy, thank you so much.

[former_member183879]

Hi,

You have captured all the tables related to historical data. May be you are not finding the right fields in these tables. But in essence these are the history tables you should be looking for.

If you are looking for batches, you can search MCHBH also.

[Lakshmipathi]

Please search the forum or Google with the same text so that you will find many inputs on this topic.  Please go through the forum rules which you can see to your right screen and adhere to that.  Just execute MB5B

G. Lakshmipathi

[former_member559646]

Hi,

User Table MSEG . Pass Fiscal Year in Material Doc Year (MJAHR) and Posting Period in Pasting Date (BUDAT_MKPF)

You can also enter Mvt Type (BWART), Plant (WERKS), Material (MATNR) etc

Hope this will fufill your purpose

Regards,

Sadan