Skip to Content
Overview
The purpose of this document is to help in understanding how to create a view based on transparent tables, create a generic datasource based on it,
replicate to BI, BI content installation, mapping fields to infoobjects, create the DSO, the InfoCube, the transformations, the DTP, and finally taking it to reports.
Generic Extraction is sort when the standard extractors are not supporting the extraction what you need.
Generic extractors are of 3 types:
1. Based on table/view
2. Based on Infoset Query
3. Based on Function module
We will limit our discussion to Generic Extraction based on a view. We go for this option when the data to be fetched to BI is distributed in
different tables in SAP R/3.
Scenario
We need to extract the Partner Function (PARVW field) and Item number of sales document (POSNR field) in VBPA – Sales Document: Partner table and few fields present in the VBAK – Sales Document: Header Data table as detailed below.
ECC Steps
1) Check the tables for the required fields.  The fields we require from VBAK are
VBELN
VKORG
AEDAT
NETWR
WAERK
and
PARVW
POSNR from VBPA Table.
2) Now we create a join between these tables and for this we need to have at least one common field between them.
In SAP R/3 or ECC enter Transaction SE11 which enables you to create a table or view.  Here I am creating a view as ZVIEW_VBAK_VBPA.
1.PNG
Click on Create.
2.PNG

Select the view type. We are creating a database view.

The system now displays the Maintenance view screen.
In the Table/Join Conditions tab, enter the tables that you wish to build the join on.

3.PNG

4.PNG
If you are unsure of the common fields to establish a join, then select the tables involved in the join and select ‘Relationships’ and system will automatically prompt you the relationship link between these tables.

In the ‘View Fields’ tab enter the fields that you wish to include in the View.  Please remember to include the ‘key fields’ from each of the tables in the fields selection else you will encounter an error during activation of the view.
6.PNG

Save the View. You will be prompted to enter the development class as well as Transport request number for the development that you are carrying.

Enter the relevant values. Click on the ‘Check’ button to check the View for inconsistencies. If there is none, Activate the view.
3) Create a Generic datasource based on the view we just created.
Use Transaction Code RSO2 to create a Generic datasource.

7.PNG

In the next screen enter the values as required.

Application Component: Component name where you wish to place the data source in the App. Component hierarchy, in our case SD.

Text: Descriptions (Short, Medium and Long) for the datasource.

View/Table: Name of the Table/View on which you wish to create the Generic datasource, in our case ZVIEW_VBAK_VBPA.

8.PNG

Save the datasource.  The Generic datasource is now displayed allowing you to Select as well as Hide field. The fields ‘hidden’ will not be available for extraction. Fields in the ‘Selection’ tab will be available for Value Selection in the Infopackage during data extraction from the source system to the PSA.
9.PNG
Save.

4) Checking the data in the extract checker (T code – RSA3)
10.PNG
Here I am extracting the records with VBELN between 4970 and 4980. (If you want to have the correct number of records extracted,
Give Data Records/Calls as 100000 and click on “Extraction”)
11.PNG

Click on ‘Display list’ to display the number of data packets available.

12.PNG

Double-click on the Data packet and the records in the data packet are displayed.

13.PNG

Here we can see that each Sales Document Number has 6 entries, so between VBELN (4970-4980) we got 6*10=60 data records.

5) Go to RSA6 ( Postprocess Datasources and Hierarchy) and check for your Datasource.  This holds all the datasources that are active in nature.

/wp-content/uploads/2012/09/14_140696.png

The Steps in ECC is done.  Now we have to go for Steps in BI.                                                  (continued in Part 2)

Part 2 

http://scn.sap.com/docs/DOC-32026

Thank you for taking time out to go through the document.  Hope its been helpful.  Please leave your valuable comments/likes/ratings below.

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. refka refka

    Hello Anjali P ;

    really it is great document

    but a message eroor appears

    “”

    R8072 – You do not have authorization to maintain DataSource &1, component &2 – R8 072

     

    plz can u help me

     

    (0) 

Leave a Reply