Realignment process in APODP in 5.0

[former_member309586]

Hi Gurus,

Can any one explain me step by step of realignment process in APO 5.0

It will be really great help as i need it urgently

I will be very thankfull to you guys

Thanks a Lot

Regards,

Raj

[Former Member · Accepted solution]

Hello Raj-

Take a look at the following Links it will give you a step by step procedure of realignment Process in APO DP along with examples.

http://help.sap.com/saphelp_scm50/helpdata/en/8f/9d6937089c2556e10000009b38f889/frameset.htm

Hope this helps.

Regards,

Suresh Garg

[former_member309586]

Solved thanks

[Former Member]

Hi Raj,

Tcode for Realignment is /SAPAPO/RLGCOPY.

Realignment : In this process you generate new characteristic value combinations based on existing combinations and copy data from the source combinations to the new combinations. You can specify that the original values of both the characteristic values and the data are deleted.

Copy: You use this function to copy data from one or more characteristic value combinations to other combination within a planning area. It is very similar to realignment. However no characteristic values or combinations are created. The copy steps are only valid for one planning area. As a result you can select which versions and which key figures are copied.

There will be generated Realignment table for MPOS. use FM /SAPAPO/TS_RLG_TABLE_GET to get tablename where realignemnt records are stored..

Regards,

Srinivas

[Former Member]

In addition to above...

use transaction /SAPAPO/RLGCOPY - Data Realignment

on the first screen of the transaction you will able to choose Realignment or copy buttotn.

By default it is Realignment

Realignment Run Properties section :

Enter Planning object structure name.

If first time you are executing this transaction then select the tab <b>Create/Change Table</b> Select the char which you want to realign

Save it

Select the Tab Maintain the entries

Here you will get the Overview of Realignment Table

Create Step:

In teh realignment Step Setting section

By default Step Status is Blank, Validate date : Current system date

and Delete Source is not selected.

Keep it is as default if you do not want to delete the soursce after the realignment

Settings Valid for Multiple Planning Areas

Copy Factor - 100 and Copy Logic : M for Overwrite as default.

Keep it as default if you do not want any other settings.

In the Copy logic you have to options <b>M</b> for overwrite and <b>A</b> for Add

In the realignment Ste: Detail select the Characteristics Source to Destination values

and save the Step

Come out from the Maintain entries

In the first screen of the transaction you can see

Key figures section here by default redio button is selected for All Key Figures

If you want to do the realignment for selected key figure then choose the redio button individual Key figure

then you will get Choose key figures duble click on the button infront of the Choose Key Figure ... Here you will require to select the Key figure for which you want to do the realignment

Choose the Key figures to be inintialized ... choose the those key figures for which you want to inintialize the value.

In the Infocube section If you want to realign the Infocube data then only maintain the entries in this section

Activate the Application Log

Then Execute the transaction

This the way you will do the realignment.

For your understanding you can devide it in diffrent scenario and run the transaction and see the effect of it. Secnerio can be as below

Planning object structure level

1) for all Key figure realignment as per the Characteristics

2) for selected (Individual) Key figures

3) Copy Logic - M or A

4) Factor level 100, 50 etc

5) Initialization of the Key figures

6) Delete Source

Infocube level structure level

1) for all Key figure realignment as per the Characteristics

2) for selected (Individual) Key figures

3) Copy Logic - M or A

4) Factor level 100, 50 etc

5) Initialization of the Key figures

6) Delete Source

Before the realignment take the snap shot of the planning book data and after the realignment. Compare it. It works fine.

You can schedule it in the background also.

[Former Member]

Hi Raj,

Firts, you have to create the steps for the cvc's that you want to realign.

You can select which combination of characteristics want to move to another. And you can select a copy factor too, this copy factor multiplies the value of the source, for example if you want to realign product A with 50 units to product B and you specify a Copy Factor of 200%, you obtain product B with 100 units.

You need to specify a Copy Logyc, you can use two values: M if you want to overwrite the existing values in target cvc's, or A if you want to add this values to target cvc's. For example if you have product A = 50 units and product B = 30 units and you select M so when you realign product A to Product B you will have Product B = 50, but if you select A you will obtain Product B = 30+50 = 80.

If you mark Delete Source check box, the system deletes the source CVC's and send negative records to nulify the actual records in the cube. For example if you have a CVC for Product A and a record for Product A = 50, you will have after realigning no CVC for Product A and two records in cube Product A = 50 and Product A = - 50.

The Step Status must be set to Realignment step is ready to be performed in order to be available for use.

You can select in infocube section which infocube do you want to realign, if you only want to realign the infocube, with this option livecache is not realigned, and if you want to completely remove sources for infocube, with this selection the system deletes the realigned source records.

This subject is very extensive, so i have this can help you.

Regards.

Marín.