Show TOC

Data Extraction from SAP Source SystemsLocate this document in the navigation structure

Extractors are part of the data retrieval mechanisms in the SAP source system. An extractor can fill the extraction structure of a DataSource with the data from SAP source system datasets.

Replication makes the DataSource and its relevant properties known in BW.

For data transfer to the input layer of BW, the Persistent Staging Area (PSA), define the load process with an InfoPackage in the scheduler. The data load process is triggered by a request IDoc to the source system when the InfoPackage is executed. We recommend that you use process chains for execution.

Process

There are application-specific extractors, each of which are hard-coded for the DataSource that was delivered with the BI Content of BW, and which fill the extract structure of the DataSource.

In addition, there are generic extractors, with which you can extract more data from the SAP source system and transfer it into BW. Only when you call up the generic extractor by naming the DataSource does the extractor know which data is to be extracted, which tables it should read the data from and in which structure the data should be read. This is how it fills different extraction structures and DataSources.

You can run generic data extraction in SAP source system application areas such as LIS, CO-PA, FI-SL and HR. This is how LIS, for example, uses a generic extractor to read info structures. DataSources are generated on the basis of these (individually) defined info structures. We speak of customer-defined DataSources with generic data extraction from applications.

Regardless of application, you can generically extract master data attributes or texts, or transaction data from all transparent tables, database views or SAP query functional areas or using the function module. You can generate user-specific DataSources here. In this case, we speak of generic DataSources.

The DataSource data for these types are read generically and transferred into the BW. This is how generic extractors allow the extraction of data that cannot be made available within the framework of BI Content.