Inventory when aggregated at Montly Level if LPA Gives NULL Values

[Former Member]

Hi ,

In the current IBP Version as per Standard Planning Area , For Key figure Current Inventory we have IBP_LPA Aggregation, Which gives the value of Last period.If the Last period is zero/Null.The IBP_LPA Gives Zero value when aggregated.

We have a requirement if Last period is NULL/Zero in the Base Level.It should show the last period which is not NULL.Can you please suggest a solution for this requirement.

Example :

Below we have 5 Technical Weeks for Jan so When we use IBP_LPA , it gives value Zero when Aggregated at Month Level View.

My Requirement is that i want to view the Last Period which is not NULL .I need to have 1000 at Montly Level.

Thanks

Sunil M

[piyush_parekh · Accepted solution]

Hi Sunil,

Here is a probable solution but a little complicated and involves lot of intermediate key figures.

The calculation for each intermediate KF is as below:

KF1 : If source KF = NULL then NULL else 1

KF2 : KF1 x PERIODID | Keep aggregation mode of KF2 as "Max"

KF3: IF (0=1,KF3,1) This key figure will have calculated value equal to 1 in all periods.

KF4 : KF2@MTH level x KF3 (calculated value equal to 1 in all periods)

KF5 : If KF4 = KF2 then source KF else NULL | Keep aggregation mode of KF2 as "SUM"

KF6: KF5@MTH x KF3

KF7: IF source KF is NULL then KF6 else source KF

KF8 : IBP_LPA logic with KF7 as source. Call KF8 at request level of source KF.

Hope this helps!! Please post if you come across a simpler solution.

Regards,
Piyush

[former_member654033]

What is your expected behavior from IBP here?

If you just want the values then don't use LPA, please use SUM/AVG/MAX whatever suits your requirement

[former_member591269]

Hi Sunil,

As per the current functionality, Data available in the last Technical week of the month will be displayed at the Monthly level.

I would suggest you to raise an improvement idea to SAP using below link.

https://influence.sap.com/sap/ino/#

Thanks & Regards,

Pradeep K C

[Former Member]

Hi Pradeep

We are using Dynamic LPA Only.

The Issue is if the last technical Period is NULL for the Month.it should show the latest Technical Week value which is not NULL.In my example TW1b2020 is having the value so when check at Month it is show 1000 but shows blank because the last period TW05a 2020 is blank according the LPA Logic.

In your example also make TW05a 2020 blank and you will see the value as Blank at Jan 2020 Month Level.

Thanks

Sunil M

[former_member591269]

Hi Sunil,

I think you are using static LPA. that is the reason you are getting 0 at aggregated level.

You can achieve it through dynamic Last Period Aggregation.

Kindly go through below SAP help document for more details

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/1911/en-US/8280eea63c914d8e95eecd322e5a...

Thanks & Regards,

Pradeep K C