ABAP Development, SAP ABAP, SAP ABAP Testing,

Interface In between SAP and MULESOFT

1. 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:

  1. Create an RFC FM which sends data to COUPA.
  2. Create a Z_table, to store the acknowledgement from COUPA.
  3. Create a 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.
  5. 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.

ABAP Development, SAP ABAP, SAP ABAP Testing,

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.

ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing,

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.

ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing,

*&———————————————————————*
*& 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.

ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing, ABAP Development, SAP ABAP, SAP ABAP Testing,

Leave a Reply

Your email address will not be published. Required fields are marked *