How to get stock value in MB5B ...

[Former Member]

Hi,

i want to calculate a closing stock value in my function module. using different tables.

can any one tell the table name and how to get closing stock value.

I want a value which is exactly match with MB5B Report.

Thanks

Haresh

[rahul_vishwakarma2]

Hi Friend,

   There is no table that has stock information for a certain date. Since MB5B Calculates the Stock by reading all the Movement type.

Since MARD will show you the current stock and MARDH will show you the Stock at the end of the month.

Ex: Suppose you have a 100 Stock in Month of Jan and amongst them 10 you had reduced, then in table MARDH it will show 100 Qty Stock in month of Jan.

I hope this will help you in some manner.

Regards,

Kundan

[venkateswaran_k]

Dear Haresh,

I have a solution.  But I need some more clarification.

How do you want to calculate the closing stock.  You want to know the closing stock of a material on any particular Date?

Regards,

Venkat

[Former Member]

hi,

thank for reply,

i want to calculate closing stock of current date.

Thank You,

Haresh

[Former Member]

Hi Haresh,

Please refer this link - http://scn.sap.com/thread/3393723. The link also has details of ABAP code for such function module.

Regards

Ankit