Skip to Content
author's profile photo Former Member
Former Member

Opening Stock of a Material

Hi,

I want to find out the opening stock of all the materials in my company code in the financial year, ex 01.04.2005

Can some one assist me with this.

Thanks & Regards,

Shobhit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 09, 2005 at 10:10 AM

    Hi Shobhit,

    Open stock of a material will be available in the Accounting1 View of the material master.

    Here is some information to find the opening stock of a material in a period. This information will be stored in the tables MBEWH, MARDH, MCHBH.

    As of Release 4.5, stock fields and valuation fields relating to the previous period or to an earlier period are stored in history tables (for example, MBEWH, MARDH, MCHBH), and no longer in those tables in which the current stock data is stored (for example, MBEW, MARD, MCHB).

    These history tables can contain one entry for each period. An entry is created in the history table only if the stock-relevant data or valuation-relevant data changes. The value of the entry relates to the end of the period. The history tables do not contain any entries for the current period.

    Example

    Scenario

    At the start of period 02, there are 10 pieces of material 4711 in stock.

    Goods receipt

    5 pieces are received in period 02.

    System response

    The system records a stock of 10 pieces in the history table for period 01. At the same time, the system increases the current stock to 15 pieces.

    Goods receipt

    2 more pieces are received in period 02.

    System response

    The history table is unaffected by this event because an entry already exists for period 01. The system increases the current stock to 17 pieces.

    Goods issue

    4 pieces are withdrawn from stock in period 04.

    System response

    The system records a stock of 17 pieces in the history table for period 03. At the same time, the system reduces the current stock to 13 pieces. (The history table does not contain an entry for period 02 because there were no goods movements in period 03.)

    Rules

    If the history table does not contain an entry for the previous period, the values for the previous period are the same as those for the current period.

    If the history table does not contain an entry for a period n that precedes the previous period, the values for period n are the same as those for period n+1.

    Since the second rule can be applied recursively, it is possible to determine (in accordance with both rules) the values for any periods as of the period in which Release 4.5 or a subsequent release was implemented.

    Hope this one helps you.

    Best Regards,

    Vijay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2005 at 01:24 PM

    Hi,

    Try Transaction MB5B.

    regards

    Aveek

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Aveek,

      Sorry my question was wrongly put. I am aware of MB5B. But I want to include the opening stock field in my report for all materials in a company code.

      Could you please help me with the tables/logic?

      Thanks & Regards,

      Shobhit

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.