How BW Maintain Characteristic Data - SAP BW

If characteristic data have been changed,we must activate the change before BEx Analyzer can display the new data. First we show how BW manages the history of characteristic data changes.

In Screen,we change material number MAT003's name and short description from COOKIE and Fortune cookie,to SNACK and Popcorn,respectively.

Note:To change a data entry,select the data entry and then clickpen.

Characterstic IO_MAT-Maintain master data

The change we made in Screen results in a new entry and a modified entry in the underlying database table /BIC/PIO_MAT (Screen). There,the A in the OBJVERS column indicates that the corresponding entry is active,and the M indicates that the corresponding entry is modified and to be activated. The D in the CHANGED column indicates that the corresponding entry is to be deleted,and the I indicates that the corresponding entry is a new one.
Data Browser : Table /BIC/PIO_MAT Select Entries

Next,we create a query to display IO_MAT's attribute IO_MATNM. To do so,in the query definition window ,right-click Material number and then select Properties.
Define the query

In the pop-up window, select and move Material name from the Available attributes area to the Selected attributes area.
Characterstic Properties For Characterstic Material Number

Click okto return to Screen. After executing the query,we see the result shown in Screen.

Here we see that the text short description has changed to Popcorn; however,the material name remains COOKIE. This phenomenon tells us two things:

  1. A query always retrieves the current texts. The text table does not save the history of changes.
  2. A query always retrieves active master data. In our case,COOKIE is the old but currently still active master data.

To make the Screen change become reflected in this query,we need to activate the change. The procedure follows.

Work Instructions:
Step 1. Right-click the characteristic IO_MAT,and then select Activate master data.
Work Instructions

After clickingclicking in Screen to refresh the table contents,we get the result shown in Screen 12 Now the change becomes active,and the old record is deleted. If we refresh the query result in Screen,we will see that the MAT003 material name has changed to SNACK.
Data Browser : Table /BIC/PIO _MAT select Entries

The following procedure describes another way to activate characteristic data changes. The new procedure can be applied not only to master data changes, but also to hierarchy changes.

Work Instructions:
Step 1. From the Administrator Workbench screen,select the Apply Hierarchy/Attribute change… item on the Tools menu.
Work Instructions

Step 2. We can schedule the activation by clicking. A new window like Screen will then open in which we can schedule the background activation job. Alternatively,we could activate the change immediately by clickingexecute .
To list changed characteristics,clickinfo-obj-list.
Execute Hierarchy/Attribute changes for reporting

Step 3. IO_MAT is listed in Screen because,after activating the IO_MAT data is Screen,we made another change to the IO_MAT data.
IO_MAT is selected by default to be activated. We accept the default and close this window.

If we clickexecute in Screen,a background job will start immediately to activate the new change to the IO_MAT data.
We have now answered the first question raised at the beginning of this chapter.

Note:You cannot delete characteristic data if they are used by other BW objects. SID table contents can reveal the status of characteristic data. The X in column DATAFL indicates that an InfoCube uses the corresponding entry,and the X in column INCFL indicates that a hierarchy uses the entry.
Data Browser: Table /BIC/SIO_MAT select Entries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

SAP BW Topics