In this document, the usage of Read Master Data rule type in Transformation will be explained.
Read master data in transformation arises when we don’t have field directly in source side. The field for which data has to be populated will be an attribute as a field in source side.
In this document, I’ll be explaining by taking 0BASE_UOM and 0MATERIAL as the fields. We have 0MATERIAL in the source and we need 0BASE_UOM in the target.
0BASE_UOM is not available in source directly but we have 0MATERIAL.
In target (DSO in this case), we have 0BASE_UOM as a field, data has to be written to that. 0BASE_UOM is an attribute of 0MATERIAL. Hence we use READ MASTER DATA in the transformation – reading 0BASE_UOM value from 0MATERIAL.
Below are the steps mentioned how to achieve Read Master Data rule in transformation.
1. In transformation, map 0MATERIAL in source to 0BASE_UOM in target.
2. From the context menu of the rule, select Rule Details or double click the rule. A separate window opens showing the rule details.
Select Rule Type as Read Master Data.
3. Select 0MATERIAL against IOAssgnmnt by hitting F4 and then search 0MATERIAL. We select 0MATERIAL as this info-object is related to DataSource field MATNR.
We can also type 0MATERIAL directly if we know the technical name.
4. Against From Attrib of – type 0MATERIAL or press F4. This will pop-up 0MATERIAL directly. Because target has this info-object (0MATERIAL) whose attribute is 0BASE_UOM.
Now click TRANSFER VALUES.
Activate the transformation and load data.
Hope this document will be useful.