Skip to Content

Applies to:

Industries which have implemented “SAP SCM-Demand planning” (Release version from 4.1…).

Summary

These documents describe step by step procedure of APO-DP realignment by using info-cube and its advantages.

Author: G.K.Radhakrishnan

Company: Accenture Services Pvt. Ltd.

Created on:18 April 2012

Author Bio

w1.JPG

G.K.Radhakrishnan, is working as a SAP APO-DP consultant in Accenture has a consulting experience of more than two years with a domain experience of 7years in supply chain.

DP realignment is a option to adjust data in planning area data as per business scenarios like changes in product hierarchy or sales hierarchy or a new product replacing old one. The main advantage of realignment over copy is that realignment creates the target CVC’s if they are not available in the POS.

Let us consider a master planning object structure TEST_POS as shown below.    (/sapapo/msdp_admin)

/wp-content/uploads/2012/04/image006_94160.jpg

A planning area  TEST_PA is created on the TEST_POS

/wp-content/uploads/2012/04/image001_93854.png

The planning area is initialized for 000 version.

/wp-content/uploads/2012/04/image003_93856.png

The POS has two CVC’s one each for product P1 and P2.

/wp-content/uploads/2012/04/image007_93858.png

Before realignment

As seen in the planning book ,sales history is available with the old product P1.But to generate the statistical forecast ,it will advisable to move all the sales history of Product P1 to product P2..

/wp-content/uploads/2012/04/image009_94161.png

/wp-content/uploads/2012/04/image011_94162.png

T-code for realignment  :/sapapo/rlgcopy

/wp-content/uploads/2012/04/image014_93864.jpg

Click on Create/ Change Table to select the characteristics for realignment .This is a one time activity .Once the realignment table is created ,click on Maintain entries tab.

/wp-content/uploads/2012/04/image015_94174.png

Delete Source option will result in deletion of source CVC’s

Copy factor can be used to make changes in the effect of realignment .The default copy  factor is 100 which is for 1:1 copy of data.

Business Scenario:

If a new product is expected to sell about half of the old product then the factor is changed to 50.

Copy logic: Copy logic=M is for overwrite the existing destination CVC  data with source CVC data  and Copy logic=A is for adding  the existing destination CVC  data with source CVC data.

Business Scenario:


If a company has two similar products P1,P2 and  P1 is being discontinued,then Copy logic =A can be used.This is due to the fact that sales of the discontinued product will be compensated by increased sales of P2  

Click on save and then the realignment step will be ready for execution.

/wp-content/uploads/2012/04/image017_93866.png

After that click execute  in the realignment main screen

/wp-content/uploads/2012/04/image019_94185.png

/wp-content/uploads/2012/04/image020_94184.jpg

As seen in the screen shot realignment could not be executed due to locking .When users are work in the edit mode planning book then POS gets locked.

This happens in large implementations when  users are working in different time zones.So to execute the realignment time window needs to be given by business.

After all the users are out of planning book or change to display mode  realignment can be executed and same is visible in the logs shown below.  

/wp-content/uploads/2012/04/image022_93868.jpg

As show below ,sales history has been copied to destination product P2.

/wp-content/uploads/2012/04/image023_93869.png

To address the issue of locking info-cube realignment can be used .

The additional step of info-cube realignment is creation of  planning area extraction flow which is explained below.

Goto S&DP Administration (/sapapo/msdp_admin)  and select planning area .Go to change planning area.

Click on Data Extraction tools as shown

25_a.PNG

Click on Generate Data Source.Give the name of the data source .All the planning area data sources will start with 9A.

27_a.PNG

Now select the fields for data selection and hide the ones that are not needed. Usually  proportional factors is not extracted from planning area.

/wp-content/uploads/2012/04/image029_93876.png

Planning area data source will be generated as show below.

/wp-content/uploads/2012/04/image031_93877.png

Click on Data backup

/wp-content/uploads/2012/04/image033_93878.png

Give the name of the backup cube and info-area

/wp-content/uploads/2012/04/image035_93879.png

Click No to exclude proportional factor.

/wp-content/uploads/2012/04/image037_93880.png

Info-cube will be successfully activated as show below

/wp-content/uploads/2012/04/image039_93881.png

Info-cube will be visible in the specified info-area in RSA1

/wp-content/uploads/2012/04/image041_93882.png

Now the 9A data-source has to replicated as show below.

/wp-content/uploads/2012/04/image043_93883.png

Data source needs to replicated either as BI7 data source or 3X data source

