Skip to Content
avatar image
Former Member

How to get stock value in MB5B ...

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 24, 2013 at 05:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2013 at 05:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2013 at 06:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded