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:
HI Zhang
While creating response message type in third party side do we have to create another node “response1” in structure?
Is it mandatory?
Midhun
Hi Midhun
I just got the structure of response message in PI monitor after make a test, I didn’t find the explain of this part in the SAP help.
Hi Zhang,
Does the JDBC Structure change, if we want to retrieve the data from Views.?
Thanks and Regards,
Prasad.