Table for Opening and closing stock ?

[Former Member]

Hey Gurus,

Is there any table which shows opening stock and closing stock by Fiscal Period ? I want to calculated Average inventory in the period on bw query ?

Regards,

Alper

[Former Member]

hi there,

good question

Just check the below mentioned tables

MBEWH, MARDH, MCHBH

for previous perid stocks.

and let me know the results

reward accordingly

Regards

Sujoy

[Former Member]

hi,

U can get the opening and closing stock as per material using TC:MB5B

but if ur looking for a table or a SAP report dat directly shows u each material corresponding to its opening and closing stock dep on d date , i don think a direct solution exists.

however wid a lil calculation u can create a report dat serves d purpose .

if u do need a sample do revert back and il b glad to give u d code!

regards ,

Goldie.

[Former Member]

This message was moderated.

[csaba_szommer]

Hi Berna,

You can use standard reports to get the opening/closing stock datewise: MB5B, period wise: (e.g.) MC.A - from MC.A you can also get avarage stock (please click on the field, push F1 - you will get the description how it is calculated) > table S039 is used for MC.A.

BR

Csaba

[Former Member]

check Table MARDH

Thx

Raju

[Former Member]

Hi,

You can use table MBEWH. You will not get the required data directly, but you can very easily find out the opening and closing stock for a particular period from this table by some minor calculations.

Regards,

vishal