Versioning Master Data
Attributes and hierarchies are available in two versions, an active (A) version and a modified (M) version. Texts are active immediately after they have been loaded. Existing texts are overwritten when new texts are loaded.
Attribute versions are managed in the P table and in the Q table. Time-independent attributes are stored in the P table and time-dependent attributes are stored in the Q table. From left to right, the P table contains the key fields of the characteristic (for example, 0COSTCENTER: CO_AREA and COSTCENTER), the technical key field OBJVERS (versioning), the indicator field CHANGED ID (versioning), and 0 or more attribute fields that can be display attributes or navigation attributes. The structure of the Q table is identical to the structure of the P table, with the addition of the 0DATEFROM and 0DATETO fields to map the time-dependency.
The OBJVERS and CHANGED fields must always be taken into account in versioning:
If you load master data that does not yet exist, an active version of this data is added to the table. If, when you reload the data, the value of the attribute changes, the active entry is flagged for deletion (CHANGED = D) and the M/I (modified(insert)) version of the new record is added.
You are loading master data for the 0COSTCENTER characteristic. After activation, the P table looks like this:
Later, you load new records. These new records are given the OBJVERS entry M and the CHANGED entry I. The available records, for which new data has been loaded, are given the OBJVERS entry D for “to be deleted”:
Before the new records can be displayed in reporting, you have to start the change run (see System Response Upon Changes to Data: Aggregate). During the change run, the old record is deleted and the new record is set to active.
BI reporting always reads the active version. InfoSets are an exception to this rule, as the most recent reporting function can be switched on in the InfoSet Builder. In such an InfoSet, the most recent records are displayed in reporting, even if they are not yet active.
For more information, see Most Recent Reporting for InfoObjects.