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