Creating Extractor in SAP R/3
- Go to RSO2 and key in the extractor name.
- Specify the descriptions for the extractor and the application component under which the extractor should be defined.
- Give the table name in the view/table section and execute it. Here we can select the fields for selection which is helpful while extracting the data to PSA.
- Once executed save the extractor.
Testing the Extractor
- Go to RSA3 and give the extractor name and execute it.
- Once executed select the ALV grid and check the data in the extractor is same as the data in the table specified while creating the extractor.
Replicating the Extractor in BW
- In BW go to RSA1 and go to the Datasources section.
- Look for the application component. Select it and click on replicate metadata.
- It prompts the new extractor created and replicates it in the BW side.
- Create the info package to load the data from the extractor to PSA.
Creating ODS
- In Info provider section select the application component under which the extractor is built. Right click and select on create data store object.
- Once selected we have to define the key fields and data fields for the ODS.
- Make sure that all the fields in the table exist as info objects in the BW side. If not create info cubes starting with Z.
- Key fields – To figure out the key fields go to ECC and type the table used for the extractor. Look for the fields that are checked as key fields. Define these as key fields.
- Data fields- Remaining fields are defined as data fields.
- Once done activate the ODS and save.
Loading the Data
- Under the data source section right click the extractor and create the transformations. Assign each field of the extractor to the field in the ODS. Once done save it.
- Create the info package. While executing we can filter the data based on the selection of the fields or we can load it completely.
- Once successfully done the data is loaded to PSA.
- Under Info provider section go to the ODS created and right click to create the DTP.
- Create the DTP and execute it to load the data to ODS.
- Now the data in ODS is in new table. To view the data in the new table go to Manage, under Contents click on the new table.
- To activate the data, in the manage section click on Activate.
- A job is scheduled to activate the data and the status can be seen in SM37.
- Once done the data is ready for reporting and is in the active table.
- All the data in the new table is erased.
