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 · Accepted solution]

Hi,

you are absolutely right. The extract structure is the structure of the data extracted by the system.

The datasource holds information about the extraction method (function module, view, table, domain fixed values...), the extract structure, the application component and you can maintain the datasource-structure by switching fields of the extract structure on/off, make 'em selection fields....

regards

Siggi

[Former Member]

Hi Indudhar,

an extract structure is a data structure of all data you <b>can</b> extract from the source system via content extraction or generic extraction. A data source is smaller than a extract structure and include all data you want to send to BW. Therefore you can hide fields from the extract structure in the maintenance of a DataSource.

Hope this helps.

OJ

[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. &#61485; DataSources for attributes

2. &#61485; DataSources for texts

3. &#61485; 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 &#61614;Modeling &#61614; Source Systems &#61614; Your Source System &#61614; Context Menu (right mouse click) &#61614; Customizing Extractors &#61614; Subsequent Processing of DataSources.

Regards,

Naren.