Docstoc

Setting up Connection between BW and R/3 for Data Load

Document Sample
Setting up Connection between BW and R/3 for Data Load Powered By Docstoc
					 Setting up Connection between
 BW and R/3 for Data Load




Applies to:
SAP BI 7.0. For more information, visit the Business Intelligence homepage.

Summary

This document guides to establish connection between BW and R/3, so as there can two way
communications for various purposes. This can be done by simply creating source system in T-
Code SCC4 and later generating Partner Profile. This information is available easily on
help.sap.com and SDN (see related links), but this setting is not enough to have data transfer
between R/3 and BW. To achieve one is expected to make setting for Message types, which will
behave as a protocol for communication between the two systems. So this document takes you step
by step to create source system and which message types to use for communication.

Author:     Aadil Siddiqui
Company: Patni Computers
Created on: 13th October 2008

Author Bio

              Aadil Siddiqui is currently working in Patni Computers Ltd. He is working on SAP BI 7.0 and is
              mainly involved in Development and Enhancement work.




SAP COMMUNITY NETWORK                                   SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                   1
                                                                                        Setting up Connection between BW and R/3 for Data Load




Table of Contents
Communication Setting between BW and R/3: ..................................................................................................3
Step 1: Define Logical System in R/3. ................................................................................................................4
Step 2: Assigning Logical System to Client. .......................................................................................................5
Step 3: Setting Up an RFC Destination. .............................................................................................................6
Step 4: Distributing Data Model:.........................................................................................................................7
   Message Types Involved in Process of Data Loading:...................................................................................7
Step 5: Generating Partner Profile ...................................................................................................................11
Step 6: Maintaining Message types in T-Code WE20:.....................................................................................13
Related Content................................................................................................................................................15
Disclaimer and Liability Notice..........................................................................................................................16




SAP COMMUNITY NETWORK                                                               SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                                               2
                                                             Setting up Connection between BW and R/3 for Data Load


Communication Setting between BW and R/3:
This document guides one to establish connection setting between BW and R/3 for data loading and other
communications. Generally when we start working on a new system or if we want to have connection
between BW and any other source system of our choice, we have to contact maybe the basis to team to
setup connection. But here we can understand the very simple way to connect any source system with your
BW system.
All one needs to do is go through the following steps and the systems will be ready to transfer data.
Creating Source System (SALE): This step creates source systems which are to be connected.
    1. Assigning Source System to Client (SALE): This step gives a logical name to a SAP Client from
       which the communication is to be established.
    2. Setting up RFC Destination (SM59): This step is required to establish remote connection to the
       partner with which Source system is trying to communicate. Here one has to maintain the logon and
       IP details of the target system.
    3. Distributing Data Model (BD64): A distribution model is used to model a distributed environment in
       which you specify messages exchanged between sending and receiving systems. Here one has to
       define the message protocols with which the two systems will communicate.
    4. Generating Partner Profile (BD82): This process generates a partner profile for each system with
       which your system communicates. Outbound records are created in the partner profile for each
       outgoing message, and inbound records are created for each incoming message.
        Note: If one distributes Data Model before generating partner profile then one has to redefine partner
        profile in other system also (repeat step in both system). In this document we are generating partner
        profile after Distribution of data model so as to demonstrate how to maintain inbound and outbound
        message types in WE20.
    5. Maintaining Message Types (WE20): This process is optional. Generally while generating partner
       profiles we automatically get the respective Outbound and Inbound messages, which can be
       checked in T-Code WE20. If the message types are not defined then one can manually do it by
       following this process.
These steps will ensure that the BW and other source systems are in sync and will communicate as
expected.




SAP COMMUNITY NETWORK                                     SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                     3
                                                         Setting up Connection between BW and R/3 for Data Load




Step 1: Define Logical System in R/3.
Log into R/3 and then go to transaction SALE. Here under IDoc Interface / Application Link Enabling (ALE)
  Basic Settings    Logical Systems     Define logical system. Here one can define the source systems one
wants to connect. Make entries for both R/3 and BW system.
T-Code: SALE




Defining Logical systems




Please repeat the same step in BW also.




SAP COMMUNITY NETWORK                                 SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                 4
                                                            Setting up Connection between BW and R/3 for Data Load


Step 2: Assigning Logical System to Client.
Once logical systems have been defined, next step is to assign these systems to respective clients. The link
basically establishes a logical name for an SAP client in the distribution process. A one-to-one relationship
exists between a logical system and a client. Again, this setting is required on every system involved in the
process.




Once an entry is made in above screen, one is navigated to next screen where standard settings are needed
to be maintained. Here importantly one needs to maintain the Logical system that is needed to be assigned.
Then save the
settings.




Please repeat the same step in BW also with respective client number for BW.




SAP COMMUNITY NETWORK                                    SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                    5
                                                               Setting up Connection between BW and R/3 for Data Load


Step 3: Setting Up an RFC Destination.
In this step, you create an RFC destination on the local system for each remote SAP system with which you
want to communicate. In the RFC destination, you specify all the information necessary to log on to the
remote system to execute functions remotely, including the host name, the user ID, the password, the client,
the system number, and additional communication settings.
So after creating a new entry of type ABAP Connection (The ALE process uses type R/ 3 connections to
communicate with a remote SAP system, and the EDI process uses type TCP/IP connections to
communicate with the EDI subsystem), one is expected to fill in details in Technical tab. Fill the Target Host
Id (this should be same as defined in SALE) and give System No. and IP Address of the target system or the
Alias for the system as shown below:




Next in the Logon & Security tab, fill login details for the target system (in this case BW).




SAP COMMUNITY NETWORK                                       SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                       6
                                                            Setting up Connection between BW and R/3 for Data Load


