Execute query in mapping and map the result to next field in target

[Former Member]

Hi Guys,

Doing file to jdbc Scenario.

source:

root:
  row
       sf1
      
target:

root:
    row
       target1
       target2

I have requirement as:

I have to map sf1 to target1 ( I do not have any problema in it)

target2 field must populate basing upon query which results. this should run with the input parameter sf1. If the query results then update target2 else update with MESSAGE_DONE.

[former_member184681 · Accepted solution]

Hi Swarna,

What kind of query do you mean? In certain cases, it might be worthwhile to consider ABAP mapping, which seems to be the easiest way to do some sequential steps, especially for such a simple message structures.

Hope this helps,

Grzegorz

[Former Member · Accepted solution]

simple SELECT query that I should execute.

Swarnalu.

[former_member184681]

But where do you need to select the data from? If it is from XI database - use ABAP mapping class. If from ECC/other SAP system's database - use RFC lookup in graphical mapping. If it is any other database, you need to use JDBC lookup.

[prateek]

>>populate basing upon query which results

What query and what result? If you mean some JDBC query, you need to use JDBC lookup.

Regards,

Prateek Raj Srivastava