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 click.
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.
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.
In the pop-up window, select and move Material name from the Available attributes area to the Selected attributes area.
Click to 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:
To make the Screen change become reflected in this query,we need to activate the change. The procedure follows.
Step 1. Right-click the characteristic IO_MAT,and then select Activate master data.
After clicking 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.
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.
Step 1. From the Administrator Workbench screen,select the Apply Hierarchy/Attribute change… item on the Tools menu.
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 clicking .
To list changed characteristics,click.
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 click 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.
SAP BW Related Interview Questions
|SAP BI Interview Questions||SAP WM Interview Questions|
|SAP BO Interview Questions||SAP Netweaver Interview Questions|
|SAP BODS Interview Questions||SAP Webi Interview Questions|
|SAP Web Dynpro Interview Questions||SAP BDC Interview Questions|
|SAP BW on HANA Interview Questions|
Sap Bw Tutorial
Business Scenario And Sap Bw
Creating An Infocube
Loading Data Into The Infocube
Checking Data Quality
Creating Queries And Workbooks
Managing User Authorization
Aggregates And Multi-cubes
Operational Data Store (ods)
Generic R/3 Data Extraction
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.