Assigning InfoObjects for Reading Master Data BW BI Transformation Creating Transformations

An InfoObject has to be assigned to a source field of a DataSource if master data needs to be read.

1.

With SAP NetWeaver 7.0 SPS 14, you can update navigation attributes of InfoCubes and DataStore objects instead of reading master data.

2.

With SAP NetWeaver 7.0 SPS14 the performance when reading master data was optimized. With the new procedure, the master data is no longer read for each key in the data package with a SELECT command. Instead, all the master data of the data package is stored temporarily (prefetch service) and further processed from the temporary store. This reduces the number of database accesses and improves the performance when reading master data. The new procedure is set by default. You can switch back to the old procedure in the program SAP_RSADMIN_MAINTAIN (transaction SE38).
For more information, see SAP Note 1092539.

Procedure

...

1. You are in the rule details. Select the rule type Time Update or Read Master Data.

2. Select an InfoObject in the InfoObject Assignment field in the Source Fields of Rule area.

3. Fill out the field From Attrib. of.

4. If the InfoObject is time-dependent, you usually have to add a time characteristic before you can specify the period. This must be an SAP time characteristic (0CALDAY, 0CALWEEK, 0CALMONTH, 0CALQUARTER, 0CALYEAR, 0FISCYEAR, 0FISCPER). To do so, choose Add Source Fields ( ) in the Source Fields of Rule area and then select a time characteristic.

5. Determine the time at which the master data needs to be read - on the current date (sy-date), on a constant date that you enter directly, or at the beginning or end of a period (determined by the time characteristic). To do so, choose Key Date Determination.

6. Choose Transfer Values.

Example

In your transformation, you want to assign the CUSTOMER field of the DataSource to the 0COUNTRY InfoObject in your target. To do so, you assign the 0CUSTOMER InfoObject to the CUSTOMER field in the rule details so that the attribute 0COUNTRY in 0CUSTOMER can be read.

To be able to specify time dependence for reading master data, assign the CALDAY field to the 0COUNTRY rule as an additional input field. The CALDAY field of the DataSource also needs an assigned InfoObject. Assign 0CALDAY to it so that 0CALDAY's properties can be read. Then enter a time.