Skip to Content

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.

Scenario :

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.

DS.jpg

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.

Target.jpg

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.

TRFN-After map.jpg


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.

RMD.jpg


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.

RMD-1.jpg

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.

RMD-2.jpg

Now click TRANSFER VALUES.

5. Now in transformation, we can see new rule available for target info-object 0BASE_UOM indicated by MD.jpg

TRFN-After.jpg

Activate the transformation and load data.

Hope this document will be useful.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. HS Kok

    I rarely make use of this method to read an attribute, because there is a performance hit associated when using such an approach.

    The faster way is to code an ABAP routine in the mapping rules (as disgusting as it sounds).

    (0) 

Leave a Reply