Thursday 12 January 2017

SAP BI-ABAP: How to Create Generic Data Sources or Extractors – Based on Table or View

Extractor are used to pull data from source system (like ECC, SRM, CRM) to SAP BW system.

SAP providers standard extractors for most of the application area which are used to bring the Data From the Std. Tables.

In most of the cases, as the customer might have custom application in place in the landscape they do have to save the important business data in custom table (Z* or Y*).

To fetch data from these custom table SAP allow us to create custom extractors/data sources.

Custom Extractors/Data Sources can be created in 3 different ways.
1. Table/View Based Generic Extractors
2. Info Set Queries Based Generic Extractors
3. Function Module Based Generic Extractors

Refer the below view to see the Step-by-Step procedure to create Table/View Based Generic Extractors.