cancel
Showing results for 
Search instead for 
Did you mean: 

Macro Logic - Historical Inventory Calculation weekly - monthly

Former Member
0 Kudos

Hi All,

I am trying to design a macro that allows us to view only the last weeks inventory value from a weekly data view in a monthly data view. I have tried a number of different settings such as Calculation Types and different Time Based Diaggregation settings in the planing area but without success.

It would look something like this:

W1...W2....W3....W4 - (these weeks are all in M1)

10....20......32......43

M1 - the last week (W4) is the only one we want to see in M1

43

Any suggestions would be appreaciated.

Paul

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Paul,

Have you considerde using Time based Disaggregation type "L"

L- Read: Value from last period; Write: No allocation

When you aggregate from shorter time buckets to larger, for instance weeks to months, the system take the value from the last period and copies it to the larger time bucket. In the reverse case, the value is written to all the smaller time buckets.

You can see the same at:

http://help.sap.com/saphelp_scm41/helpdata/en/8f/9d6937089c2556e10000009b38f889/frameset.htm

Hope this helps.

Cheers!

Abhi

Former Member
0 Kudos

Abhi,

Problem solved.

Thanks,

Paul

Answers (0)