Opening stock of a month

[Former Member]

Hi All,

I am getting opening stock of a month in MB5B transaction,I need to develop a Z report to find out valuated stock ,for this I need to do add opening stock(of month) + value stock issue qty +

value stock receipt qty,I got the fields for value stock issue ,value stock receipt qty from table s031,I don't know how to find out first opening stock,then only I can find out valuated stock (closing stock),Is there any table is there for opening stock or Is I need to write any logic to find out this,any one please help me.

Thanks&regds,

Sree.

[Former Member]

Hi,

You need to use tables MBEW & MBEWH.

Regards

Raju Chitale

[former_member784222]

Hi,

You can use MBEWH (history stock) and MBEW( current stock) for the valuated stock report. If you want to take details of transaction, you might have to go to MKPF+MSEG tables.

Thanks and regards,

S. Chandra mouli.