topic Re: Query Sap / Qlikview in Brasil https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666073#M19082 <HTML><HEAD></HEAD><BODY><P>Deus que me livre, esse Sap é complexo demais!</P></BODY></HTML> Mon, 06 Oct 2014 15:46:04 GMT Anonymous 2014-10-06T15:46:04Z Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666069#M19078 <HTML><HEAD></HEAD><BODY><P>Pessoal bom Dia</P><P></P><P>Estou usando o Qlikview Connector para pegar informações do SAP , porem quando estou tentando rodar essa query no SAP mas está dando erro</P><P>Query:</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>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&nbsp; from MSEG</P> <P>where LGORT is not null and to_date(BUDAT_MKPF, 'YYYYMM') = '201409';</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P></P><P></P><P>Erro:</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>/QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Comma without preceding colon (after OPEN ?).)</P> <P>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&nbsp; from MSEG</P> <P>Where&nbsp;&nbsp;&nbsp; TO_CHAR(BUDAT_MKPF,'DD-MM-YYYY') =&nbsp; '20-09-2014'</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P></P><P>Alem consegue me ajudar por favor ?</P></BODY></HTML> Mon, 06 Oct 2014 13:50:10 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666069#M19078 2014-10-06T13:50:10Z Re: Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666070#M19079 <HTML><HEAD></HEAD><BODY><P>Sou bem leigo no quesito SAP, mas me parece que esta dando no formato da data, não?</P><P></P><P>O formato do SAP é <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">YYYYMMDD.</SPAN></P><P></P><P>Isso pode ser também alguma configuração no driver de conexão do SAP</P></BODY></HTML> Mon, 06 Oct 2014 14:10:25 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666070#M19079 nicolett_yuri 2014-10-06T14:10:25Z Re: Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666071#M19080 <HTML><HEAD></HEAD><BODY><P>Mas a ideia é que o TO_CHAR transforme o campo em data e permita que eu pegue no formato que eu desejo.</P><P></P><P>to falando com DBA aqui para ver se ele sabe o que é porque eu ja tentei de toda as formas e nao rolo ,&nbsp; eu quero fazer uma carga Mensal pq se tiver que fazer laço do mês a mês vai ficar lento a carga .</P><P>Se fizer realmente o campo = 20140902 (02/09/2014) trás dados</P></BODY></HTML> Mon, 06 Oct 2014 14:18:44 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666071#M19080 2014-10-06T14:18:44Z Re: Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666072#M19081 <HTML><HEAD></HEAD><BODY><P>Sem o Where funciona?</P><P>Pode ser alguma configuração no conector</P></BODY></HTML> Mon, 06 Oct 2014 14:29:14 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666072#M19081 nicolett_yuri 2014-10-06T14:29:14Z Re: Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666073#M19082 <HTML><HEAD></HEAD><BODY><P>Deus que me livre, esse Sap é complexo demais!</P></BODY></HTML> Mon, 06 Oct 2014 15:46:04 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666073#M19082 Anonymous 2014-10-06T15:46:04Z Re: Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666074#M19083 <HTML><HEAD></HEAD><BODY><P>resolvi<BR />pelo for mesmo de dia a dia e mês</P></BODY></HTML> Mon, 06 Oct 2014 16:19:44 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666074#M19083 2014-10-06T16:19:44Z Re: Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666075#M19084 <HTML><HEAD></HEAD><BODY><P>Posta sua solução para vermos</P></BODY></HTML> Mon, 06 Oct 2014 16:59:57 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666075#M19084 nicolett_yuri 2014-10-06T16:59:57Z Re: Query Sap / Qlikview https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666076#M19085 <HTML><HEAD></HEAD><BODY><P>Já conseguiu a resposta? Se sim, escolha uma e marque como "Correta" para fechar o tópico e nos ajudar a manter a comunidade organizada</P><P>Have fun, be Qlik</P></BODY></HTML> Sat, 18 Jun 2016 15:13:32 GMT https://community.qlik.com/t5/Brasil/Query-Sap-Qlikview/m-p/666076#M19085 Clever_Anjos 2016-06-18T15:13:32Z