Customize SAP BW for SAP R/3

SAP BW system needs to be customized for SAP R/3 so that data can be smoothly extracted in SAP BW. Transfer of global setting, exchange rates, replication of data sources are common setting need to be done while setting up SAP BW system.

1) Create User ID for Source System Communication
a) Execute transaction SU01
b) Create user ID RFCUSER, type SYSTEM with profile S_BI-WHM_RFC and S_BI-WX_RFC

2) Set User ID for Source System Communication
a) Transaction RSCUSTA
b) Set “BW User ALE” as RFCUSER

3) R/3 Source System
a) Transaction RSA1
b) Go to Source Systems and Create source system for R/3 and Replicate DataSources

4) Copying Global Settings from R/3
a) Right-click R/3 Source System and choose Transfer Global settings

5) Copying Exchange Rates from R/3
a) Right-click R/3 Source System and choose Transfer Exchange rates

6) Flat file Source System
a) Transaction RSA1
b) Go to Source Systems and Create source system for Flat file

7) BW Source System
a) Transaction RSA1
b) Go to Source Systems and Create source system for BW and Replicate DataSources

8) Maintain Source System ID
a) Transaction RSA1
b) Menu Tools -> Asgnmt of Srce Syst to Srce Syst ID
XBPCLNT100 -> BP
XEPCLNT100 -> EP
PCFLATFILE -> FT

9) Define source system mappings
a) Transaction RSA1
b) Menu Tools -> Mapping of the Source System Names
XEDCLNT100 -> XEPCLNT100
XBDCLNT100 -> XBPCLNT100

10) Permitted Characters
a) Transaction RSKC
b) Maintain permitted characters

11) Activate BEx History
a) Transaction SPRO
b) Go to SAP NetWeaver -> SAP Business Information Warehouse -> Reporting-relevant Settings -> General Reporting Settings in Business Explorer -> Activate Personalization in BEx)
c) Choose option “Activate BEx History” and Execute

12) Number ranges for Transfer Structure
a) Transaction SNUM
b) Enter object name “BI_TS” and Click on “Number Ranges”
c) Choose “Change Intervals”
d) Add new interval “01” (Not 1), from number “0000000001” to number “9999999999” Save and exit

13) Object Changeability Transaction RSA1
a) Go to Transport Connection) Click on button “Object Changeability”
b) Set the following objects as “Changeable Original”
• ISIP – InfoPackage
• RSPC – Process Chain
• RSPT – Process Chain Starter
• RSPV – Process Variants