Tuesday 21 August 2012

Day 7: How to install datasources


Hi ,

About Me Topics
This is Rahul Bindroo
SAP Netweaver Certified Professional 
and Certified Project Management Professional. 
rahulbindru@gmail.com
  1. Day 1 : Overview
  2. Day 2 :SAP SD Overview
  3. Day 3: Basic Settings
  4. Day4 : Advanced Basic Settings



I welcome you to 7th day of my blog....




Alright Guys I am sorry for being so late in writing this page...!

Lets first try a approach where we are using the datasources which are delivered by SAP as part of SAP Content.

There are few important steps we should keep in mind while starting the developments:-
A.      IN ECC source system
a.       Login SAP ECC source system
b.      Activate the datasources from dormant to activate state
c.       Generate datasources and their extraction programs in case of logistics transaction data sources



Lets take them once by one :-
1.       Login SAP ECC source system: You should have valid authorisation in SAP ECC system with access to work in tcodes, SBIW,RSA5,RSA6,RSA3 etc.
2.       Activate the datasources from dormant to activate state:-
a.       Tcode RSA5àfind the datasources (lets say we are working 2LIS_11_VAHDR SD Sales: Document Header) in the hiearachy. Keep your cursor on the datasource and click at activate datasource.
b.      RSA6à Check in the hieararchy whether new datasource(2LIS_11_VAHDR) is visible.If yes then go ahead with next step.
3.       Generate datasources and their extraction programs in case of logistics transaction data sources

a.       Tcode LBWEàGenerate extraction structure and  extraction program and select job control as direct update. I will talk about the job controls later but at this moment use it as direct update. Guys this place helps us to select fields for our datasources, generate extracton program and secondly whether we want something for selection field or hidden field.
b.      Now you are through with the creation of structure and tables infact a table is generated which is called as set up table.
c.       Lets take data loading activity later at this moment lets have the data flow in place.

Alright guys now login SAP BI system we need to do the following activities:-

B.      IN BI system
a.       Login SAP ECC source system
b.      Replicate datasources
c.       Generate datasources and their extraction programs in case of logistics transaction data sources

Lets talk about them tomorrow...

Bye
Your Rahul