Navigation Steps for Start Routine :
Select Data Source from General Ledger : 0FI_GL_1
Description : General Ledger : Leading Ledger Balances
Supported DSO : 0FIGL_O06
Supported Info Cube : 0FIGL_C01
Go to BI/BW System :
Select Tcode :RSA1
Select the Data Source 0FI_GL_1----> Search in RSA1 ----> you will find this DataSource.
Now Create the DSO
Select the Info Area ----> Right click ----> create DSO ----> copy from sap delivered dso OFIGL_O06.
Click on create .
NOTE :
Double Click on the Data Source, You can see the Fields UMSOL, UMHAB
Map the info objects ----> now activate the Transformation.
copy infocube from 0FIGL_C01 ----> CLICK ON CREATE.
After that create a Transformation between DSO and InfoCube.
After doing mapping ----> Click on activate transformation.
Check the Data before starting the Task on Start Routine
PSA - Output
There are 388590 Records
The Transferred Records are : 300007
The Added Records are : 316348
Now Activate the Data in the DSO
Check the Data in the Active Data Table
The No of Records are : 316348
We need to delete the Records with the following conditions UMHAB=0 and UMSOL=0
First check the Transformation between Data Source and DSO
Click on Start Routine.
click on Activate.
And Execute the DTP Request Again
Now Check the Data in the New Data Table
And Check the Data in the Active Data Table
now check the records you get the required data.