Note : Here I am extracting data from 3 data sources ..namely..
2LIS_02_HDR (Purchasing Document Header Level Data)
2LIS_02_ITM (Purchasing Document Item Level Data)
2LIS_02_SCL (Purchasing Document Schedule Line Level Data)
Step 1 : Log on to Sap R/3 Ecc System.
Step 2 : Activate and transfer the Application Component Hierarchy(One Time Activity in the project).
Enter t-code : RSA9.
Click on yes.
Click on continue..
Step 3 : Check and Activate the required datasource from the business content datasources.
Enter t-code : RSA5.
Select the required datasource (for ex : 2LIS_02_HDR) and click on Version Comparison..
Check whether the desired datasource is activated or not.If not go back to one step and select the datasource and click on Activate datasources option.
Repeat the Step 3 for 2LIS_02_ITM , 2LIS_02_SCL data sources.
Step 4 : Check the datasource entry in the metadata repository of datasources.
Enter t-code : RSA6.
In the above screen shot , we can find the data sources that are available in repository.Next If we want to edit the particular data source select the datasource and click on edit option...Like below.
Here we can find the Extract structure of our data source and delta capable for our Data source.
Datasource Extract Structure
2LIS_02_HDR ---- MC02M_0HDR.
2LIS_02_ITM ---- MC02M_0ITM.
2LIS_02_SCL ---- MC02M_0SCL.
Step 5 : Check the data in the DataSource using Extractor Checker
Enter t-code : RSA3
Enter Ur datasource --> Select Update mode F --> Click on Extraction tab.
U can see the no.of records that u have in ur Datasource.
In SBIW (Display Img) Screen we cannot append the datasource..so we will move to LO Data Extraction(LBWE)
In Lo-Cockpit we have 4 functions.
1.Maintaining of Extract Structure.
2.Maintaining of Data Source.
3.Activating Updates.(V3 job control)
4.Controlling Updates.(Direct,Queued,Unserialized)
Step 6 : Maintaining of Extract Structure.
Enter t-code : LBWE
First we need to Inactive the datasource Active button before going to changing the extract structure.
Click on Maintenance of Extract Structure.
Select the fields from the communication structure(Right side) and transfer to the extract structure(Left side).
Newly added fields will be appear in black color at extract structure level.Click on continue .
Click on yes.
Step 7: Maintaining the DataSource
The Newly added fields will be enable under Field Only column ..so check the checkboxes and save the datasource.
Activate the data source by clicking the Inactive.
Step 8: Controlling Updates.
Select the required update mode and click on continue.
Repeat the steps 5,6 & 7 for 2LIS_02_ITM and 2LIS_02_SCL..
Step 9 : Replicate the Data Source From Sap r/3 Ecc to Sap bw.
Log on to Sap Bw.
Enter t-code : RSDS.
Enter ur datasource(ex : 2LIS_02_HDR) that u want to use in bw.Enter ur source System connection.
Select DataSource option and choose Replicate DataSource.
Step 10: Activate the DataSource.
Enter t-code : RSA15.
Find ur DataSources and double click on it and Click on Activate button (For all 3 DataSources).
Step 11 : Activate and Install the Infocube corresponding to your datasource.
Enter t-code : RSORBCT or click on BI Content Tab (Left Side)
Click on Object Types --> expand 3.x Types -->expand Update rules --> double click on Select Objects -- > select Find symbol --> Enter ur DataSource --> Choose one target .
Click on Infoproviders -- > Find ur target that u have already choosen..
Here i have selected the common target (InfoCube) 0PUR_C04 for all 3 datasources.
Select ur InfoCube --> Drag & Drop to right side
Select the check box Install --> Click on Install..to acivate and install the Infocube
Step 12 : Create Transformations.
After successfull activation of InfoCube .Click on Modeling button on leftside --> select InfoProvider -- > Find ur InfoCube -- > Right Click on ur InfoCube --> Select Create Transformations.
Fill the source information as of above for HDR , ITM and SCL DataSources.
Step 13: Display the Data Flow
Enter t-code : RSA11.
Select your InfoCube(0pur_c04) --> Right click on your InfoCube --> Choose Display Data Flow --> Continue ..
If u have done all the above steps correctly for 3 datasources you can see the following data flow diagram .
Upto here we have seen Modeling and now we have to perform Extraction.
Step 14 : Create InfoPackage with full update.
In Lo-Cockpit to do full update we will use Setup table.So first we need to fill the Setup table...
When we are filling Setup table if anyone access the same setup table from outside..then data inconsistency will be happen.To stop the access from outside we use t-code SM01 to lock/unlock the transactions.
Enter t-code : SM01.
Select check boxes of ME21(Create),ME22(Change),ME23(Display).
Now Fill the Setup table ,,,for purchasing order
Enter t-code : OLI7BW.
Give name of your run and provide termination date and time.Click on Execute symbol.
Setup table names will be a extract structure followed by setup.For Ex:
datasource 2LIS_02_HDR ,extract structure MC02M_0HDR ,setup table MC02M_0HDRSETUP.
Now create InfoPackage.
Enter t-code : RSA15.
Select ur datasource -- > Right click --> Choose create InfoPackage.
Click on continue.
Select Update tab Select Full update option as shown in the above screen shot.
Select Schedule tab --> Select Start button --> Select Monitor icon --> Check the data in PSA.
Step 15 : Create DTP with full update.
Select ur Datasource --> Right click --> Create Data Transfer Process--> Continue.
Select Extraction tab --> Select Full update mode.
Select Execute tab --> Select activate to enable execute button --> Select Execute button.
Select Data target icon -- > Select ur Cube --> Select Contents -- > Select Field Selection for output --> Select Execute --> Execute ---> Observe the data .
Note : Repeat the steps 13 & 14 for 2LIS_02_ITM , 2LIS_02_SCL.
Step 16 : Create InfoPackage with Initial Delta.
Enter t-code : RSA15.
Select ur datasource -- > Right click --> Choose create InfoPackage --> save
Select Initial Delta Process --> Select Initialize without Data Transfer --> Select Schedule tab --> Select Start.
Step 17 : Create Purchase Order for Delta records
To do purchase order we need to Unlock the transactions which we locked before using SM01.
Enter t-code SM01 --> Unlock the transactions ME21,ME22,ME23..
Enter t-code : ME21
Select copy document --> Browse for reference document --> Select Purchasing Document For Material --> Select order type --> Continue
Click on Enter .
Select required items -- > Select Adopt + Details tab ...
Change the Order Quantity as per ur requirement and adjust the Delivery and Statistical Delivery Dates ..Click on enter One document is created ..and so on ...Save the documents
Now check the delta records .
Enter t-code : RSA7.
Find ur datasources with documents that u created using ME21.(I have created 1 document with 2 records.)
Step 18 : Create InfoPackage with Delta Update.
Enter t-code : RSA15.
Select ur datasource -- > Right click --> Choose create InfoPackage --> save
Step 19 : Create DTP with Delta update.
Select ur Datasource --> Right click --> Create Data Transfer Process --> Continue --> Select Extraction tab -- > Select option Delta for extraction mode --> Select Execute tab --> Select activate option --> Select Execute button.
you can see the delta records with new data request..To see the complete data
Select Data target icon -- > Select ur Cube --> Select Contents -- > Select Field Selection for output --> Select Execute --> Execute ---> Observe the data .
2 comments:
very very helpful , level of explanation is really different from others !!!
really thanx alot sir
Thanks for Sharing this Information. SAP BI Training Course in Gurgaon
Post a Comment