Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 

Document Purpose

This document provides steps required to load data in BODS from SAP using IDOC interface. This document will be used at the time of proof of concept to demonstrate the ability of Business Objects Data Services (BODS) Real-Time job to receive data using IDOC interface from SAP.

The main objectives are:

·         Loading data in BODS from SAP using IDOC

·         Demonstrate how BODS can be used to receive data using IDOC

·         Display required configurations step-by-step & invocation

·         Demonstrate actual sample load using BODS Real-Time job

Overview:

This document provides systematic approach for the data load in three sections:

  1. Configuration Required at SAP Side:
  2. Configuration Required at BODS Side:
  3. Demonstration Sample Load using BODS Job:

Each of above sections provide information as in how to configure the specific parameters required to get both SAP & BODS ready to communicate with each other. Screen shots provided for better understanding of the parameters & their configuration.

  

SAP [ECC 6.0] Configuration for Outbound IDOC Communication


1.   Display IMG [/nsale]

Connect to SAP System using SAP [ECC 6.0] GUI

Use Transaction Code (TCODE) /nsale to “Display IMG”

                                                  1.0 Display IMG

2.   Defining Logical System

      

      Expand Logical Systems tree & click on the Clock icon in front of “Define Logical Systems

                                   2.0 Logical Systems: overview

Click on the “New Entries” Button

For SAP Outbound IDOC, two Logical Systems are required

First Logical System for SAP (ID4CLNT100)

Second Logical System for BODS (ID100CBODS)

Create these two Logical System as shown below

                    2.1 New Entries for Logical System

Click on the "SAVE" Button to save both the Logical Systems.

Confirmation message “Data was Saved” will be displayed as shown below.

                                   2.2 Data Saved Conformation

Verify two (2)  Logical Systems are present in the SAP

               2.3 Verifying Logical System


3.   Configure RFC Connection [/nsm59]

Use TCODE "/nsm59" to configure RFC Connection

                                        3.0 Configurations of RFC Connection


Select TCP/IP Connection as shown above & click on the Create Button to configure new RFC Connection.

                                  3.1  Creation of New RFC Destination: Technical Settings

Provide required information as shown above

Note: We are using registered Program ID as “DI_RFC_Client”. This could be any simple name, but the same name should be used while configuring “RFC Clients” using BODS Administrator. (Ref: 2.Client Interfaces, page no 21)

Click on the MDMP & Unicode tab

                      3.2 Creation of New RFC Destination: MDMP & Unicode

Note: We have selected “Unicode” radio button because BODS Target RFC Client is Unicode.

Important: There are two buttons “Connection Test” and “Unicode Test” we will test RFC Connection after “Configuring RFC Client” using BODS Administrator in Steps provided later in this document.  (Ref: 3. Testing RFC Client from SAP, page no 23)

4.   Create Transactional RFC Port [/nwe21]

Use TCODE "/nwe21" to configure the RFC Port

Expand Ports tree to go to “Transactional RFC”

                                        4.0 Creation of New Transactional RFC Port

Select Transactional RFC and click on “Create” Button.

   4.1 Transactional RFC Port Name

Provide Name "DI_PORT" as shown above.

Click on Continue button 

  

Port Name "DI_PORT" will appear in the list as shown below.

                        4.2 Transactional RFC Ports Overview

Click on the DI_PORT to provide Description & RFC destination (“DI_RFC_DESTINATION” ) that we have created in earlier section (Ref: 3.Configure RFC Connection, page no 7)

5.   Create Partner Profile [/nwe20]

Use TCODE "/nwe20" to configure Partner Profile.

                                               5.0 Creation of New Partner Profile

Click on Create button to create new partner profile

Create partner profile as shown below 

Note

1. Provide partner no.  “ID100CBODS “ i.e same as BODS Logical System.

2. Agent  50010120 “EDI Department”  is necessary to communicate with non-SAP systems like BODS. Without this agent IDOC communication will not be successful.

                                      5.1 Partner Profile Permitted Agent

Click on the Save button to save the partner profile

After saving the "Create outbound parameter" will be activated in “Outbound paramtrs”

                                      5.2 Create outbound paramtrs.

Click on “Create outbound parameter”   button in “Outbound paramtrs” section.

                                       5.3 Partner Profile: Outbound parameters

Provide the Message Type "MATMAS" & IDoc Basic type "MATMAS01"

Save "Partner profile: Outbound parameters" using Save button

Confirm Partner Profile & Outbound Parameters added.

                                                          5.4 Outbound Parameters Overview


6.   Change Distribution Model [/nbd64]


Use TCODE "/nbd64" to configure Change Distribution Model

                                                       Screen Shot 6.0 Change Distribution Model

Click on the “Create Model View”

Note: If this button is inactive then select the Model View in left hand tree and click on Edit button to enable “Create Model View” button & active.

                       6.1 Create Model View

Provide Short text & Technical name as follows:

Tech name same as short text.Click continue button

