Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Soap2JDBC : Problem while designing data structure for Query

Hi ALL,

I am doing webservices(SOAP) to JDBC(syn) scenario without using BPM.We are sending the request from portal and getting the response from database.

I have lot of Queries.I am going to design based on the database Query.Please find the following Query.

SELECT ALL DBTEST.REQMASTBL.RQTR,

DBTEST.REQMASTBL.RQN_NO,

DBTEST.REQMASTBL.RQN_DATE,

DBTEST.REQMASTBL.APPROVE_BY,

TO_NUMBER(DBTEST.REQMASTBL.RQN_AMT), DBTEST.REQMASTBL.RQN_TYPE,

DBTEST.REQMASTBL.ROS_DATE,

DBTEST.REQMASTBL.RQN_STATUS

FROM DBTEST.REQMASTBL

WHERE DBTEST.REQMASTBL.RQN_STATUS='AP' AND

DBTEST.REQMASTBL.APPROVE_BY LIKE UPPER('GM%') AND DBTEST.REQMASTBL.RQTR='GM211' AND DBTEST.REQMASTBL.RQN_DATE BETWEEN (:frmDate) AND (:toDate) ORDER BY DBTEST.REQMASTBL.RQN_NO

All most all the queries having the same functionality.Could anyone please guide me how to design and how to map the source and the target fields using the Boolean(and,or.like,between) functions.

Now the problem is How to design the data stucture in Integration Repository using this query and how to extract these(and,or.like,between) functions.

urgent response is highly appreciated

rgds,

Veena

Not what you were looking for? View more on this topic or Ask a question