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: 

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


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

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

Tcode: SPROXY

 

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

 

  Activate!

The links of other parts:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2015/09/02/sap-pi-abap-proxy-to-jdbc-synchro...

http://scn.sap.com/community/pi-and-soa-middleware/blog/2015/09/02/sap-pi-abap-proxy-to-jdbc-synchro...

http://scn.sap.com/community/pi-and-soa-middleware/blog/2015/09/02/sap-pi-abap-proxy-to-jdbc-synchro...

4 Comments
Labels in this area