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)