New key figure Projected Opening Stock

[kimon_stergakos]

I have a requirement to build a key figure that will be a copy of Projected Stock. The difference is that I want the quantity in the following month to reflect a Projected Opening Stock. I have an example in the attached screen shot. The new key figure is highlighted in yellow named "Projected Opening Stock". Note the Projected Stock for Dec-21 is the Projected Opening Stock for Jan-22 so on and so forth.

[AyanBishnu]

Hello kimon.stergakos

The issue is happening becuase you are using the standard projected stock KF, which is a ouput KF for heuristic / optimizer, and it is at TWK. what you need to is the following.1) Create a new KF for projected stock at MTHPRODLOC. Use the CAGGR function to calculate the projected stock at monthly level.2) now in the KF Projected Opening Stock use the offset by 1 and use the KF mentioned above as input to PERIOD_OFFSET.That will solve your problemregardsayan

[kimon_stergakos]

Hello Ayan,

Thank you for the response. I am new to the key figure creation. I will try. I am assuming just to copy the Projected Stock to something like Projected Stock Month and replace everything in the calculation with MTHPRODLOC.

Sincerely,

Kimon

[AyanBishnu]

Hello Kimon

Its not about copying the value from the standard projected stock KF. what you need to do is calculate the projected stock in a new KF which will be in months. The projected stock can be caluclated in the KF using the function IBP_CAGGR in the calculated KF.

the syntax is as follows

KF@MTHPRODLOC= IBP_CAGGR("SUM_DEM_RECPT@MTHPRODLOC",''SUM'',''FORWARD'',''CURRENTFUTURE'')

For details please check the URL below

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2111/en-US/adbc9b3674544184936e4029f642...

[kimon_stergakos]

Thank you Ayan.

I tried to understand the documentation in the link you provided. I tried some configuration variances but had not luck. I don't even have a MTHPRODLOC level in my system. At this point it may be over my head. Unless there is a more specific configuration that you can provide I appreciate everyone's attempt to help me.

[former_member654033]

Hello,

You can try period shift function to shift the Project stock key figure values by 1 period.

Thanks

Girish

[kimon_stergakos]

Hello Grish,

I tried what you suggested, and it seems to be the way to go. Unfortunately, I may not know enough to get exactly what I want. When I used the IBP_PeriodShift function it worked for the Technical Week view. The Week view seems to give irregular numbers when the weeks cross the month. The month level is way off. I am attaching screenshots with the examples and my key figure configuration. I hope you can help.

[kimon_stergakos]

hello Grish screenshots continued.

[kimon_stergakos]

Hello Grish, here is the last of the screen shot for the setup.

[rajtiwari]

Hello kimon.stergakos

We have observed the example pasted in your queries Projected stock period values are same Projected Open stock same value for Period +1. You have to use period shift function for one month (Current Period +1). So you get the value for Projected open stock.

Thanks

Rajesh Tiwari

[kimon_stergakos]

Hello Rajesh,

See the additional screen shots after Grish's answer. I used the ibp_period shift but it is only working for the technical week, not for week and month levels. Can you guide me towards how to get the week and month levels working properly.

Sincerely

Kimon

[former_member654033]

Hi Kimon,

You have to aggregate your projected stock KF at MTHPRODLOC (Use existing KF or create a new KF at MTHPRODLOC) and then do period shift by 1 period.

Thanks

Girish