7 Replies Latest reply: Jun 18, 2016 11:13 AM by Clever Anjos RSS

    Query Sap / Qlikview

      Pessoal bom Dia

       

      Estou usando o Qlikview Connector para pegar informações do SAP , porem quando estou tentando rodar essa query no SAP mas está dando erro

      Query:

      SQL Select MEINS MANDT PARENT_ID MATNR BUKRS SHKZG AUFNR AUFPS LIFNR LGORT KUNNR WAERS WERKS GRUND EBELN AKTNR BELNR GSBER KOSTL KOKRS PS_PSP_PNR CHARG BWTAR PRCTR SOBKZ PAOBJNR KZVBR CUOBJ_CH KZBWS ABLAD GJAHR BWART ANLN1 ANLN2 MJAHR ZEILE KZBEW MENGE MBLNR WEMPF UMWRK UMLGO BUZEI PARGB MWSKZ DMBTR SGTXT PROJN XSKST XSAUF XSPRO XSERG XAUTO ERFMG ERFME BPMNG BPRME EBELP ZEKKN ELIKZ VPRSV BUSTW BUALT VPTNR TXJCD IMKEY DABRZ FIPOS KSTRG NPLNR AUFPL APLZL FISTL GEBER FKBER EQUNR LGNUM SAKTO RSNUM KDAUF KDPOS BEMOT LINE_ID ZUSCH ZUSTD VFDAT UMMAT UMCHA LGTYP EMATN WEUNB UMSOK EMLIF GRANT_NBR LGPLA RSPOS KZZUG RSART KZEAR BSTME BSTMG LFBNR LFPOS XWOFF INSMK TANUM PPRCTR LLIEF OICONDCOD LSTAR PRZNR MAT_KDAUF MAT_KDPOS MAT_PSPNR KDEIN SMBLN SMBLP SJAHR PARBU BERKZ VKWRT XRUEM BWLVS LBKUM SALK3 XOBEW PLPLA MATBF TBNUM XRUEJ KZSTR XWSBR BUSTM WERTU MENGU EVERS EVERE LSMNG LSMEH BELUM SHKUM DMBUM BUZUM BESTQ TBPRI TBPOS UBNUM HSDAT EXVKW VKWRA CONDI UMBAR EXBWR LINE_DEPTH BNBTR LFBJA PBAMG UMZST UMZUS PALAN XBLVS VSCHN NSCHN DYPLA WEANZ UMMAB DABRBZ XBEAU QINSPST URZEI J_1BEXBASE J_1AGIRUPD VKMWS ZUSTD_T156M SPE_GTS_STOCK_TY VGART_MKPF BUDAT_MKPF CPUDT_MKPF CPUTM_MKPF USNAM_MKPF XBLNR_MKPF TCODE2_MKPF /BEV2/ED_KZ_VER /BEV2/ED_USER /BEV2/ED_AEDAT /BEV2/ED_AETIM OINAVNW  from MSEG

      where LGORT is not null and to_date(BUDAT_MKPF, 'YYYYMM') = '201409';

       

       

       

      Erro:

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

      SQL Select MEINS MANDT PARENT_ID MATNR BUKRS SHKZG AUFNR AUFPS LIFNR LGORT KUNNR WAERS WERKS GRUND EBELN AKTNR BELNR GSBER KOSTL KOKRS PS_PSP_PNR CHARG BWTAR PRCTR SOBKZ PAOBJNR KZVBR CUOBJ_CH KZBWS ABLAD GJAHR BWART ANLN1 ANLN2 MJAHR ZEILE KZBEW MENGE MBLNR WEMPF UMWRK UMLGO BUZEI PARGB MWSKZ DMBTR SGTXT PROJN XSKST XSAUF XSPRO XSERG XAUTO ERFMG ERFME BPMNG BPRME EBELP ZEKKN ELIKZ VPRSV BUSTW BUALT VPTNR TXJCD IMKEY DABRZ FIPOS KSTRG NPLNR AUFPL APLZL FISTL GEBER FKBER EQUNR LGNUM SAKTO RSNUM KDAUF KDPOS BEMOT LINE_ID ZUSCH ZUSTD VFDAT UMMAT UMCHA LGTYP EMATN WEUNB UMSOK EMLIF GRANT_NBR LGPLA RSPOS KZZUG RSART KZEAR BSTME BSTMG LFBNR LFPOS XWOFF INSMK TANUM PPRCTR LLIEF OICONDCOD LSTAR PRZNR MAT_KDAUF MAT_KDPOS MAT_PSPNR KDEIN SMBLN SMBLP SJAHR PARBU BERKZ VKWRT XRUEM BWLVS LBKUM SALK3 XOBEW PLPLA MATBF TBNUM XRUEJ KZSTR XWSBR BUSTM WERTU MENGU EVERS EVERE LSMNG LSMEH BELUM SHKUM DMBUM BUZUM BESTQ TBPRI TBPOS UBNUM HSDAT EXVKW VKWRA CONDI UMBAR EXBWR LINE_DEPTH BNBTR LFBJA PBAMG UMZST UMZUS PALAN XBLVS VSCHN NSCHN DYPLA WEANZ UMMAB DABRBZ XBEAU QINSPST URZEI J_1BEXBASE J_1AGIRUPD VKMWS ZUSTD_T156M SPE_GTS_STOCK_TY VGART_MKPF BUDAT_MKPF CPUDT_MKPF CPUTM_MKPF USNAM_MKPF XBLNR_MKPF TCODE2_MKPF /BEV2/ED_KZ_VER /BEV2/ED_USER /BEV2/ED_AEDAT /BEV2/ED_AETIM OINAVNW  from MSEG

      Where    TO_CHAR(BUDAT_MKPF,'DD-MM-YYYY') =  '20-09-2014'

       

       

      Alem consegue me ajudar por favor ?