SNP DataView to open with a past period bucket (not with the current bucket)

[thomas_schulze2]

Hello experts,

we have a requirement that an APO-SNP planning book / DataView with granularity "monthly buckets" is opening not with the current month but with a month in the past.

Example: current month = 11.2023 --> I want this DataView to open the month bucket being 6 months backward from current (05.2023).

I played with the Planning Book Wizard settings () including the time buckets profile - but I cannot see how to achieve this. There is an "Offset" but SAP does not allow to use a negative value (Example: -6 to open the DataView always starting with < current month - 6 >).

This works perfect if you create an SDP alert (AOT4000) for a bucket in the past -> navigation from AlertMonitor into this //SDP94 SNP DataView opens the view starting with the month the alert context belongs to.

Any ideas - or do I need to use a SDP94 BADI/UserExit to achieve this ?

Regards

Thomas

[thomas_schulze2]

For the ones reading the post - we believe we found a fairly stupid simple solution:

In my screenshot of the Planning Book Wizard you see the field "Planning Start". You basically enter a fixed date the DataView should always open with as a first period - which of course in an environments where "rolling planning" happens is of no use. The date is stored in table-field /SAPAPO/PBVWHDR-TBID_START and it seems there is no other magic behind if you finish the wizard (like ABAP code generation to embedd the date somewhere else).

We created a 10 liner ABAP to set this date in the background to the first day of the month from today - 6 months ... thats it. The program will be scheduled in background on every 1st of the month to bring the "fixed" date 1month forward. Means, you can misuse the fixed "planning start" to make it rolling if you want SDP94 to open with a past period bucket and not with the current one.

Disclaimer: try / use it on your own risk !

Regards

Thomas