Skip to Content

SAP HCI: Dynamic Retrival of a value in Select Query

Hi Folks,

We are using Advantco SFDC adapter for connecting to SFDC via SAP HCI. While configuring the query lookup in the receiver channel we have to dynamically populate the customer number from the S4 source idoc.

We are using the below process but this is not working.

How can this be achieved either content modifier or write variables and how they can be used in the query string?

Please suggest.

Thanks in Advance!

Regards,

Anil

query.jpg (45.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 11, 2018 at 10:26 AM

    This is resolved. Thanks..

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 09:21 AM

    Hello Amrita,

    Please enable the variable substitution in Advance tab and provide the name and the value as below.

    var_id = message:kunnr_id

    Now in the Query look up, use # instead of %.

    select id from Account where SAP_ID__c = '#var1#'

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07 at 07:57 AM

    How did you resolve this? Please provide solution.

    Add comment
    10|10000 characters needed characters exceeded