Skip to Content
Author's profile photo Former Member

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.

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Nicely explained the usage of Domain..Much appreciated.

      Regards,

      AL

      Author's profile photo CH Raman
      CH Raman

      Good to know about how to extract domain data.

      Thanks for sharing Amit.

      Thanks

      Author's profile photo Kamalakar Madineni
      Kamalakar Madineni

      good work

      Author's profile photo Shanthi Bhaskar
      Shanthi Bhaskar

      Glad to see this document..I had used this method a year  ago for extracting some ECC cockpit domains into BW.