RFC_ERROR_SYSTEM_FAILURE : A dynamically specified column name is unknown.

[sahana_ps]

Hi All,

I am working on below scenario

SAP ECC(IDOC) ->PI 7.3 -> ARIBA(cXML)

I am making use of standard ARIBA mapping ( PaymentRemittance ).I am getting the below Error

"

Exception:[com.ariba.asc.sap.netweaver.xiadapter.mappings.MappingException: [XI RFC Lookups ERROR]: The Z_ARIBA_RFC_READ_TABLE call returned an Exception message : [NAME]:RFC_ERROR_SYSTEM_FAILURE [TEXT]:A dynamically specified column name is unknown. [REQUEST]:null] in class com.sap.xi.tf._MM_REMADV_PEXR2001_2_cXML_ method callRfcReadTable[[Ljava.lang.String;@241dcf99, [Ljava.lang.String;@21285855, [Ljava.lang.String;@5fbf4574, [Ljava.lang.String;@668f3c8, [Ljava.lang.String;@545cd2c1, [Ljava.lang.String;@1a10a82c, com.sap.aii.mappingtool.tf7.rt.ResultListImpl@3b90ee12, com.sap.aii.mappingtool.tf7.rt.Context@27fdfe4b] "

Any help is appreciated.

Thanks,
Sahana

[iaki_vila · Accepted solution]

Hi Shana,

The Z RFC Z_ARIBA_RFC_READ_TABLE is doing a SQL clausule dynamically, for example:

SELECT *

FROM table-column

WHERE ....

This table-column doesnt exist or  there is a value that not correspond to a correct value (a table in this example).

Check the st22 transaction in the endpoint, check the SQL clausule marked with the exception, finally change it with a correct value. Therefore, this is not a PI problem.

Regards,