Industries which have implemented “SAP SCM-Demand planning” (Release version from 4.1…).
These documents describe step by step procedure of APO-DP realignment by using info-cube and its advantages.
Company: Accenture Services Pvt. Ltd.
Created on:18 April 2012
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)
A planning area TEST_PA is created on the TEST_POS
The planning area is initialized for 000 version.
The POS has two CVC's one each for product P1 and P2.
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..
T-code for realignment :/sapapo/rlgcopy
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.
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.
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.
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.
After that click execute in the realignment main screen
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.
As show below ,sales history has been copied to destination product P2.
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
Click on Generate Data Source.Give the name of the data source .All the planning area data sources will start with 9A.
Now select the fields for data selection and hide the ones that are not needed. Usually proportional factors is not extracted from planning area.
Planning area data source will be generated as show below.
Click on Data backup
Give the name of the backup cube and info-area
Click No to exclude proportional factor.
Info-cube will be successfully activated as show below
Info-cube will be visible in the specified info-area in RSA1
Now the 9A data-source has to replicated as show below.
Data source needs to replicated either as BI7 data source or 3X data source
The below screen shots are for BI7 flow
If the data-source is inactive then activate the same.
Now transformations needs to be created from data source to the backup cube
Create DTP to load the data from PSA to backup info-cube
Create Info package to extract the data from planning area to PSA.
As shown below 254 records are extracted from planning area to PSA.
Execute the DTP to load the data from PSA to Info-cube.
To use the option of info-cube realignment ,click on choose info-cube and select the backup cube PA1.
Finally all the steps of cube realignment can be automated with a process chain as shown below.
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.