Datasources
Datasource: A Datasource is not only a structure in which source system fields are logically grouped together, but also an object that contains ETTL related information.
There are two types of Datasources:
Business Content: It is a complete set of BW objects developed by SAP to support OLAP tasks. It contains pre-defined roles, workbooks, queries, infocubes, key figures, characteristics, update rules, infosources, transformations, DTP’s etc.
SAP delivers Business content in ‘D’ version, then in order to use it, we need to activate it, then the version changes to ‘A’ version. Changes are saved in ‘M’ version.
Version | Meaning | Description |
D version | Delivered version | SAP delivers BC in new ‘D’ version |
M version | Modified version | Changes are saved in the ‘M’ version |
A version | Active version | You need to activate BC before working with them |
Installing Business Content:
We install the BC :
In the BI content tab, you can see that the window is divided into three parts.
Grouping:
Collection mode:
Check the objects after collection to install.
Install:
While installing, check the install boxes available for objects.
Install all below: the objects and the dependent objects are checked for the installation.
Donot install all below: The checkboxes are removed when you select this option.
Match X or copy:
When the object is available in the active version, you have to decide whether to keep the active version or to install the latest SAP delivered version of the object.
when you check the match, then the customer version of the object is merged with the new SAP version and a new customer version is created. If you do not check the match, SAP delivered version of the object is overwritten.
There are four options in Install:
FI Datasources:
Finance is a back-bone of any organisation, and for that reason, SAP provides FI module which records, collects or processes the financial transactions or information on a real-time basis to fulfill the reporting requirements. It is tightly integrated with other modules like MM, SD, PP, HR, and CO.
The sub-modules of FI are:
We can extract the financial data at totals level/ line-items level. In general, we will use R/3 line item tables as the datasource for extracting the data to allow drill down capability from summarized data to line item data.
Example of Installation:
We are going to install the cube 0FIAA_C01 in the Business content.
Steps:
1. In order to check the dataflow for the cube 0FIAA_C01, you have to goto Metadata repository, there click the Business content. Now select the Infocube and search for the Infocube 0FIAA_C01.
2. Double-click on the Infocube. Then double-click on the option ‘Network display of dataflow’, here you can see whole dataflow for this infocube.
3. Go to RSA5 in ECC side, and Activate the three datasources shown above in the figure. Once activated, those datasources must be available in RSA6.
4. Now, Go to Business Content tab, Select the cube 0FIAA_C01, group objects according to your requirement, then install it.
5. After BC installation is completed, replicate the datasources. Once you done that, now go to the Infocube 0FIAA_C01, select it, and right-click. Now select the ‘show data flow’ option. The below is the dataflow for the cube.
6. Now, as that the dataflow is completely installed, create Infopackages for the datasources, and load the data.
7. Once the data is loaded successfully, you can click on manage of infocube, and monitor the requests. Similarly, you can go to LISTCUBE and check the data in the cube.
Logistics Datasources:
LO extraction gives better performance with reduced volume of data. It provides us a single solution for all logistic applications. LO extraction is a detailed extraction, updated with batch process (V3 update). Only data that are changed from the BW perspective are added to the delta queue.
LO data extraction: customizing cockpit:
The document flow for LO data extraction is shown below:
Datasource naming convention:
The SAP standard datasources has a specific naming convention provided by SAP.
In this datasource,
2 is a symbol for logistics, all datasources belong to logistics, start with 2.
LIS stands for LO information structures.
11 is a application number.
VA further specifies that the datasource is a sales order.
HDR means header data, it specifies the type of data.
HDR – Header data
ITM - Item data
SCL – Schedule line
Application | Description |
02 | Purchasing |
03 | Inventory |
04 | Shopfloor |
05 | Quality Mgt |
06 | Invoice verification |
11 | Sales order |
12 | Shipping |
13 | Billing |
17 | Plant Maintainance |
Different types of Updates are available:
LBWQ is a trsn for QRFC monitor
RSA 7 is a trsn for BW Delta Queue
SM13 or SMQ1 is a trsn to see extraction tables or update tables.
There are three types of Delta methods in LO data extraction.
CO-PA:
Controlling and Profitability Analysis (CO-PA) is mainly used for Sales and contribution margin reports. It helps you determine how profitable your market segments are, with CO-PA, you will be able to define which segments, like customer, product, geography, sales organization, of the market are required for analyzing the operating results/profits. CO-PA mainly focuses on external market segments profitability.
There are two types of reports in CO-PA
The transaction code for creating CO-PA datasource is KEB0.
Here, we will create a CO-PA datasource as shown in the figure above. We are going to create Costing based datasource.
For that, you need to first go to transaction code KEB0. Then give the datasource name, it should start with 1_, here our DS name is 1_CO_PA_Profit.
Give the operating concern, as shown in figure, and execute.
Now, give the descriptions and field name for partitioning as shown above. Click on Infocatalog symbol above. You will be asked for the developer key, fill the key and continue.
Now, you need to select the selection fields. Once you select it, these fields will be available as selection parameters in RSA3, and InfoPak.
Now, Save the datasource. The CO-PA datasource is created in ECC side. You can go to RSA6 and check this datasource.
In RSA3, you can check the number of records this datasource contains, as shown in the figure below.
As you can see from the figure, this datasource contains 10,264 records. You can extract these records by creating dataflow in BW.
Steps in BW:
Note:
This document may contain the definitions, and the architecture of the book:
Data warehousing with SAP BW7. By christine mehrwald, sabine morlock.
Please visit my website for my blogs on SAP BI.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |