Show TOC

DataSourceLocate this document in the navigation structure

Definition

A DataSource is a set of fields that provide the data for a business unit for data transfer into the BW. From a technical perspective, the DataSource is a set of logically-related fields that are provided to transfer data into the BW in a flat structure (the extraction structure) or in multiple flat structures (for hierarchies).

There are four types of DataSource:

  • DataSource for transaction data

  • DataSource for master data

    • DataSource for attributes

    • DataSource for texts

    • DataSource for hierarchies

Use

DataSources supply the metadata description of source data. They are used to extract data from a source system and to transfer the data to the BW system. They are also used for direct access to the source data from the BW system.

The following image illustrates the role of the DataSource in the BW data flow:

The data can be loaded into the BW system from any source in the DataSource structure using an InfoPackage. You determine the target into which data from the DataSource is to be updated during the transformation. You also assign DataSource fields to target object InfoObjects in BW.

Scope of DataSource Versus 3.x DataSource

3.x DataSource

In the past, DataSources have been known in the BW system under the object type R3TR ISFS; in the case of SAP source systems, they are DataSource replicates. The transfer of data from this type of DataSource (referred to as 3.x DataSources below) is only possible if the 3.x DataSource is assigned to a 3.x InfoSource and the fields of the 3.x DataSource are assigned to 3.x InfoSource InfoObjects in transfer structure maintenance. A PSA table is generated when the 3.x transfer rules are activated, thus activating the 3.x transfer structure. Data can be loaded into this PSA table.

If your data flow is modeled using objects that are based on the old concept (3.x InfoSource, 3.x transfer rules, 3.x update rules) and the process design is built on these objects, you can continue to work with 3.x DataSources when transferring data into the BW from a source system.

DataSource

As of SAP NetWeaver 7.0, a new object concept is available for DataSources. It is used in conjunction with the changed objects concepts in data flow and process design (transformation, InfoPackage for loading to the PSA, data transfer process for data distribution within the BW). The object type for a DataSource in the new concept - called DataSource in the following - is R3TR RSDS.

DataSources for transferring data from SAP source systems are defined in the source system; the relevant information of the DataSources is copied to the BW system by replication. This is referred to as DataSource replication in the BW system. DataSources for transferring data from other sources are defined directly.

A unified maintenance UI in the BW system, the DataSource maintenance, enables you to display and edit the DataSources of all the permitted types of source system. In DataSource maintenance you specify which DataSource fields contain the decision-relevant information for a business process and should therefore be transferred.

When you activate the DataSource, the system generates a PSA table in the entry layer of the BW. You can then load data into the PSA. You use an InfoPackage to specify the selection parameters for loading data into the PSA. In the transformation, you determine how the fields of the are assigned to the BW InfoObjects. Data transfer processes facilitate the further distribution of data from the PSA to other targets. The rules that you set in the transformation are applied here.

Overview of Object Types

A DataSource cannot exist simultaneously in both object types in the same system. The following table provides an overview of the (transport-relevant) metadata object types. The table also includes the object types for DataSources in SAP source systems:

DataSource Type

BW:

Object Type of A or R Version

BW:

Object Type of Shadow Version (Source System Independent)

SAP Source System:

Object Type of A Version

SAP Source System:

Object Type of D Version

DataSource

R3TR RSDS

R3TR SHDS (shadow object delivered in its own table with release and version)

R3TR OSOA

R3TR OSOD

3.x DataSource

R3TR ISFS

R3TR SHFS for non-replicating source systems

SHMP for replicating source systems, that is, SAP source systems (shadow object delivered in its own table with source system key)

R3TR OSOA

R3TR OSOD

Recommendation

We recommend that you adjust the data flow for the DataSource as well as the process design to the new concepts if you want to take advantage of these concepts You can do this by using the system-based, automatic migration for data flows.

For more information, see Data Flow in the Data Warehouse and Migrating a Data Flow.