An Infocube is defined as a multidimensional dataset, and we can add data from one or more infosource or infoprovider. These can be used for analysis and reporting purposes.
0SD_C03 is related to Sales Overview, it meets the need of client. And it contains both header data sources like 2LIS_11_VADHR and item data sources like 2LIS_11_VAITM.
Let’s start with the process of installing and loading the data into infocube. Here we are using BW Netweaver 7.5 version and ECC system.
The following are the steps needed to be done in the ECC system and in the BW system for installing the infocube which includes activating the data source and checking whether they contain the data or not in the ECC.
Step:1
Open the ECC system and go to the t-code RSA5.
Drop down the SD for sales and select each data source, then click on the Activate Data Sources.
The data sources are: 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_V_ITM, 2LIS_12_VCHDR, 2LIS_12_VCITM, 2LIS_13_VDHDR and 2LIS_13_VDITM.
Step:2
Go to RSA6 and check whether the activated data sources are listed or not.
Step:3
Go to LBWE and drop down which are related to sales like SD sales BW, LE shipping BW and SD Billing BW (the respective numbers are 11, 12 & 13 respectively) and activate them.
As per the requirement, if we need to add few custom fields in the data source, click on the maintenance of the relevant data source. Select the fields from source table (right side) then click on the choose icon 
Now, to have the transactional data to be in the data sources, we need to do the job control. For that click on the Job Control which is against each logistics number.
Select the Start Date
Click on the Immediate, then select the period values as Hourly then check and save it. In the same way check and save the start time, but before that make sure that you enabled Periodic Job.
Finally click on the schedule job so that for every one hour the job will run to update the transactional data.
Likewise check for the other logistics number and schedule the job.
Step: 4
Go to the t-code: LBWG to delete the records which are loaded before which may not be the latest records.
Give the application number(Logistic number 11,12, & 13) and then click on the execute it. Then you will get a confirmation text regarding the deletion of set up tables in the down of the SAP screen.
Once we delete the setup tables, we have to load the latest records of data for that go the t-code: SBIW. Drop down as show in the image for sales data.
11 - SD sales Order
12 - LE Deliveries
13 - SD Billing Documents
Once you enter into the page give the name of run and termination date (give one day future date) as shown below.
Now click on the Program -> Execute in Background to start filling the relevant setup tables. And we can also check the job in the SM37 t-code.
Once you finished filling all the setup tables, check the RSA7 t-code whether you have delta queues, if so delete them and also RSA3 t-code check whether data is getting loaded into the data source.
Note: For each logistic number we have to check the relevant data sources in the RSA3 t-code.
Step: 5
Open the BW system.
Go to the t-code: RSA1 -> BI Content -> select the required info cube and drag it to the right side for installing.
Note: Click 
Select all the necessary data source and the transformation and then click on the install in background and looking into the job in the t-code: SM37.
Step: 6
Go to the RSA1 t-code -> DataSource, make sure all the data source are activated and object info is showing the proper source system.
For activating the data source, double click on the data source and change it to edit mode and then activate it.
Step: 7
Go to the t-code: RSDS for replicating the data sources one by one. Give the data source name and select the source system from where you want to fetch the data.
In order to map the additional fields into the cube 0SD_C03, we should create a info objects for them or we can make use of the standard info object. Double click on the cube name and drop down as shown below and right click on the sales area, add the info object and activate the cube.
And once that is done, map the additional fields to the respective info objects at both the TRCS and RSDS transformations of the respective data source.
Then activate all the transformation.
Step: 8
We will be having a 2 info packages one is init and the other is delta, if not create the info packages.
Here in the IP level, we have proceeded with initialize with Data Transfer first and then enable the delta to capture the transactional data.
Open the init info package cross check all the tabs and choose Initialize with data transfer and go to the schedule tab and click on the start button.
Do the same with other init info packages of all data sources. With this step the sales data will be fetched into the PSA level from ECC source system.
Step: 9
Create the Data Transfer Process for each individual data sources.
When we are doing for the first time have extraction mode as full in the DTP extraction tab, then activate it and execute the DTP, so that the data will be loaded into the cube. Later after enabling the delta info package, change the extraction mode to Delta in the DTP extraction tab.
The DTP with extraction mode as Delta after enabling the delta info package.
Once loading of the data is done into the cube (DTP). Right click on the cube name -> manage, where we could see the infocube requests.
With this step we have successfully loaded the data from ECC system to BW system.
Note: If you install the BW system newly, then make sure along with the info cube install the info objects related to master data. For to do changes in the data, BW provides the privilege to write routines.
Output: Data Preview of both the cubes. Right click on the cube name -> Display data.
- SAP Managed Tags:
