Stock accumulation icluding not assosiated days (SAP actual stock count)

[#1]

Hi Everyone! I need your help.

Let me describe it from the beginning:

I need to count for how many days specified Material was in stock.

ToDo this I have 2 SAP tables:

1 Is the (MARDH) Amount of Material on the 1st of the month

Date,
Material,
BussinessUnit,
Warehouse,
MonthStartAmount

2 Is the (MSEG+MKPF) Is the moves of this material

Date,
Material,
BussinessUnit,
Warehouse,
Move

//Moves are already + and - so i can sum() group them by Date.

So I can make a chart and see the amount but only for the dates that were assosiated with material.

Looks like i need an expression to show me the amount of material for every day, so that i can count "0" later.

Should have asked you earlier.

I've been thinking about this for a week already, please help.

Thanks, Maxim.

[suniljain]

You have to follow MKPF + MSEG Combination. it will gice you cleat picture .

This both scenario need not give same result. But MSEG + MKPF Combination gives you perfect result that match with SAP Standard report MB5B.

You Have to Bulid FIFO Approach in stock calculation based on DATE, Material code, plant, Batch.