Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

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

2 comments:

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget