Skip to Content

Extracting data from Domain (Text Master data)

As we know that there are many things in SAP which are getting improved day by day, new things are coming and there are many things which we didn’t explored yet.

In current assignment, we came up such scenario where we found one good thing about Text Master data which extracts domain values and this thing was not explored. May be this is because we don’t refresh the knowledge until and unless we required in project after formal training. Another reason perhaps that we just play around extractions which uses ‘Table/View’, ‘InfoSet Query’ or ‘FM based extraction’ options.

In previous SAP BI assignments, we had maintained Domain values either manually or Flat files (may be because of lower version of SAP). But many of the clients do not prefer manual intervention in their Prod systems. So only one option left behind and that was load domain values through Flat files as Text Master data.

Domain Values

Suppose, you want to extract Domain Values of for example, STAZS field (Status of the payment lot) of table DFKKZK (Payment lot: Header data). Find out that field’s Data Element. Through Data Element you will find Domain. Here, STAZS field has Data Element as STAZS_KK and Domain as STAZS_KK.  (Application Area: SAP ISU)

STAZS_KK Domain Values

When you enter to Domain, you will see domain fixed values on tab ‘Value Range’.


Domain Values

Loading Domain value as Text Master data:

1. In RSO2 transaction, select DataSource as ‘Texts’ and provide valid name.


2. Press Create button.

3. On next screen, enter valid Application Component and description of the DataSource (Short, Medium and Long).

4. On the same screen, you will see 4 below extraction options-

Extration options

5. Click on ‘Extraction from Domain’. The ‘Extraction from Domain Fixed Values’ option will open for edit.

DataSource Option -Domain

6. Specify the name of the Domain from which you want to extract domain fixed values (as above)

7. Press Save.

It will create DataSource which will extract fixed domain values as Text Master Data.

Extraction  Structure:

The extraction structure for a data source shows the format in which the DataSource, or the extractor for the DataSource, transfers its data.

For extraction from FM and Table/views, we required Extraction structure. For FM based extraction, you will need to create Extraction Structure yourself while in extraction based on Table/View, the extraction structure will be created automatically based upon the definition of the Table/View.

In Extraction based Domain, you don’t need to create Extraction Structure. It has fixed Extraction Structure i.e. ‘ROTEXTSTR1’.

Transport Request:

As explained above, DataSource based on Domain has fixed Extraction Structure ROTEXTSTR1 so you don’t need to capture Extraction Structure in Transport request unlike datasource based on Table/View/FM. You will just need to capture DataSource in Transport request (assuming the required table already present in target system).

I hope this blog will helpful you.

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