Show TOC

Reorganizing Master DataLocate this document in the navigation structure

Use

You can reorganize the dataset for texts and attributes belonging to a basic characteristic. The reorganization process finds and removes redundant data records in the attribute tables and text tables. This reduces the volume of data and improves performance.

Features

For a given basic characteristic, the system firstly compares data in the active and modified versions of the time-dependent and non-time-dependent attributes with each other. If there are no differences between the active and the modified versions, the redundant data is compressed. In a second step, the system checks time-dependent texts and attributes to see whether time intervals exist with identical attribute values or text entries. If this is the case, the affected time intervals are combined into larger intervals.

Note

Firstly, the attribute Cost Center Manager (0RES_PERSON) is changed (as the only attribute) for a Cost Center and then reset to its original value using a second load process. Therefore, the name of the Cost Center Manager has not actually changed. In this case, the reorganization means that the data record is deleted for the changed version (M version).

For a Cost Center, the same person is entered as Cost Center Manager for the period 01.06.2001-31.12.2001 and for the period 01.01.2002 -31.03.2002. The process of reorganization combines these two intervals into one, providing that the other time-dependent attributes for the cost center are consistent across both intervals.

You can carry out the master data reorganization process as a process type in process chain maintenance.

Activities

During master data organization for attributes and texts, the system sets locks preventing access to the basic characteristic currently being processed. These locks correspond to the locks preventing the loading of the master data attributes and texts. This means that it is not possible to load, delete or change master data for this characteristic during the reorganization process.

When assigning locks, the system distinguishes between locks for attributes and locks for texts. This means that you can load texts for this characteristic during a reorganization that only affects attributes, and vice versa.