SAP IBP Keyfigure value for last day of the month

[victorhugo_leao]

Hi experts!

I'd like to set a keyfigure calculation to define a value for the last day of the month.

Let's say:

If 'last day of the month', '1', '2'.

Is there any condition to test the period as last day of the month?

Thanks a lot!

Best regards!

Victor

[Andrei_Lupu · Accepted solution]

Hi @victorhugo_leao ,

This is what the IBP_LPA function does behind the scenes : it finds the last period and it aggregates the values. Unfortunately it is not useful in this case.

There is a manual solution to display the last day of month: you will need to create a new attribute (integer type), assign it to time profile, update the time profile and then display it within a KF :

1. Create a new attribute (ZLASTDAY) of Integer type.

2. Browse the time profile used by the Planning Area -> edit -> select the Day level ->  Assign Attribute (ZLASTDAY). Check and activate the time profile

3. Data integration -> download the Time Profile with existing time periods -> populate the new column (ZLASTDAY) - this is where you will manually have to enter a value ("1") for each last day of the month. 

4. Upload the new time profile CSV.

5. Head over to the Planning Area -> browse the Planning Levels with Day (eg DAYPRODLOCCUST) -> Edit -> Change Assignment -> Select ZLASTDAY attribute. Check and Activate the PA

6. Create a new KF (ZLASTDAYOFMONTH) @ DAYPRODLOCUST = IF(ISNULL("ZLASTDAY"),0,1) - in the additional inputs you will need to add a KF populated at this level (eg Actualsqty). Check and Activate the PA

7. Display the new KF (ZLASTDAYOFMONTH) in the PA .