materials with stock in a month

[Former Member]

Hi Experts,

I have to create a report plant wise and month wise for the no. of materials with stock without physical inventory, materials with phy. inventory.for each month in the selection screen.

Main problem i am facing is, user want to freeze the report values before the current month as every month stock gets changed. means if in june we have 100 materials with stock without phy.inventory in july we have 100 materials with stock without phy.inventory and in current month we have 120 materials with stock without phy.inventory, then report should display.

june2007 - 100

july2007 - 100

Agust2007- 120

but how we can freeze a report in previous data, i am selection materials from MARD.

please help me for this, if any code relatet to this it will be helpful.

Regards

Nik

[SantoshKallem]

we have history tables related to material.

try to search it in se11 with key M*H

regards.

santhosh reddy

[Former Member]

Hi Santosh,

Those table i checked but not helpful

Regards

Nik