Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Disaggregation of calendar week to fiscal week

I have a requirement in which the customer has a Fiscal Week that starts on Thur and ends on a Wed. However, for our planning application, the users will plan on 0CALWEEK, and we need to derive Fiscal Week. For example, if a user enters in 100 for a Summation key figure for 0CALWEEK (Mon - Sun), we would need to proportion 3/7 to Fiscal Week 1 = 43, and then 4/7 or 57 to Fiscal Week 2. I think we can modify the 1st record record to read...

0CALWEEK FISCAL WK 0AMOUNT

1 1 43

...and generate a new record for FW 2 to read...

1 2 57

We can create a function of type Exit that can do a lookup to the Factory calendar to obtain the number of working days in a particular calendar week in order to proportion the number of working days.

I can also think of creating a Distribution function to distribute to Fiscal Week perhaps based on historical data as another way to generate the Fiscal Week #2 record.

Has anyone else come across the need to split records like this? If so, then what approach did you take to solve the problem?

Best regards,

Steve

Edited by: Steven Wisz on Sep 22, 2008 3:37 PM

Not what you were looking for? View more on this topic or Ask a question