How to Create a Generic Data source for Domain texts
Domain Text – is the master data related to an info object. To load the data we load this through the domain texts where the master data for the info object is stored.
Attributes of an info object contains the master data and to load the master data related to the attributes we load them through the domain texts.
Creating the Extractor in SAP R/3
- Go to RSO2 and give the name of the extractor in Master/texts option and create.
- Key in the descriptions and the application component under which the extractor should be stored.
- For eg if the extractor is related to sales and distribution place it under the SD application component.
- Click on extraction from domain and the domain field is activated.
- To find the domain for the info object we are creating go to SE11 and key in the table in which the info object exists. Double click on the field and the domain name exists there.
- In the domain field key in the domain name related to the info object.
- Save the extractor
Testing the Extractor
- Go to RSA3 and key in the extractor name and execute.
- Select the ALV grid to check the data in the extractor.
Replicating the Data source in SAP BW
- In RSA1 go to the Datasource section and select the application component specified while creating the extractor. Right click and click on the replicate metadata.
- System prompts the new data source to be replicated and make it a 7.0 data source.
- Once the data source is replicated create the transformation. Join the extractor fields with the info object fields and save the transformation
- While joining all the key fields on the extractor should be present in the info object fields. If the field is missing on the info object side define the missing field as a compounding info object in the info object attributes. By defining as compounding attribute it will ensure that this info object does not exist without this attribute.
- If the key field on the info object is not present in the extractor make it a constant from initial since it does not have a mapping with the extractor.
- Once the transformations are done create info package and schedule the job to load the data to PSA.
- Go to the info provider section and search for the info object to which the data is loaded and create the DTP.
- Execute it and activate. The domain texts are loaded to the info object.
- To check the data select the maintain master data and look at the data.
