Skip to Content

Create generic extractor to get the Value Table of Domain

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.

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