Calculating Weekly dates in SAP CI-DS

[shubham_1993]

Hi Team,

We have a requirement that for historical data in IBP we need to fetch the data from a table and create a flat file and send the actuals quantity and sending the quarter wise data in a weekly period.

Like for quarter 1 2021 year we will be having 13 quantity values which depicts 13 weeks for the quarter.

So in the flat file we need to populate the weekly dates including year instead of quarter.

Is this possible as i am facing in populating the dates.

This is needed bit urgent.

Your help will highly be appreciated.

Thanks

Shubham Srivastava

[shubham_1993]

Can anyone please help me in this regard.

Its an urgent requirement got stuck in this requirement.

balazsbence95 could you please help me in this regard.

Thanks in Advance

[balazsbence95]

Hi shubham_1993,

You can use the corresponding PERIODIDn fields to filter by week or year. See these below:

• https://blogs.sap.com/2019/08/21/sap-ibp-data-extraction-via-cpi-ds-how-to-best-filter-data-by-time/
• https://blogs.sap.com/2019/09/09/sap-ibp-data-extraction-via-cpi-ds-how-to-extract-key-figures-on-di...

If you do not want to create the dataflow logic yourself from scratch, you can make a use of the pre-built templates:
https://help.sap.com/docs/SAP_INTEGRATED_BUSINESS_PLANNING/eab8fd1726934516a89eabced318b210/c14c1155...

Regards,
Bence

[shubham_1993]

Hi Bence,

Thanks for your help in this regard.

But the issue here with us is that we have to send the data from S/4 to IBP considering the future and historical data.

So in MVER table we are getting fields ZHALR which is for Quarter 1, 2 , 3 and 4.

And for year the filed is GJAHR for fiscal year.

So we need to now convert it into dates denoting weeks of a quarter.

Just like for Quarter 1 , the date should start from 01.01.YYYY

and we need to populate all the 13 weeks data for the quarter in the file or staging table into IBP.

So to send these datas from MVER table i am creating a new flow on a whole and trying to achieve it from CI-DS.

Is there any way if i take a hardcoded start date and then i can concatenate the year to create the whole date KEYFIGUREDATE field in the File.

Please let me know if there is any other way to achieve this.

I will be very grateful for your help in this regard.

Thanks

shubham shrivastava

[balazsbence95]

Hi shubham_1993,

Yes, the logic with the concate looks good, putting together the date from the ZHALR and GHJAHR values. For this scenario, you need to implement your logic here based on your needs.

You can convert the quarters to dd.mm varchar values by using decode() or iftehnelse() in the mapping, then later you can concatenate them to to year, and finally you can use to_date() to make a date value.

List of functions

Regards,
Bence

[shubham_1993]

Hi bence,

I have implemented the same logic but the logic seems to be a bit tricky as last days of some months might be coming in the next week so thats why i am facing the issue in hardcoding the dates which might end up failing in IBP going further.

For example 2024 is a leap year and last 3 days of december 2024 is going into the first week of Jan 2025.

And i have kept the first day of Q1 as 01.01 and keep on moving it by 7 days which is plus 1 week.

Could you please suggest a proper way of calculating the days in this regard.

Thanks

Shubham Shrivastava

[shubham_1993]

balazsbence95

Do you have other way to help me in any way?

As its a bit urgent for me

[balazsbence95]

Hi shubham_1993,

You may try using the week_in_year() function in your logic with the 'WW' (Absolute week number of the given date) or 'IW' (ISO week number of the given date) week type in the input parameter given to handle these particular days you mentioned.

Regards,
Bence

[shubham_1993]

Hi balazsbence95

There is one more quarter 5 coming in the table in case of a leap year.

So to calculation of the dates for normal and a leap year is different.

thats where i am getting stuck while calculating dates and while creating or hardcoding the dates by using query the word limit is only 3000 characters which is not allowing me to put any other logic.

Could you please let me know in this regard i need to complete this asap.

Thanks

shubham