Loading Data from ECC System (Standard DataSources)
§
BI Content defines 60% of BI system
§
For flat files we were creating our custom data
sources
§
Data sources defined by SAP is called Standard
data sources
§
Standard data sources exists in ECC system
§
We will need to get this standard data source
from ECC system to our BI system
§
Once that available in BI system then we can
create an InfoPackage and extract data to standard data sources
·
Non Logistics DataSources /General DataSources
§
Non-LOs DataSources name start with 0App_Area
like 0FI
·
Logistics DataSources
§
LOs DataSources name start with 2lis
§
To use standard DataSources you need to activate
it
Non Logistics DataSources
In Non-LO DataSources the flow is Base Table --->
InfoPackage ---> DataSource
RSA2 (Check DataSource Structure) --->RSA5 (Activation of
DataSource) --->RSA6 (Post Processing) ---> RSA3 (Extract Checker)
---> Replicate Application Component (in BW system)
1)
Logon to ECC system
a)
To activate general DataSource go to RSA5
i.
Expend SAP/R3, expend FI application component,
expend FI-AP, FI-AP-I0 is a transactional data source
ii.
To check properties of the data source copy its
name go to RSA2, provide name of DataSource it shows this DataSource is based
on functional module
Data sources can be made by three ways:
§
Tables or View
§
Queries or InfoSets
§
Functional Module / ABAP Code, which will create
an interface b/w DataSource and base table
Verify the fields if it suits your need, Data comes to standard
DataSource from the tables of ECC called Base tables, Functional consultants
load data to the tables of ECC. The job of BI consultant is to extract data
from all these base tables to DataSource and from DataSources to the BW system
iii.
Select FA-AP-I0 in the RSA5 and click the
Activate DataSources button from application toolbar
b)
To verify is it activated successfully go to
RSA6, expend SAP-R/3, then FI, then expend FI-AP, if you find your DataSource
here its mean its activated
c)
To check validity of the general DataSource go
to RSA3, give DataSource name, click Extraction button, then select List button
to check data
2)
Logon to BW system to get the structure of
activated Non-LO DataSource
a)
In DWW go to Source System, expend SAP, double
click on your ECC system
b)
Find your application component, right click
Financial Accounting Vendors and select Replicate Metadata
3)
To load data from source system to our
DataSource, create InfoPackage and Execute it
Logistics DataSources
In LO DataSources the flow is Base Table ---> Setup Table
---> InfoPackage ---> DataSource
RSA2 (Check DataSource Structure) --->RSA5 (Activation of
DataSource) --->RSA6 (Post Processing) ---> LBWG (Empty Setup tables)
---> LBWE (LO Cockpit) ---> SBIW (Fill Setup tables) --->RSA3 (Extract
Checker) ---> Replicate Application Component (in BW system)
1)
Logon to ECC System
a)
To activate LO DataSource go to RSA5
i.
Expend SAP-R/3, expend MM then MM-I0, note
logistics can be from MM, SD most of the times, select 2LIS_02_ITM
ii.
To check properties of the data source copy its
name go to RSA2, provide name of DataSource
iii.
In the RSA5 and click the Activate DataSources
button from application toolbar
b)
To verify it go to RSA3,
you will get 0 records, it doesn’t mean that Base tables of ECC don’t have data, rather we need to fill the
Setup tables
c)
To fill Setup tables, go to SBIW, expend Setting
for Application Specific DataSources, expend Logistics, expend Managing Extract
Structures, then Initialization, to make sure that there is no data in setup
tables click Delete the Contents of Setup tables, it will ask for application
no
i.
To find application number go to LBWE, you will find that there is 02 in
front of Purchasing, it’s the application number enter it which will delete all
the data from purchasing DataSources
ii.
In SBIW select Filling in the Setup tables then
Application specific setup of statistical data click on execute in front of
perform setup-purchasing, give name of run and make sure the termination date
is always in future bcz data is in huge volume which takes time to load to
avoid losing any records added during load time we specify termination date in
future, always execute it back end, so go to Program->Execute in Background
from top menu bar, enter default printer name like lp01, select immediately on
next window and click save
iii.
To monitor this job go to SM37, once the job is
complete, you can verify the records from extract checker
d)
To check validity of the LO DataSource go to
RSA3, give DataSource name (2LIS_02_ITM), click Extraction button, then select List
button to check data
2)
Logon to BW system to get the structure of
activated LO DataSource
a.
In DWW go to Source System, expend SAP, double
click on your ECC system
b.
Find your application component (MM) , and
select Replicate Metadata
3)
To load data from source system to our
DataSource, create InfoPackage and Execute it
a.
Right click 2LIS_02_ITM and select Create
InfoPackage, provide description and click Save
b.
Update
Tab
i.
Full update will load all the records without
setting the marker
ii.
Initialize of Delta Process will set a marker,
which indicate till this record data has been loaded
iii.
Initialization with Data Transfer is used when
we are loading data for the very first time and the marker was not set, it is
almost similar to full update but it will also set the marker till the records
are loaded
iv.
Initialize without Data Transfer will just set
marker so that we can use the delta load in the upcoming loads to our
InfoProviders, means when in this InfoPackage is executed it won’t load records to InfoProvider instead it will
set the marker for future delta load,
select here this option
c.
Data Selection Tab
i.
To set the criteria (e.g. purchasing document,
purchasing date) for InfoPackage execution i.e. from which the delta will be
available, select From Value for BUDAT
(Purchasing Document Date) like
20.04.2012, then from top menu bar select Scheduler---> Initialization
Options for Source System, click Continue in pop up
d.
Schedule Tab
i.
Start
Data Load Immediately and click Start button
