Interface In between SAP and MULESOFT

rajucd81 · ‎05-16-2017

Applies to

SAP ECC, MULESOFT.

Summary

In the New IT world the businesses has to be connected with Cloud application to run their business meritoriously in a compatible mode with new generation devices like Mobiles, Tabs. MULESOFT is a state-of-the-art middleware application in the current market to interact easily and effectively with core business applications like SAP.

This document is trying to illustrate how easily the interface can be built in between SAP to COUPA, and Mulesoft as middleware. New IT world this kind of interface is commonly built in the business.

Created on

05th May 2017

Authors

Authors Bio

Raju C D is a SAP Global speaker and Mentor and having 13+ years of experience as a SAP Consultant. Currently working with Accenture Solutions Pvt. Ltd.

Adarsh swami is Mulesoft consultant and having 4 years of experience with Mulesoft product. Currently working with Accenture Solutions Pvt. Ltd.

Table of Content

Introduction

Overview

SAP ECC objects creation
1. Create a RFC FM which sends data to COUPA
2. Create a Z_table, to store the acknowledgement from COUPA
3. Create an RFC FM which receives acknowledgement from COUPA
4. Create a Z_program and call the RFC FM which sends data to COUPA with help of Mulesoft

Connecting Mulesoft and SAP using BAPI and IDOCs
1. Push Data from Mulesoft to SAP
2. Push data from SAP to Mulesoft
  1. SAP RFC Settings
  2. Mulesoft Configuration
  3. SAP connector settings

Sample Coupa API calls from Mulesoft

Introduction

This Document gives an in-detail approach to create an interface in between SAP and COUPA, with help of MULESOFT middleware application. It has step by step activites to be done in both SAP and MULESOFT applications. Technically Mulesoft integration is very stress-free comparatively with other middleware applications to interact with could base applications.

2. Overview

Requirement: SAP sends the data by running a report program to COUPA and COUPA sends back acknowledgement to SAP. COUPA is a cloud based P2P application.

Solution:

Create an RFC FM which sends data to COUPA.

Create a Z_table, to store the acknowledgement from COUPA.

Create a RFC FM which receives acknowledgement from COUPA.

Create a Z_program and call the RFC FM which sends data to COUPA with help of Mulesoft.

Create RFC connection in between SAP and Mulesoft, usually this connection will be available when Mulesoft was set up as Middleware in the systems environment.

3. SAP ECC objects creation

3.1. Create a RFC FM which sends data to COUPA.

Before creating FM, need a Function group, so create function group first.

Go to Tcode SE37 and choose the GOTO Menu to create Function Group.

FUNCTION z_receive_ack_coupa.

*"----------------------------------------------------------------------

*"*"Local Interface:

*"  IMPORTING

*"     VALUE(IM_ACK) TYPE  ZCOUPA_ACK

*"----------------------------------------------------------------------

  DATA: wa_zcoupa_ack TYPE zcoupa_ack.



  IF NOT im_ack IS INITIAL.

    SELECT SINGLE * FROM zcoupa_ack

                     INTO wa_zcoupa_ack

                    WHERE po_number EQ wa_zcoupa_ack-po_number

                    AND status EQ space.

    IF sy-subrc EQ 0.

      wa_zcoupa_ack-status = im_ack-status.

      wa_zcoupa_ack-stat_desc = im_ack-stat_desc.

      MODIFY zcoupa_ack FROM wa_zcoupa_ack.

    ENDIF.

  ENDIF.



ENDFUNCTION.

*&---------------------------------------------------------------------*

*& Report  Z_SEND_PO_2_COUPA

*&

*&---------------------------------------------------------------------*

*&

*&

*&---------------------------------------------------------------------*



REPORT  z_send_po_2_coupa.

*Data Declaration

DATA: wa_ekko TYPE ekko,

      it_ekpo TYPE STANDARD TABLE OF ekpo,

      l_v_mulesoft TYPE rfcdest VALUE 'MULE100'. " Moulesoft Logical system

*Selction Screen

PARAMETERS p_ebeln TYPE ebeln.



START-OF-SELECTION.

*Fetch PO Header

  SELECT SINGLE * FROM ekko INTO wa_ekko WHERE ebeln = p_ebeln.

  IF sy-subrc EQ 0.

*  Fetch PO Item

    SELECT * FROM ekpo INTO TABLE it_ekpo WHERE ebeln = p_ebeln.

  ELSE.



    MESSAGE 'Enter Correct PO Number' TYPE 'E'.

  ENDIF.



  IF NOT wa_ekko IS  INITIAL.

    CHECK l_v_mulesoft IS NOT INITIAL.



**Also check if the RFC destination is active,

**if not dont send the destination back

**this is to avoid system resulting in runtime error if connection fails

    CALL FUNCTION 'RFC_PING'

      DESTINATION l_v_mulesoft

      EXCEPTIONS

        system_failure        = 1

        communication_failure = 2

        OTHERS                = 99.

    IF sy-subrc EQ 0.

*   RFC FM to send PO details to COUPA system.

      CALL FUNCTION 'Z_SEND_2_COUPA'

        DESTINATION l_v_mulesoft

        EXPORTING

          im_ekko = wa_ekko

        TABLES

          im_ekpo = it_ekpo.



    ELSE.

      MESSAGE 'RFC Error' TYPE 'E'.

    ENDIF.





  ENDIF.