Skip to Content

SAP PI ABAP Proxy to JDBC Synchronous Interface Part II

This part I will show that how to configure PI ESR and generate ABAP proxy consumer in ABAP system.

2. Configure ESR

2.1 Create Data Type

Request data type in ERP side:


Response data type in ERP side:


Request data type in 3rd Party


The JDBC XML format can be found in SAP help in the 5 part Reference

In this scenario I want to use JDBC Adapter to execute a store procedure, so should use the XLM format as below:

Format of EXECUTE Statement

     <storedProcedureName action=" EXECUTE">
          <param1 [isInput="true"][isOutput=true]type=SQLDatatype>val1</param1>
     </storedProcedureName >

PS: <table> element is optional, I leave out in the data type.

Element name ”SP_GET_SUPERIOR_APPROVER” is the store procedure name.

Reponse data type in the 3rd party side:


PS: The element name “Procedure_response” is required according to element name “Procedure” in request data type;

I don’t find the explain for “reponse_1” and “row” in SAP help, but they could be found in PI message monitor.

2.2 Create Message Type

Request message type in ERP side:


Reponse message type in ERP side:


Request message type in 3rd party side:


Response message type in 3rd party side:


PS: The response message type name must be “<reqmt>_response”, <reqmt> is the request message type name.

2.3 Create Service Interface

Service interface in ERP side:


Outbound and Synchronous.

Service interface in 3rd party side:


2.4 Create Message Mapping

Request message mapping:


From ERP request message type to 3rd request message type


The value for action should be “EXECUTE” for store procedure.


Response message mapping:


2.5 Create Operation Mapping



3. Generate ABAP Proxy Consumer

3.1 Configure RFC destination to ESR

Tcode: SM59

The RFC destination name must be: “SAP_PROXY_ESR”


Input the PI server host and port in “Target Host” and “Service No.”, the “Path Prefix” must be “/rep”.


3.2 Generate Consumer



Double click the Service Consumers(Service Interface in PI) “SI_A2J”




The links of other parts:

You must be Logged on to comment or reply to a post.