Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Read Master Data in BW Transformation


     I am using BW 740 SP02 and I need in a transformation rule to use the option "READ MASTER DATA", In fact this enables me to use all attributes of an infoObject and affect them to my data target ( Infocube).

     I was wondering if there would be any possibility to affect also master data text of an infoObject and affect them to a data target?

I know that master data text are available through Bex queries, but for my case I need to have them in my Infocube.

Best Regards,



Hi Mohamed,

Using standard rule type this is not possible

However there are two ways to achieve this:

1. you use abap routine to read the text value from text table of info object (BIC/Txxx) in transformation

2. a. add a char info object to your master data

    b. create another transformation from text data source to populate this new field (which is actually text)

    c. create DTP to populate this new field with text values

    d. now you can easily use, 'read master data' rule in transformation and assign the text field to your target field

hope this helps,


1 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question