Skip to Content

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

Loading Weekly Forecast Data from APO Demand Planning to S&OP via HCI

Hi all,

I am trying to load forecast data from a planning area in APO Demand Planning (DP) to a planning area in S&OP via HCI. The source planning area has weeks and months as time buckets. I have generated a data source for the planning area in APO DP and use it as source in HCI. Transferring the data on monthly level works fine. Now I have the requirement to transfer the data on weekly level. Here I have a problem where hopefully somebody can help me with.

From APO DP I get the time bucket information in the field CALWEEK in the format '<Year><Week>' e.g. '201452'. The planning area staging table on S&OP side uses a datetime field to identify the weekly time bucket as you can see in the screenshot below.

I have not found any HCI function to derive the date from a calendar week. Due to the year dependency there also seems to be no really simple logic to do this conversion. Does anyone have an idea how to reach such a data load on weekly level?

Thanks and Kind Regards,

Thomas

Helpful Answer

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