Skip to Content

SAP Business Connector JDBC Mapping

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 10, 2011 at 05:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2011 at 12:04 PM

    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á

    Add comment
    10|10000 characters needed characters exceeded