6 Replies Latest reply: Jul 10, 2014 2:09 AM by Yaniv Feldman RSS

    SQL Query not working in SAP for extractig data from tables (Combination of tables)

    rahul varma

      Hi Guys

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

      SQL SELECT

      MBLNR,  WERKS, MATNR, CHARG,  BWART, MENGE, MJAHR,  MKPF.BUDAT  FROM MSEG  , MKPF  where MSEG.MBLNR = MKPF.MBLNR and WERKS ='A100' and  MATNR = 'RM010000'  AND MKPF.BUDAT >= 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. 

      Below is the error which i am getting.

      /QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Comma without preceding colon (after OPEN ?).)