SAP HCI: Dynamic Retrival of a value in Select Query

[former_member556472]

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

[former_member556472]

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#'

[former_member556472]

This is resolved. Thanks..

[former_member571250]

How did you resolve this? Please provide solution.