Extract structure

[Former Member]

Hi all,

Can any body of you tell me what is an extract structure? If I'm not wrong The struture of a data source is called an extract structure? What is the main difference between a data source and extract structure.

Thanks in advance,

Indudhar

[Former Member]

Hi Indudhar,

Data Source Definition:

Data that logically belongs together is stored in the source system in the form of DataSources.

A DataSource consists of a quantity of fields that are offered for data transfer into BW. The DataSource is technically based on the fields of the extraction structure. By defining a DataSource, these fields can be enhanced as well as hidden (or filtered) for the data transfer.

It also describes the properties of the extractor belonging to it, as regards the data transfer into BW. During a Metadata upload, the properties of the DataSource relevant to BW are replicated in BW.

There are four types of DataSource:

• DataSources for transaction data

• DataSources for master data

These can be:

1.  DataSources for attributes

2.  DataSources for texts

3.  DataSources for hierarchies

DataSources are used for extracting data from a source system and for transferring data into the BW. DataSources make the source system data available on request to the BW in the form of the (if necessary, filtered and enhanced) extraction structure. Data is transferred from the source system into the SAP Business Information Warehouse in the Transfer Structure. In the transfer rules maintenance, you determine how the fields of the transfer structure are transferred into the InfoObjects of the Communication Structure. You assign DataSources to InfoSources and fields to InfoObjects in the transfer rules maintenance

Extraction Structure definition:

In the extraction structure, data from a DataSource is staged in the source system. The extraction structure contains the amount of fields that are offered by an extractor in the source system for the data loading process.

You can edit DataSource extraction structures in the source system. In particular, you can determine the DataSource fields in which you hide extraction structure fields from the transfer. This means filtering the extraction structure and/or enhance the DataSource for fields, meaning completing the extraction structure. To do this, in the BW Administrator Workbench choose Goto Modeling  Source Systems  Your Source System  Context Menu (right mouse click)  Customizing Extractors  Subsequent Processing of DataSources.

Regards,

Naren.