WSO2 SAP Adapter : Unable to send tables data in BAPI RFC call

Question

I am trying to make a SAP BAPI RFC call using WSO2 6.2 EI (I also tried WSO2 ESB 5.0.0 with same results). The request xml contains data for input structures and some table data. The input structures data is sent successfully and received at the SAP end. The tables data is not being sent by WSO2 (as observed in the trace files for the SAP call). I had a look at the source code and it seems the issue has already been reported and fixed (https://wso2.org/jira/browse/ESBJAVA-3011) but surprisingly even the latest version of WSO2 still has the old code which still has the issue (unless I am looking in the wrong place) - the org.wso2.carbon.transports.sap_1.0.0.jar (present in the plugins directory).

Below is a sample request:

<body>
<bapirfc xmlns="" name="ZTEMP_CREATE">
<import>
<structure name="LS_ORDER_HEADER_IN">
<field name="DOC_TYPE">ZZZ</field>
<field name="SALES_ORG">1111</field>
</structure>
</import>
<tables> 
<table name="LT_PARTNERS">
<row id="0">
<field name="PARTN_ROLE">DG</field>
<field name="PARTN_NUMB">0000000075</field>
</row>
</table>
</tables>
</bapirfc>
</body>

The import structure data for the structure "LS_ORDER_HEADER_IN" is sent and received successfully. But the tables data "LT_PARTNERS" is being sent as blank from WSO2. Is there a patch or upgrade available for the SAP adaptor for fixing this issue and if so, how can i update my wso2 ei installation to use it?

score 0 · Answer 1 · answered Jun 05 '18 at 12:02

I'm using ESB 4.8.1 with org.wso2.carbon.transports.sap_1.0.0.jar to make BAPI RFC calls without any problems.

Can you try the following test proxy to see if in general it works?

    <?xml version="1.0" encoding="UTF-8"?>
<proxy xmlns="http://ws.apache.org/ns/synapse"
       name="SAPProxy"
       transports="https,http"
       statistics="disable"
       trace="disable"
       startOnLoad="true">
   <target>
      <inSequence>
         <payloadFactory media-type="xml" description="BAPIPayload">
            <format>
               <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
                  <soap:Body>
                     <bapirfc xmlns="" name="Z_CONVERT_IBAN_2_BANK_ACCOUNT">
                        <import>
                           <field name="I_IBAN">123456789</field>
                        </import>
                     </bapirfc>
                  </soap:Body>
               </soap:Envelope>
            </format>
            <args/>
         </payloadFactory>
         <send>
            <endpoint name="sap-endpoint">
               <address uri="bapi:/yourconf"/>
            </endpoint>
         </send>
         <log level="full">
            <property name="step" value="--- AFTER SEND TO SAP 2 --"/>
         </log>
      </inSequence>
      <outSequence>
         <log level="full">
            <property name="step" value="--- RESULT FROM SAP --"/>
         </log>
         <send/>
      </outSequence>
      <faultSequence>
         <log level="full">
            <property name="step" value="--- FAULT --"/>
         </log>
         <drop/>
      </faultSequence>
   </target>
   <description/>
</proxy>

Thanks Martin for your response! As I mentioned, in general, I am able to make BAPI RFC calls. I am only facing a problem when trying to send 'Tables' data in the request. When i send 'Tables' data, it is being set as blank in the request. I am also sending 'import' data which has structures and fields and that goes through to SAP as expected. So, the problem is only when a BAPI RFC call expects table data. — Puneet Dev, Jun 05 '18 at 12:53
Sorry, now I understand your problem. Unfortunately I haven't tried tables so far. Possible that it's the issue you refered in your post, looks like you need to debug the java source. Maybe you get another idea when you set the log level of SAPTransportSender to debug. — Martin Hald, Jun 05 '18 at 13:52

Eshwari Lakshmanan · Answer 2 · 2022-05-11T15:16:52.737

0

Giving <tables> inside the <import> tag will work.

<body>
<bapirfc xmlns="" name="ZTEMP_CREATE">
<import>
<tables> 
<table name="LT_PARTNERS">
<row id="0">
<field name="PARTN_ROLE">DG</field>
<field name="PARTN_NUMB">0000000075</field>
</row>
</table>
</tables>
</import>
</bapirfc>
</body>

edited May 11 '22 at 15:16

answered May 11 '22 at 15:10

Eshwari Lakshmanan

1
2

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community May 18 '22 at 07:08

WSO2 SAP Adapter : Unable to send tables data in BAPI RFC call

2 Answers2