Requirement –

Many times we have requirement to get the data of “value table of domain” inside BW infoobject. To solve this one we can create a generic extractor on this domain.


Step 1 –

Let say we have a table ZTEST1 and there we have field “ZZ_TERF” which has data element “PT_ZTERF”. This data element “PT_ZTERF” referring to domain “ZTERF”.

/wp-content/uploads/2014/01/pic1_355510.png

Value table for domain “ZTERF” –

/wp-content/uploads/2014/01/pic2_355538.png

Our objective here is to get this Value Range as a Text data for an infoobject in SAP BW.

Step 2 –

Once you are done with identifying domain, next step is to create a generic extractor for it. Goto RSO2. Provide the name of new extractor “Z_TEST1” and select Texts as a DataSource.

/wp-content/uploads/2014/01/pic3_355539.png

After clicking on Create button, next to enter Application Component and Description Part.


/wp-content/uploads/2014/01/pic4_355540.png


After that click on button “Extraction fr. Domain”.  This action will enable the “Extraction from Domain Fixed Values”. Select the right domain. In our case it is “ZTERF”.


/wp-content/uploads/2014/01/pic5_355541.png


Step 3 –

Save the extractor Z_TEST1.

/wp-content/uploads/2014/01/pic6_355542.png

Step 4 –

Replicate the extractor by selecting the right Source System name.

/wp-content/uploads/2014/01/pic8_355544.png

Step 5 –

Create an Infopackage and extract the data from source system. Click on “Start button”.

/wp-content/uploads/2014/01/pic7_355543.png

Once this activity is done then you can create/identify the right infoobject (Text data) and create transformation, DTP. As we have data in PSA, we can trigger DTP to pull the data from PSA to Infoobject level.

To report this post you need to login first.

4 Comments

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

Leave a Reply