Qury to SAP for data fetching using SAP Connector

rahulhv1 — Mon, 07 Jul 2014 09:37:06 GMT

Hi Guys

We have SAP ECC 6 , (Oracle 11 i ) as data base. Below is the query which i have writting in Qlikview to fetch the data from SAP

SQL select

mkpv.name,mkpv.no, mseg.postdate from mkpv,mseg where mkpv.no = mseg.no and mseg.postdate > to_date('01-JAN-2014','DD-MON-YYYY') ;

Above query is not working with SAP , on the contrary, when i use this query with our oracle server (Other than SAP), it works fine. Can anybody pls. help me out for this.

Please note that , we have alreay all connection strings in place and working fine, also the field names/table names mentiond above are used juse an example.

topic Qury to SAP for data fetching using SAP Connector in QlikView

Qury to SAP for data fetching using SAP Connector