Please repeat the same step in BW also but select source system as R/3 in SM59.

Step 4: Distributing Data Model:
Having created the basic ALE Infrastructure (till step SM59), lets move forward to Distribute the data model.
A distribution model is used to model a distributed environment in which you specify messages exchanged
between sending and receiving systems. You must create the model on the system that will be the model's
owner. This owner is responsible for maintaining the model and distributing it to various systems. Other
systems are prohibited from making changes to the model. Following steps are involved in this process.
    1. Maintain a distribution model.
    2. Generate a partner profile.
    3. Distribute Data Model.
You begin by clicking the Create Model View button on the main screen of transaction BD64.




Once Distribution Model is created, let’s add Message type using which the sender and receiver system will
communicate (in this case BW and R/3 also remember that the communication will be both ways i.e. from
R/3 to BW and from BW to R/3). To achieve this, place cursor on Model created (VCR3BW) and click on
Add Message type button on top right corner. This will open a dialog button where fill the sender system id
and receiver system id.

Message Types Involved in Process of Data Loading:
RSRQST: This message type is send by BW to R/3 while loading any data. This gives information about the
data source, selection condition and other BW settings to R/3. As and when a load is started in BW,
RSRQST message type is sent to R/3 requesting for data.
RSINFO: Once R/3 receives RSRQST message from BW, it sends an acknowledgement message type to
BW informing about the status of request. That is whether the request can be handled or not by R/3. It also
gives information about how many data packages are being send and what is the total number of records
extracted for the given data source and selection.
RSSEND: After sending a positive acknowledgement to BW, R/3 starts the extraction job and starts
collecting data in data idocs. This message type carries the actual data with it into the BW system.
For more details on this please check my earlier article.
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/0087780d-81b0-2a10-eb82-86e1062f1a2d
Hence we need to maintain these message types for the distribution model we created above. But make
sure that correct messages are assigned to correct system.




SAP COMMUNITY NETWORK                                    SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                    7
                                                       Setting up Connection between BW and R/3 for Data Load


So Click on Add Message Type and give sender as R/3 system and receiver as BW system and message
type as RSINFO.




Similarly add message type RSSEND from R/3 to BW.




Now add message type RSRQST from BW to R/3.




SAP COMMUNITY NETWORK                               SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                               8
                                                              Setting up Connection between BW and R/3 for Data Load




Having created the Distribution model, let’s distribute this model. This process will replicate a similar setting
in BW side automatically.
Please note that Distribution of data model is not needed to be repeated in BW side as this step
automatically replicates settings in BW.
Go to Edit   Model View     Distribute.




Choose the target system in which the settings needs to be replicated.



SAP COMMUNITY NETWORK                                      SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                      9
                           Setting up Connection between BW and R/3 for Data Load




SAP COMMUNITY NETWORK   SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                   10
                                                           Setting up Connection between BW and R/3 for Data Load




Step 5: Generating Partner Profile
This process generates a partner profile for each system with which your system communicates. Outbound
records are created in the partner profile for each outgoing message, and inbound records are created for
each incoming message. You can execute transaction WE20 to view the partner profiles generated by this
transaction.




Next, one is taken to following screen where one can define the partner system id and the user that
communicates.




SAP COMMUNITY NETWORK                                   SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                   11
                                                           Setting up Connection between BW and R/3 for Data Load




After this Execute and wait for the system messages which inform whether partner profile was successfully
created or not.




Hence the partner profile was successfully generated…




SAP COMMUNITY NETWORK                                   SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                   12
                                                            Setting up Connection between BW and R/3 for Data Load


Now logon on to the BW system and go to T-Code BD64 and test the partner profile settings, whether they
are correctly transmitted or not. We can execute it here (in BW) also and get our settings tested.

Step 6: Maintaining Message types in T-Code WE20:
Again we need to follow this activity both in BW and R/3. When in R/3 systems WE20, then click on BW
system id, and check whether Outbound and Inbound parameters are correctly filled if not then fill it manually
as below:




Depending on your client settings one can define different message types for eg:




SAP COMMUNITY NETWORK                                    SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                    13
                                                         Setting up Connection between BW and R/3 for Data Load




Now test once again for Partner profile setting and we are ready to have data transfer between BW and R/3
(this can be done directly using T-Code BD82).




SAP COMMUNITY NETWORK                                 SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                 14
                                                        Setting up Connection between BW and R/3 for Data Load




Related Content
      •   http://help.sap.com/bp_biv135/BBLibrary/documentation/B84_BB_ConfigGuide_EN_DE.doc
      •   https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/0087780d-81b0-2a10-eb82-
          86e1062f1a2d
      •   http://help.sap.com/printdocu/core/Print46c/EN/data/pdf/CABFAALEQS/CABFAALEQS.pdf
      •   For more information, visit the Business Intelligence homepage




SAP COMMUNITY NETWORK                                SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                15
                                                              Setting up Connection between BW and R/3 for Data Load



Disclaimer and Liability Notice
This document may discuss sample coding or other information that does not include SAP official interfaces
and therefore is not supported by SAP. Changes made based on this information are not supported and can
be overwritten during an upgrade.
SAP will not be held liable for any damages caused by using or misusing the information, code or methods
suggested in this document, and anyone using these methods does so at his/her own risk.
SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of
this technical article or code sample, including any liability resulting from incompatibility between the content
within this document and the materials and services offered by SAP. You agree that you will not hold, or
seek to hold, SAP responsible or liable with respect to the content of this document.




SAP COMMUNITY NETWORK                                      SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com
© 2008 SAP AG                                                                                                      16

				
DOCUMENT INFO
Shared By:
Stats:
views:59
posted:10/11/2012
language:English
pages:16
Description: Setting up Connection between BW and R/3 for Data Load