The DI_MODEL will be added to the list as shown below

                                        6.2 Distribution Model Changed overview

Select DI_MODEL and click on “Add Message Type” button

               6.3 Add Message Type for Changed Distribution Model

Sender is SAP Logical System & Receiver is BODS Logical System.

Provide all information as shown above and click on continue button.

The Distribution Model created is shown below.

                            6.4 over View of Distribution Model

Check if IDOC distribution is turned on.

Run transaction "/nbd61" and make sure the checkbox is set.

                  6.5 Activation Status

Create Real Time Job in BODS


1.   Create SAP Data store

Go to Data stores tab in BODS Designer, right click on blank area to create "NEW".

Create SAP Datastore by providing required SAP Application Server Information & creadentials

                      1.0 Creation of SAP Data Store

Expand the "SAP_TTL_Client100_DS" datastore

Select the IDOCs and Right click , click on “Import By Name…”

                    1.1 IDOC'S importing

               1.2 IDOC Import by Name

Provide Type & Name as shown above & click on “Import” to import IDOC in data-store

2.   Build Real Time Job

Build a Real Time Job with a DataFlow inside…

                    2.0 Real Time Job Overview.

Data Flow is as Follows

                           2.1 Data Flow


Query is used to Unnest  as follows

                              2.2 Query Unnest

Note: You can unnest by right clicking on MATMAS01 as shown below

          2.3 Unnest Option

The Target XML file configuration is a follows :


         2.4 Target XML file Configuration


Note: Make sure “Make Port” checkbox is checked.

 
 

Configuring RT Services and RFC for IDOC through Web Administrator


1.   Configuring Real Time Service & Service Provider

Open BODS Web Administrator

Expand Real-Time tree and select Real-Time Services to do Real-Time Service Configuration

Provide required information as shown below:

                    1.0 Web Administrator: Real Time Services Configuration

Job Name is Real Time Job name that you have created in earlier stage in designer (Ref: 2.Build Real Time Job, page no 18)

Browse the Job and select Job name

In service provider settings - Click on Add button to add Job Server and make it enabled.

         Once the Service is configured you can start the service by selecting the service & click on start button.

                                   1.1 Real Time Services Status


2.   Client Interfaces


Using BODS Web Administrator

Expand Real-Time tree and select Client Interfaces to do RFC Client Configuration

Provide required information as shown below

                                       2.0 RFC Client Configurations

Click on Apply button

Note: RFC Program ID must be same as register Program ID given while configuring RFC Connection. (Ref: 3.Configure RFC Connection, page no 7)

Go to “List of Supported IDOC” tab & then click on “Add” button to add IDOC.

                                             2.1 Supported IDOC

Provide IDOC Type which is BASIC IDOC TYPE in SAP. (Ref: Screen Shot 5.3 Partner Profile: Outbound parameters, page no 13)

Service Name must be same as Real Time Service we have created & click on Apply button to get the IDoc Information registered.

List of Supported IDOC will be displayed as shown below

                              2.2 Lists of Supported IDOC's

Note: You may add more than one iDOC type per RFC Client

Once the RFC Client configured you can start RFC Client.

Make sure RFC Client is started  & status is “Waiting for Idoc” as shown below:

                            Shot 2.3 RFC Client Interface Status


3.   Testing RFC Client from SAP

Use TCODE "/nsm59" to go to Configuration of RFC Connections

Open TCP/IP Connections & locate DI_RFC_DESTINATION

Double click & open DI_RFC_DESTINATION

Click on “Connection Test” button

                    3.0 Testing RFC Client from SAP

If everything configured properly, you will see success message as shown below.

                       3.1 Connection Test Success


Note: If Connection test failed, make sure that the RFC client on BODS side started properly with green icon.

Sending Material from SAP [/nbd10]

1.    Sending Material MATMAS from SAP

  Use TCODE "/nbd10" to "Send Material"

                                   1.0 Sending Material from SAP


  Click on the match code button

                    1.1 Material Numbers / Material Description


Click on “Start Search “button   for finding the entries for material numbers.

                   1.2 Selections of Material and Material Description

Select any Material number from the list displayed above and click on OK button.

Selected material number will appear in front of "Material" on Send Material screen.

Provide required fields as shown below & make sure the "Logical system" is BODS Logical System ID100CBODS

                        1.3 Send Material


Click on Execute button. We will get couple of following messages.

1.4 IDOC Information after material sent

Click on “OK”

2. Check Received MATMAS IDOC in BODS Using BODS Web Admin

Go to BODS Web Admin, click on Real Time Services to check that one IDOC request received as shown below

 

                    2.0 Received Requests in Web Administrator: Real Time Services

 
 

1. Checking the output data in XML File

Go to BODS Designer

Open the Real-Time Job Dataflow

Go to the target MATMAS01_OUT.xml & click on view data to confirm the data received

Generated output XML file data as follows

13 Comments
Labels in this area