Material stcok history

[Former Member]

Hi friends

I want getting material stock history.

For example My matnr = 1000000 I want get between 2 date (01.01.2007 and 10.01.2007 ) stock movements of this material. Do you know any bapi or view for this? When ı doing this via sql Application running time is very long (45 min).

Thanks

[Former Member · Accepted solution]

HI,

look at the fucntion module MB_READ_MATERIAL_STOCKS

Regards

Sudheer

[Former Member]

I have changed source code of MB5B it is usefull. Thanks all person

[Former Member]

Hi!

You can run the standard SAP transactions in background also:

MB51 - material documents

MB52 - actual stock

MB5B - material stock for date

Choose Program -> Run in background and you can skip programming.

But the following tables are containing the material movement documents:

MKPF, MSEG, or use the view: WB2_V_MKPF_MSEG

And the following table is for the actual stock:

MARD

Regards

Tamá

[Former Member]

Hi,

Check the TABle MARDH.

If useful reward.

Vasanth

[raymond_giuseppi]

As there is no index (standard) with MATNR and date, try to reduce your request specifying MJAHR in your example 2007 especially if you never archived movements.

regards