SAP BW Flat File Loading to DSO

Advertisement

SAP BW Flat File Loading to DSOWelcome to the tutorial on how to load SAP BW flat file to DSO. Here, we are going to make use of the knowledge from the previous tutorial in SAP BW training course. We will use a live scenario of loading SAP BW flat file to DSO for an easier understanding for you. You will be guided with images and a detailed explanation of each step of the process. Upon completion of this tutorial and practice on your part, you will be able to load data from SAP BW flat file to DSO with confidence.

There are many DataStore Objects (DSO’s) that you can install from the BI Content. For instance, 0PUR_DS03 is a Purchase Order Schedule Lines DSO. In BI Content, you have the complete data flow that you can install to load data to a DSO from SAP ECC.

Advertisement

SAP BW allows you to define custom DSO’s based on any of the 3 types – Standard, Write-Optimized, and Direct Update DSO. If you have a completely new requirement to load data from SAP BW flat file to DSO, you will have to create a customized data flow and load data accordingly. Flat file is the simplest kind of database that stores records in a plain text file. This tutorial focuses on this kind of requirement.

Live Scenario

We are going to take this scenario to guide you through the process of loading SAP BW flat file to DSO. There is a requirement to load data to a Standard DSO ‘ZT_DSO’ from a flat file. The DSO has Product as a key field and Quantity as a data field. The DSO structure is given below:

DSO Structure
DSO Structure

The flat file structure is given below.

Flat File Structure/Data
Flat File Structure/Data

It has five records. We need to load these five records to the DSO ‘ZT_DSO.’

For the ease of understanding, we will go in detail into each of the following steps:

  • Create Flat File Source System
  • Create Transaction Data DataSource
  • Create Transformation (Source: Transaction Data DataSource and Target: DSO)
  • Create InfoPackage and Data Transfer Process (DTP) for loading data
  • View the records in DSO

Create Flat File Source System

Let’s leverage the flat file source system (ZFTUTORIAL) created in our previous tutorial SAP BW Flat File Loading to InfoObject. If you want to create a new flat file source system, you can follow the same steps that were covered in SAP BW Flat File Loading to InfoObject tutorial.

Flat File Source System
Flat File Source System

Create Transaction Data DataSource

In ‘Data Warehousing Workbench: Modeling’ tab, click on ‘DataSources’ in the left pane. You’ll get to this place by using RSA1 transaction code.

Data Warehousing Workbench: Modeling
Data Warehousing Workbench: Modeling

Let’s create the transaction data DataSource by right clicking on the ‘ZAPP’ application component we created in our earlier tutorial SAP BW Flat File Loading to InfoObject.

Creating Transaction Data DataSource
Creating Transaction Data DataSource

Clicking on ‘Create DataSource…’ will prompt you with the following sub-screen and you need to enter DataSource name and select ‘Data Type DataSource’.

Creating Transaction Data DataSource
Creating Transaction Data DataSource

Let us type ‘ZDS_TD’ as the DataSource name and choose ‘Transaction Data’ as the ‘Data Type DataSource’. Finally, select to continue.

Creating Transaction Data DataSource
Creating Transaction Data DataSource

Now, make sure that you enter all fields (Product and Quantity) as shown below:

Enter fields in the DataSource
Enter fields in the DataSource

As mentioned in the earlier tutorial SAP BW Flat File Loading to InfoObject, choose Adapter, File Path, Header Rows to be ignored, and Data Format while keeping in mind the instructions specified for various file types.

DataSource: Extraction Tab
DataSource: Extraction Tab

Activate the ‘ZDS_TD’ DataSource by clicking on . The DataSource will appear in ‘’Active’ version.

Activated DataSource
Activated DataSource

Finally, you can preview the data by clicking on the ‘Preview’ tab.

Data Preview
Data Preview

Create Transformation (Source: Transaction Data DataSource and Target: DSO)

At this step of loading SAP BW flat file to DSO, map the source fields of the DataSource to the target fields of the DSO by creating transformation between them. To do that, you just need to right click on ‘ZDS_TD’ DataSource and choose ‘Create Transformation….’

Advertisement

Enter the details as follows and select to continue:

Creating Transformation
Creating Transformation

You can see that the mappings are automatically created.

Transformation Mappings
Transformation Mappings

So, you just have to activate it by clicking on . The transformation appears in ‘Active’ version.

Activated Transformation
Activated Transformation

Create InfoPackage and Data Transfer Process (DTP) for loading data

You need to first create InfoPackage to push data to PSA and then DTP to push data to DSO. The process of creating InfoPackage and DTP will be the same as mentioned in SAP BW Flat File Loading to InfoObject tutorial.

The following InfoPackage has been created to load data to PSA:

Creating InfoPackage
Creating InfoPackage

Execute the above InfoPackage by clicking on

Executing the InfoPackage
Executing the InfoPackage

The following DTP has been created to load data to DSO:

Creating DTP
Creating DTP

Execute the above DTP by clicking on

Executing the DTP
Executing the DTP

View Records in DSO

Now, let us validate whether the five records of the flat file got loaded to the DSO. To do that, just right click on DSO and click on ‘Manage’ as highlighted in the following screen:

Manage InfoProvider
Manage InfoProvider

The request status is green; however, the data gets stored in the New Data table. The contents of the new data table are shown below:

Contents of New Data table
Contents of New Data Table

You can also check the contents of the Active Data table. As can be seen, there are no records in this table.

Contents of Active Data Table
Contents of Active Data Table

So, you need to activate the request to move the data to ‘Activate Data’ table. Just select the request highlighted in the following screen:

Activate the Data in DSO
Activate the Data in DSO

Now, click on to activate the data in DSO.

Activate the Data in DSO
Activate the Data in DSO

Check the job status by clicking on highlighted in the screen below:

Checking the Job Status
Checking the Job Status

Now, click on highlighted in the below screen to view the status.

Checking the Job Status
Checking the Job Status

The job overview gets displayed. As can be seen, the job got finished.

Job Overview
Job Overview

Let’s now check the contents of the new data table and activate the data table. The new data table contents can be seen as follows:

Contents of New Data Table
Contents of New Data Table

The active data table contents can be seen below:

Contents of Active Data Table
Contents of Active Data Table

As shown, there are no records in the new data table anymore. All records are pushed to the active data table.

Advertisement

Conclusion

Loading SAP BW flat file to DSO needs to be done with utmost care and attention. Every step in the process is equally important. For instance, if you just miss activating the data in Standard DSO, the data will not be available for reporting. Hence, make sure that you understand the ins and outs of the process. Moreover, this tutorial focuses on data loading to Standard DSO; try your hands on loading data to a Write-optimized DSO. The process will remain the same; however, there will be no need to activate the data in Write-optimized DSO, as this DSO will have just one table (Active Data table). The more you practice, the better you understand the issues that would arise in real time projects.

Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP BW tutorials.

Navigation Links

Go to next lesson:

Advertisement

Go to previous lesson: SAP BW Flat File Loading to InfoObject

Go to overview of the course: SAP BW Training

Leave a Reply

Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM!

Your email address will not be published. Required fields are marked *