Start of Content Area

Process documentationData Extraction from SAP Source Systems  Locate the document in its SAP Library structure

Purpose

Extractors are one of the data retrieval mechanisms in the SAP source system.

An extractor can fill the extract structure of a DataSource with the data from SAP source system datasets.

This graphic is explained in the accompanying text

In a metadata upload, the DataSource, including its relevant properties, is replicated in the BW. Once there you can assign it to an InfoSource. The DataSource fields are made available to be assigned to BW InfoObjects.

After specifying the data flow in the BW Administrator Workbench by maintaining the transfer rules, you can schedule an InfoPackage in the Scheduler. The data loading process is triggered to the source system by a request IDoc.

Process

There are application-specific extractors, each of which are hard-coded for the DataSource that was delivered with BW Business Content, 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 it know which data is to be extracted, and from which tables it should read it from and in which structure. This is how it fills different extract structures and DataSources.

You can run generic data extraction in the R/3 source system application areas such as LIS, CO-PA, FI-SL and HR. This is how LIS, for example, uses generic extraction 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 Business Content.

You can find further information in the implementation guide to data extraction from SAP source systems. You get there by choosing Your Source System Context Menu (right mouse click) Customizing Extractors in the BW Administrator Workbench Modeling.

Plug-in for R/3 Systems

BW-specific source system functions, extractors and DataSources are delivered by so-called plug-ins.

Note

Communication between the R/3 source system and the SAP Business Information Warehouse is only possible if the appropriate plug-in is installed in the source system.

End of Content Area