Creating Transformations for Master Data of Characteristic "Prod (SAP Library

Creating Transformations for Master Data of Characteristic "Product"

Use

You create transformations for the attributes and texts of characteristic Product (ZD_PROD).

Note

The master data for the characteristics Product Group and Channel will be created later directly in the system. No transformations are therefore required in our scenario for these characteristics.

Procedure

...

1. You are in the Modeling functional area of the Data Warehousing Workbench.

2. Choose This graphic is explained in the accompanying text InfoProvider.

3. Choose Create Transformation... from the context menu at the symbol for texts This graphic is explained in the accompanying text under your InfoObject Product (ZD_PROD).

4. Select object type DataSource as source of the transformation and select your DataSource for texts ZD_PROD_TEXTS and source system PC_FILE.

5. Choose This graphic is explained in the accompanying text Create Transformation.

The maintenance screen for the transformation appears. The fields of the DataSource are displayed at the left and the rule group with the target InfoObjects at the right.

6. With the mouse, connect the DataSource fields with the target InfoObjects as follows:

DataSource Field	InfoObject
PRODID	ZD_PROD
PRODDESC	0TXTMD
LANGUAGE	0LANGU

This graphic is explained in the accompanying text

7. Activate your transformation.

8. Exit from the transformation maintenance screen.

9. Choose Create Transformation... from the context menu at the symbol for attributes This graphic is explained in the accompanying text under your InfoObject Product (ZD_PROD).

10. Select object type DataSource as source of the transformation and select your DataSource for attributes ZD_PROD_ATTRIBUTES and source system PC_FILE.

11. Choose This graphic is explained in the accompanying text Create Transformation.

The maintenance screen for the transformation appears.

12. With the mouse, connect the DataSource fields with the target InfoObjects as follows:

DataSource Field	InfoObject
PRODID	ZD_PROD
PG_ID	ZD_PGROUP
CURRENCY	0CURRENCY
PRICE	ZD_PRICE

This graphic is explained in the accompanying text

13. Activate your transformation.

Result

You created the transformations for the master data for characteristic Product and have now completed all preparation for creating and executing the load processes for the attributes and texts of characteristic Product.

Continue with ...

Creating Transformations for InfoCubes