Database Table : VBUK
Go to ECC System
Step 1 : Create Generic Data Source using Table
Go to Tcode : RSO2
Note : 1st you have to check The fields
Go to se11 ---> Enter Table name ----> VBUK ----> Display.
Now Create Generic Data Source
Go to Tcode : RSO2
Enter the name of Data Source : ZDS_VBUK
enter all descriptions ----> Enter View/Table : VBUK ----> SAVE.
Hide all other Fields ----> Click on Save
Now check the Created Data Source in Tcode :RSA6
SAP - R/3 -> SD
Check the Data Source
Go to SE11----> enter table name --->VBUK
Display -> go to Contents -> select Number of Entries -> 51699 entries
Now Check the Data in the Data Source
Data source Extractor ----> RSA3
Enter the Data Source : ZDS_VBUK
Now go to BI/BW System..
Step 1
You have to Replicate Metadata
Go to Tcode : RSA1---> Modeling -> DataSources -> SAP-R/3 -> SD -> Right Click -> Replicate Metadata.
After That you can see the Data Source ----> Select the data source ----> Activate the Data Source
Double Click the Data Source ----> Click on Fields
Go to RSOSFIELDMAP ----> Map the Fields with the InfoObject
If there are no InfoObjects, then Create ZInfoObjects and Take Z Key Figure Objects
Step 2:
Now Create DSO ----> for that you have to Select the Info Area -----> Right Click ----> Create DSO.
Since there are no key figures, add Z key figure info objects.
Active DataSource.
Create Info Cube ----> Click on Create ----> Add the Dimensions and Key Figures
Click On Activate DSO.
Now Create Multi Provider ----> Select DSO ---> Select the Infocube ----> click on continue.
Now Activate the Multi Provider
Step 5:
Create Transformation between Data Source and DSO ----> Activate the Transformation.
Create Transformation between DSO and Info Cube ----> Activate the Transformation.
Load Data
i. Create Info Package and Load the Info Package
PSA - Output
New Data Table - Output
Active Data Table
iii. Create DTP Request and Load the Data for the DTP (DSO)
Info Cube - Output