Skip to Content
0
Jan 19, 2023 at 01:21 PM

JDBC Sender Channel Select Query

123 Views

Hello All,

I am working on a req SAP <-> PO<->DB

Here the SAP ECC system send an Idoc with MATNR number and based on this MATNR number I will have to fetch data from the DB.

I have created two Asynch Scenarios here

1. Idoc to JDBC

2. JDBC to Idoc

In the second sceanrio in JDBC Sender Channel if I give query as - Select * from<TAbleName> Where MAterial_Number = '1234' it works fine. (Material_Number is the field from DB)

However, hardcoding the MATNR wouldnot work here. Can someone Please help me with the SELECT Query(DB's MAterial Number should be equal to MATNR in Idoc)