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.
