Show TOC Entering content frame

Function documentationRealignment Locate the document in its SAP Library structure

Use

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.

This process is not valid for navigation attributes. See “Realigning” Navigation Attributes.

Features

The process consists of two major steps – Maintenance of the realignment table and execution of the realignment run.

The system also:

·        Copies notes to the target characteristic value combination, providing that in doing so it does not overwrite an existing note.

·        Changes generated selections (not manually created selection IDs) to reflect the realigned characteristic value combinations. These selections are used:

¡        To assign forecast profiles

¡        To assign alert profiles

¡        With consumption groups (descriptive characteristics)

·        Copies promotions, providing you delete the source characteristic value combination. When you realign a promotion, the system gives it ‘draft’ status in the new characteristic combination.

Working with Excel Tables

On the maintenance screen for the realignment table you can

·        Create an empty Excel table with the columns arranged correctly. This can be used as a template for entering steps in a table.

·        Import a table in Tab-delimited format.

Note

When entering data use the date format YYYYMMDD without delimiters, for instance 20040212.

You should also be careful when entering values with leading zeros. Depending on the characteristic the system deals with leading zeros differently:

§         Product

The system interprets the entries as defined in Customizing ( Advanced Planning and Optimization ® Master Data ®Product ® Set Output Format of Product Number. For more information, refer to the IMG and the F1 help for the Lexicographical field.

§         Other characteristics

If the characteristic is defined with type Character, each character is interpreted separately. This means 0001 is not the same as 01.

If the characteristic is defined with type NUMC- character string with only digits, leading zeros are not taken into account; 0001 is the same as 01.

·         

Restrictions

·        You cannot carry out realignment for CBF characteristics including the product. The characteristics for the CBF profile. table, and line are not visible in realignment. You can use the product as a selection criterion. It is possible to use realignment for the non-CBF characteristics in a CBF planning area.

·        Similarly you cannot carry out realignment for the DP-BOM characteristics 9APPNAME, 9ABOMID, and 9ABOMIO. The last two characteristics are not visible in realignment. You can use the product and 9APPNAME as selection criteria. 

 

Activities

Maintenance of the Realignment Table

       1.      To access the realignment/copy functions choose Demand Planning ® Data Administration ® Data Realignment.

       2.      If this is the first time realignment is being called for the master planning object structure, you must create a realignment table for the master planning object structure. On the Realignment screen, make sure that the Realignment radio button has been selected, enter the name of the master planning object structure and choose Create. A dialog box appears asking you whether you want to restrict the characteristics.

If you choose Yes, a further dialog box appears in which you can deselect individual characteristics. These characteristics are then not included in the realignment table.

Note

This means that the deselected characteristics cannot be changed. However the exiting characteristic values for the deselected characteristics are copied.

       3.      You can specify whether the system copies on a key figure basis. If you set the relevant indicator, two further indicators appear with which you can specify the key figures for which the data is copied or that are to be initialized, that is the contents are deleted.

       4.      You now maintain the individual realignment steps. Choose Maintain to see the overview of the existing steps. The status of a step is depicted with the following icons

This graphic is explained in the accompanying text

Realignment step has been executed successfully

This graphic is explained in the accompanying text

Draft status. Realignment step has not been executed yet;  it will not be executed in the next realignment run. To execute the step, change the status to Open.

This graphic is explained in the accompanying text

Open status. The step will be executed in the next planning run after the validity date.

You cannot maintain realignment steps in the overview screen.

Choose This graphic is explained in the accompanying text to create a new step, This graphic is explained in the accompanying text to copy an existing step and maintain the new step, or This graphic is explained in the accompanying text to change an existing step.

For details of the generic entries for a step such as the copy factor, see the F1 help for the relevant fields.

In the lower section of the detail screen you can now enter details of the characteristic values. There are two types of entry:

·         Selection entries

If you enter the same value in the From and To fields, only characteristic value combinations containing this value are selected, that is the old and the new combination contain this characteristic value.

·         New values

If you enter different values in theFrom and To fields, the system will in the realignment run read all characteristic value combinations that correspond to the values in the From fields. It uses these combinations to create new ones by replacing the values in the From fields with the values in the To fields. The system also creates new time series for the new characteristic value combinations.

The system then copies data from all key figures in the time series for the original characteristic value combinations to the new time series.

If you have set the Delete Source indicator, the original data is deleted and then the time series and characteristic value combinations.

You save the step. The system returns to the overview screen. 

After you have maintained all the necessary realignment steps, you can start the realignment run.

Executing Realignment

In general you run realignment itself periodically as a background job, for instance at night or during the weekend. This is important not only for performance reasons, but also to guarantee that characteristic values that are included in the realignment table are not locked by selections used in interactive planning or background planning.

       5.      To execute realignment in the background, on the initial realignment screen create a variant. To schedule the job, choose This graphic is explained in the accompanying text Run in Background. A log is written, which can be displayed by choosing This graphic is explained in the accompanying text Logs.

Note

To avoid data inconsistencies background execution is terminated after the first error. Previous realignment steps are not revoked.

...

To execute realignment online, choose This graphic is explained in the accompanying text.

Realigning InfoCubes

You use the same process as described above to realign InfoCubes that have a similar structure to the master planning object structure. The InfoCube must contain all the characteristics that are in the realignment table for the master planning object structure. 

You choose This graphic is explained in the accompanying text to select the InfoCubes that are to be realigned (you can select several InfoCubes). If you only want to realign the InfoCubes and not the master planning object structure, select the Only Realign InfoCube indicator.

 

Example

The following characteristic value combinations exist in a master planning object structure:

Number

Sales Organization

Location

Brand

Product

1

1000

0001

Standard

P1

2

1000

0002

Standard

P1

 

Planning data exists for combination no. 1.

       1.      You want to introduce a new product P2 into both locations, where the other characteristic values are the same as for P1. The expected demand is as for P1. You intend to continue to sell P1.

You create a new realignment step:

Copy Factor

100

Copy Logic

M

Delete Source

 

Sales Org.

From

 

To

 

 

Location

From

 

To

 

 

Brand

From

 

To

 

 

Product

From

P1

To

P2

 

Two new characteristic value combinations are created:

Number

Sales Organization

Location

Brand

Product

3

1000

0001

Standard

P2

4

1000

0002

Standard

P2

The data from combination no. 1 is copied to combination no. 3. As there is no planning data for location 0002 no data is created for combination 4.

If the Delete Source indicator had been set, the system would need delete the planning data for combination no. 1 and then delete combination 1 and 2.

 

       6.      You want to introduce a new product P3 into location 0001 only. However you only expect the demand to half that for P1.You create the following realignment step:

Copy Factor

50

Copy Logic

M

Delete Source

 

Sales Org.

From

 

To

 

 

Location

From

0001

To

0001

 

Brand

From

 

To

 

 

Product

From

P1

To

P3

 

In this case one new characteristic value combination is created

Number

Sales Organization

Location

Brand

Product

5

1000

0001

Standard

P3

The planning data from combination no. 1 is copied to combination no. 5 and multiplied by a factor of 50%. This factor is valid for all key figures.

Leaving content frame