/wp-content/uploads/2012/04/image045_93884.png

The below screen shots are for BI7 flow

/wp-content/uploads/2012/04/image047_93885.png

If the data-source is inactive then activate the same.

/wp-content/uploads/2012/04/image049_93886.png

/wp-content/uploads/2012/04/image055_93887.png

Now transformations needs to be created from data source to the backup cube

/wp-content/uploads/2012/04/image057_93888.png

/wp-content/uploads/2012/04/image061_93889.png

Create DTP to load the data from PSA to backup info-cube

/wp-content/uploads/2012/04/image063_93890.png

Create Info package to extract the data from planning area to PSA.

/wp-content/uploads/2012/04/image067_93891.png

/wp-content/uploads/2012/04/image069_93892.png

As shown below 254 records are extracted from planning area to  PSA.

/wp-content/uploads/2012/04/image071_93893.png

Execute the DTP to load the data from PSA  to Info-cube.

/wp-content/uploads/2012/04/image075_93895.png

To use the  option of info-cube realignment ,click on choose info-cube and select the backup cube PA1. 

Untitled.png

Finally all the steps of cube realignment can be automated  with a process chain as shown below.

chain.JPG

The CVC Creation step in the process chain is needed as the realignment when executed in the info-cube does not make any changes in the POS or planning area. Also note that Delete Source option will not  delete of source CVC’s in the POS  but will make the data for source CVC’s in backup cube to zero.

Related Content.

http://help.sap.com/saphelp_scm50/helpdata/en/61/7ade603472c447b0bb52d67391683e/frameset.htm

http://scn.sap.com/thread/1667349

http://scn.sap.com/thread/1378372

http://scn.sap.com/thread/1516817

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. Will Foster

    Question:  Have you tried using the C_APO_RLG authorization object to control access in the SAPAPO/RLGCOPY transaction?  We have tried to leverage that Auth Obj to limit peoples access to “execute” realignment, but it doesn’t seem to have any influence.  It’s like the auth obj is NOT getting called

    Thanks,

    Will

    (0) 
    1. Radhakrishnan G K Post author

      Hi Will

      In most of the projects, realignment is carried out by support team and not by end user as the impact is high and difficult to correct any mistakes.

      (0) 
      1. Will Foster

        Radgk,

        That is why we’re trying to leverage the C_APO_RLG auth obj, because we want to remove peoples ability to ‘execute’ Realignment.  We have given our users authorization to CREATE realignment steps via a custom upload tool.

        Interesting point about support executing all the realignment steps.  So in that scenario how to the users communicate the realignment needs?  Send an xls list with all the realignment steps to support, then support uploads the values and executes realignment?

        Thanks for the information.

        (0) 
        1. Satish Waghmare

          Many Thanks Radgk for useful information. Keep it up 🙂

          Hello Will

          In my past few project I had prepared a Excel template to be updated by Users with realignment step details and then sent to Super User. And then Super User to review the records from template and upload in Application Server(AL11).

          Using uploaded file in AL11, creation of realignment steps and running of realignment will take place through a background jobs.

          This is not fully automated option, but it worked well with few of my clients.

          Thank you

          Satish Waghmare

          (0) 
  2. Adam Cook

    Nice step by step article.  Only issue I see here is the timing of moving data in and out of PA to Cube.  In some production   systems you are talking about millions of rows of data depending on the time series. In Many cases for forecasting we backup 3 years history and 2 years future.  In my case it can take >10 hours just to load data from planning area into an infocube.  Anybody have similar experiences and suggestions on increasing performance?

    (0) 
    1. Radhakrishnan G K Post author

      Hi Adam

      This method is mainly for small selections like a couple of products which are needed regularly every week  ( particularly in FMCG ) . For major changes this method will not work.

      Usually for major changes we will need couple of days downtime or a week downtime.This may  involve other systems too like  master data changes in ECC , loading the same in BW 

      (0) 
  3. Satish P

     

    hi, if the realignment is executed by process chains using infocube, will it not have any planning book locking issues

    (0) 
    1. Radhakrishnan G K Post author

      yes, but the lock is limited to a small selection like a product or two .  In case of the ordinary realignment the lock happens at the entire planning area level.

      In the standard process , if we have 100 demand planners  then we need to ask all of them to be out of the system even for realignment of a single product.

       

      In case of Cube we can ask two or three planners who are responsible for the product to be out of system for a few min .

      So this process is more for a global system which huge number of planners working all the time .If your system has very less users then I don’t recommend it .

       

       

      (0) 

Leave a Reply