Send csv file via PI to SAP PROXY

[stradav]

Hi,

we try to implement a szenario with SAP PI:

PI fetches csv file from SFTP and should send the data to SAP ERP PROXY.

The csv file has 0 to * line items. Every line item is an item of the following data type:

On sending the data do the proxy adapter we get the follwing error message:

SOAP: Error occurred: com.sap.engine.interfaces.messaging.api.exception.MessagingException: com.sap.aii.af.sdk.xi.srt.BubbleException: 

<SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"> 

<SOAP:Header> 

</SOAP:Header> 

<SOAP:Body> 

<SOAP:Fault xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>SOAP:Client</faultcode><faultstring>Error during conversion of XI message</faultstring><faultactor>http://sap.com/xi/XI/Message/30</faultactor><detail><SAP:Error SOAP:mustUnderstand="1" xmlns:SAP="http://sap.com/xi/XI/Message/30"><SAP:Category>XIProxy</SAP:Category>

<SAP:Code area="ABAP">INTERFACE_SIGNATURE_ERROR</SAP:Code><SAP:P1>ZII_SI_STOCKDATA_IMPORT</SAP:P1><SAP:P2>fud</SAP:P2><SAP:P3/><SAP:P4/><SAP:AdditionalText/>

<SAP:Stack>Information über die Methodenparameter fehlt für Schnittstelle ZII_SI_STOCKDATA_IMPORT (ABAP-Schnittstelle, Request-Message test, Request-Message-Namensraum ) </SAP:Stack></SAP:Error></detail></SOAP:Fault> 

</SOAP:Body> 

</SOAP:Envelope> 

[null "null"]

Content of the message looks like this:

I assume, that there is a problem with the datatype which is provided in the message. The proxy object is waiting for a "MT_Stockdata" but gets a "resultset" or something like that. But I am not quite sure how to accomplish to send a list of line items to the proxy in one message. Do I need a new data type like "DT_ItemList" which consists of "DT_Stockdata" 0..* ? Or do I need a Message Mapping to accomplish the task?

If someone has a feedback or a hint for me, I would highly appricate that.

Regards,
David

[alex_bundschuh]

Hi David,

you need to define a message mapping between your file structure and the message type of your proxy interface

Alex

[stradav]

Hi Alexander,

thanks for your advice. Finally, I got the scenario running. I wrote a blog post about it, maybe it will help one or the other.

https://blogs.sap.com/2023/03/10/how-to-import-data-from-text-file-via-pi-to-erp/