SAP Business Connector JDBC Mapping

[Roman71]

Dear all,

I am using SAP BC to connect and query a MS SQL Database. I have a SAP Function Module called in SAP ABAP with the query in importing parameters and would expect the result in the given tables parameter.

Mapping the importing parameter to the query was easy but the query´s result is from type Object. Can please anybody explain to me how I can map the result to the Functions Module tables parameter.

Best regards for help and tips.

Roman

[Former Member · Accepted solution]

Are you using pub.db.query ? This returns according to documentation:

results com.wm.util.Table

An instance of com.wm.util.Table that contains the results of the query

So you should have no problem to pass that result to a table parameter.

If you have problems with the usage of the SQL services, you can let BC generate an example service (use the function in the browser UI).

CSY

[iprieto]

Hi,

Maybe you should to create a Java Service where you can casting the Object struture to a table structure.

Check out if there are services that you can use to do it in the folder: WmPublic-> pub -> table or WMDB-> pub -> db.

Good luck

Ivá