Planning Book enhancement with Macros

[Former Member]

Hi

Currently SNP _ Batch palnning book is set up like below where data is captured for past 3 months

Initial      M 06 / 2013     M 07/ 2013     M 08/ 2013     M09 / 2013     M10/2013     M11/2013     M12/1013

               Past 3             Past 2             Past 1               Current

Now we want to change sep up like below. Initial column should have the data of past 3 month & period should start with current month

Initial      M 09 / 2013     M 10/ 2013     M 11/ 2013     M12 / 2013     M01/2014     M02/2014     M03/2014

=Past1     Current

+Past 2

+Past3

How to handle this scenario with micro builder?

Thanks

Sunil

[rajkj · Accepted solution]

Sunil,

You need to make a couple of changes.

1. Reinitialize your SNP planning area and create time series objects with 3 months in past and required number of periods into future.

• Setup a background job to extend the time series in same pattern periodically (use t.code /SAPAPO/TSINIT). For instance, assume initial setup is from 6/2013 to 8/2014 (i.e. 3months in past and 12 months in future - 15 months horizon). Next month the time series need to be extended by one month from 7/2013 to 9/2014 (i.e. drop one month in the past and add one month in future).

2. Update your planning book (t.code /SAPAPO/SDP8B) to remove defined time bucket profile for the past in data view SNP_BATCH.

Thanks,
Rajesh