Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Opening Stock of a Material

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

Hi,

Try Transaction MB5B.

regards

Aveek

0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

Hi Vijaya,

SIMPLY AMAZING!!!!!!!!!!!!!

Thanks so much... that was the nicest way one could have explained this answer to me!!! Thanks again.

My problem is solved.

Cheers!!

Shobhit