MDO for SAP / Vendors / Set Up / Integration

Integration

Connection Setup 

MDO needs to be configured to connect with an SAP server.  

For connection set up, follow the steps below. 

  1. Login to MDO with administrator credentials. 
  2. On the Home Page, select Settings > Advanced > System configuration  
  3.  Systems page opens. Click Add new server 
  4. Add new System page opens. Select Server Type SAP from the dropdown. 
  5. Enter the relevant information for: 
    • Connection Description 
    • Connection Name 
    • Host IP 
    • System No 
    • User Id  
    • Password 
    • SAP Client 
    • Language 
    • Alias 
    • Maximum Connection 
    • Partner Type 
    • Partner Number 
  6. Select Save. 

Interface Scenario 

Create and configure interface scenarios for inbound/outbound requests and data mapping between SAP and MDO fields (and vice versa) for Vendor Master. 

Create Interface Scenario 

To create new interface scenario, follow these steps:

  1. Go to the MDO homepage. 
  2. From the left menu select Settings > Integration & Jobs > Scenario. Interface Scenario page opens. 
  3. Click Create. 
  4. Enter the System, Header and Administrator Details as listed below. 
Field Name   Description  
System Detail 
Source System*  Select the communicating system from which you want to connect. 
Target System*  Select the communicating system to which you want to connect. 
Partner System*  Select the type of communicating process. E.g., Web Service, SAP etc. 
Connection Type  For Inbound/Outbound configuration, select- Idoc and for RFC configuration, select RFC. 
Trigger Immediately  Mark the checkbox if you want to trigger the scenario immediately after creation. 
Schema Type*  Select type of schema to be used during Integration process. E.g., WSDL, XSD, JSON etc. 
Job Name  Give the Job appropriate name. 
Job Description  Give the Job appropriate description. 
Enable Validation  Select the checkbox if you want to run the validations during integration. 
Trigger Periodically  Select the checkbox if you want to trigger the scenario periodically after creation. 
Header Detail  
Scenario Description*   Give description for the scenario. 
Direction*  Select appropriate dropdown. 

Inbound: If the flow of data is from SAP to MDO. 

Outbound: If the flow of data is from MDO to SAP. 

Is Internal Schema  Select this when an external system requires integration utilizing MDO’s internal schema. 
Is Synchronous  Check this checkbox when a communication needs to be synchronized between request and response. 
Object*  Select object from the dropdown list for which you are creating the scenario. 
Finishing Point  Select the end point in MDO for the request. E.g., XSL, WSDL, TABLE etc. Note: If XSL is selected, continue process to Step 8. 
Queue Name  Select the queue relating to the module to transport the data requests.  
File Type  Select the file type of the schema. 
Soap Authorization  Select between basic or digital sign type authorization. 
Proxy Settings  Select the proxy settings from the list of connections. 
Alias  Provide the username for SOAP authorization 
Password  Provide password for the scenario. 
Alternate Number  Provide the field ID to be replaced with SAP number. 
Soap Version  Select SOAP version among the list provided. 
Scenario key Fields  Select the key fields of the object selected from the list provided. 
Enhancement Number  Select the custom programs from the list displayed if required. 
Is Bulk Request  Check this in case the data need to be processed in bulk. 
Workflow Required  Check this in case workflow is required for the scenario to be triggered. 
Custom Script  Write your own custom script here to determine the queue name for the scenario. 
Auto acknowledge  Check this in case auto-acknowledgement of the scenario. 
Administrator Details  
Administrator Name*  Enter the administrator name. 
Email Id*  Enter the administrator email ID. 
Telephone Number  Specify administrator’s telephone number. 
Notification Detail  Specify the status in which the notification needs to be triggered. 
Plant Code*  Specify the plant code for which the scenario needs to be triggered. 

 

5. Click Save. 

6. If XSL was selected as Finishing Point, after saving, return to Interface Scenario list screen. 

7. Locate the relevant scenario. Click on XSL under the Download Files column. The XSL Data pop-up will appear.  

8. Click Generate. 

Configuring Interface Scenario 

Define Message Type 

This section provides a detailed description on how to define the message type for an interface scenario. 

To define message type:

  1. From SAP access the WSDL file for the relevant message type.  
  2. Go to Settings > Integration & Jobs > Scenario and click on the Detail hyperlink (under the Actions column) corresponding to the relevant interface scenario.  
  3.  The Control Data Configuration page opens.  
  4. Click on Create 
  5. Enter Message Type and Basic Type from the SAP WSDL file. 
  6. Select the Extension and Order value from the respective dropdown list.  
  7. Select the check boxes for Response Type and Sync Response for MDO to differentiate the response from the request data. 
  8. Click on Save. 
  9. On successful creation of the Control Data, a confirmation message is displayed, and the newly created message types appear in the List. 

 

Upload Schema 

This section provides a detailed description on how to upload an SAP schema into MDO. 

To upload schema, follow these steps. 

  1. Download the relevant schema from the SAP sever and save the xml file. 
  2. Open the xml file and replace the word ‘all’ with ‘sequence’ and Save the file. 
  3. From the left menu select Settings > Integration & Jobs > Scenario. Interface Scenario page opens. 
  4. Go to the Interface Scenario page and click on the Detail hyperlink (under the Actions column) corresponding to the relevant interface scenario to upload the schema. 
  5. Select the relevant record. Click on the Upload schema icon.  
  6. The Schema Upload page opens. Select Browse and locate the altered .xml file. 
  7. Click on Upload to upload the .xml file. 

 

Field Mapping 

This section provides a detailed description on how to map fields between MDO and SAP. 

There are three steps to this process. 

  1. Map the MDO Structure to SAP Structure 
  2. Map the fields within the structure 
  3. Map the grid / table within the structure (if applicable) 

To map the structure: 

  1. From the left menu go to Settings > Integration & Jobs > Scenario 
  2. From the Interface Scenario page click on the Detail hyperlink (under the Actions column) corresponding to the relevant interface scenario to upload the schema. 
  3. Activate the record by selecting the check box under the Active column. 
  4. Click on Field Mapping icon. The MDO Structure page opens. 
  5. Map the MDO structure to the SAP structure using drag and drop (to relevant side). 

To map fields within a structure: 

  1. Expand the MDO Structure(s) that contain the required fields to be mapped. 
  2. Expand the SAP Structure and locate or search for the corresponding SAP field. 
  3. Selected the MDO field and drag it over the SAP field to be mapped with.

To map a grid/table within a structure: 

  1. From the SAP Structure, expand the relevant structure to display the item.
  2. Right click on the item to display “Map Grid” option.
  3.  Click on “Map Grid” to open the grip Mapping pop-up. 
  4. Enter the Grid ID (into Grid name field) and Save. 
  5. Now map the fields required for the grid by following steps 1-3 in the ‘To map fields within a structure’ section above.