Process of SAP BW Data Flow

The following SAP BW training guides about SAP BW data flow, how the data flows, and what are the important objects that are involved in the data flow.

  • The source system can be any- sap system or non systems, database connections, and Flat file.
  • The data flow can be the same for all the source systems.
  • The data transfers from the source system to the data source with the help of IP (Info package)
  • Then the data move from data source to info provider with the help of DTP (data transfer process) and Transformation.

SAP BW Data Flow Process Steps and Methods

Types of Info providers

  • Infocube- It stores data in a multidimensional way, it contains multiple tables in tart schema format.
  • Data Store Object (DSO): -DSO stores the data in two dimensional way similar to tables. The main functions of DSO are to utilize the overwrite functionality, maintain the image and act as a backup.
  • Multi-providers: – It enables the cubes to union among them. It provides a better reporting base.

Data Source: –

The data source specifies what data is to be extracted from the source systems. So the data extracted is specific as per client requirements.

Persistent Staging Area: –

It is a two-dimensional table that is used to rectify the records before transferring them to the info providers.

Source System: –

It is a place where the organization stores all the data. The source system can be an SAP system or non sap system or a flat file.

Transformation (T): – The data is transferred from data source info records with a suitable format for reporting.

Data transfer Process (DTP): – It is used to handle the flow between data source to info provider.