Extract Structure

[Former Member]

Hi All,

What is extract and transfer Structure?

Thanks and Regards

Samran.

[Former Member · Accepted solution]

Hi,

You can go through the sap Help .

Transfer Structure:

[http://help.sap.com/saphelp_nw04/helpdata/en/80/1a62b2e07211d2acb80000e829fbfe/content.htm]

With Transfer structure we provide transformation to the data through transfer rules.

Transfer Structure contains the fields from DataSource from source system that you want

to map in BW.

The data is teansfered from Transfer Structure of Source System to the Transfer Structure

of BW System by 1:1 Mapping using Transfer Rules.

ie we map each Source fields to one InfoObject in BW.

Extract Structure:

[http://help.sap.com/saphelp_nw04/helpdata/en/80/1a627ee07211d2acb80000e829fbfe/content.htm]

The extraction structure is the structure that contains all the fields you see in RSA6.

Regards

Pratap Sone

Edited by: Pratap Sone on Jul 26, 2008 1:33 PM

[Former Member]

Hi Samran,

Extract structure:

Extract structure is available in R/3(Source sysyem) Goto RSA5.

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.

Transfer structure:

Transfer Structure is available in BW system go to RSA1.

The transfer structure is the structure in which the data is transported from the source system into the SAP Business Information Warehouse.

It is a selection of DataSource fields from a source system.

The transfer structure provides the BW with all the source system information available for a business process.

An InfoSource in BW requires at least one DataSource for data extraction. In a SAP source system, DataSource data that logically belongs together is staged in flat structure of the extract structure. In the source system, you have the option of filtering and enhancing the extract structure in order to determine the DataSource fields.

In the transfer structure maintenance screen, you specify the DataSource fields that you want to transfer into the BW. When you activate the transfer rules in BW, a transfer structure identical to the one in BW is created in the source system from the DataSource fields.

The data is transferred 1:1 from the transfer structure of the source system into the BW transfer structure. From here it is transferred, using the transfer rules, into the BW communication structure.

A transfer structure always refers to a DataSource in a source system and an InfoSource in a BW.

You get to the maintenance screen for the transfer structure through the InfoSource tree of the Administrator Workbench. Alternatively, you can access the maintenance screen by selecting the Maintain Transfer Rules function from the context menu of the source system belonging to an InfoSource.

I hope it will clarrify.

Regards

Suresh B.G.

[Former Member]

Hi Samran,

Extract means fetching the data from source like

oracle data source. Then this data is transfered to the target data.

Regards

Selva.D

[Former Member]

Extract structure is something in source system that interacts with the Datasource.

transfer structure is the one present in BI system, that points to Datasource.

Naveen.A

[Former Member]

hey you will find lots of info in help.sap.com or in the forums. these are very basic questions. please search.