cancel
Showing results for 
Search instead for 
Did you mean: 

Opening stock of a material

Former Member
0 Kudos

Dear Gurus

I am writing stock report program which is required Opening stock for given date.

Is there any call function available?

I want to check with transaction code MB5B for opening stock.

Regards

Vijayendran S

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.