Qlik Community

QlikView Connectors

Highlighted
Kevincool
Contributor III

Problem while extracting tables using SAP Connector

Error.PNGHi,

     I get the following above error while extracting large tables from SAP ECC 6 using Qlikview SAP Connector. I am unable to extract AUFK, BSEG etc..I am using Incremental LOAD based on the dates in those tables to extract the data.Any help please?

7 Replies
mmichalke
New Contributor III

Re: Problem while extracting tables using SAP Connector

hey,

could you please provide the full error message ?

Thanks !

Kevincool
Contributor III

Re: Problem while extracting tables using SAP Connector

It's basically the BSEG table which I want to extract and my SQL syantax is

SQL Select field1  fields2.... from BSEG where BELNR IN (Select BELNR FROM BKPF WHERE BLDAT>= DAte1 AND BLDAT<=Date2))

Kevincool
Contributor III

Re: Problem while extracting tables using SAP Connector

It's basically the BSEG table which I want to extract and my SQL syantax is

SQL Select field1  fields2.... from BSEG where BELNR IN (Select BELNR FROM BKPF WHERE BLDAT>= DAte1 AND BLDAT<=Date2))

mmichalke
New Contributor III

Re: Problem while extracting tables using SAP Connector

Maybe wrong Date format ?

Please make a Screenshot again from the script error. And scroll as far as possible to the right. Maybe there is
some more information available.

Kevincool
Contributor III

Re: Problem while extracting tables using SAP Connector

SELECT ABPER ABSBT AGZEI ALTKT ANBWA ANFAE ANFBJ ANFBN ANFBU ANLN1 ANLN2 APLZL AUFNR AUFPL AUGBL AUGCP AUGDT AUGGJ BDIF2 BDIF3 BDIFF BELNR BEWAR BLNBT BLNKZ BLNPZ BONFB BPMNG BPRME BSCHL BTYPE BUALT BUKRS BUPLA BUSTW BUZEI BUZID BVTYP BWKEY BWTAR BZDAT CCBTC CESSION_KZ DABRZ DEPOT DIEKZ DISBJ DISBN DISBZ DMB21 DMB22 DMB23 DMB31 DMB32 DMB33 DMBE2 DMBE3 DMBT1 DMBT2 DMBT3 DMBTR DOCLN DTWS1 DTWS2 DTWS3 DTWS4 EBELN EBELP EGBLD EGLLD EGRUP ELIKZ EMPFB ERFME ERFMG ESRNR ESRPZ ESRRE ETEN2 ETYPE FDGRP FDLEV FDTAG FDWBT FILKD FIPOS FISTL FKBER FKBER_LONG FKONT FWBAS FWZUZ GBETR GEBER GITYP GJAHR GLUPM GMVKZ GRANT_NBR GRICD GRIRG GSBER GVTYP HBKID HKONT HKTID HRKFT HWBAS HWMET HWZUZ HZUON IDXSP IMKEY INTRENO KBLNR KBLPOS KIDNO KKBER KLIBT KOART KOKRS KONTL KONTT KOSTL KSTAR KSTRG KTOSL KUNNR KURSR KZBTR LANDL LIFNR LINFV LNRAN LOKKT LSTAR LZBKZ MABER MADAT MANDT MANSP MANST MATNR MEASURE MEINS MENGE MSCHL MWART MWSK1 MWSK2 MWSK3 MWSKZ MWST2 MWST3 MWSTS NAVFW NAVH2 NAVH3 NAVHW NEBTR NPLNR NPREI OBZEI PAOBJNR PARGB PASUBNR PEINH PENDAYS PENFC PENLC1 PENLC2 PENLC3 PENRC PERNR PFKBER POPTS POSN2 PPA_EX_IND PPDIF2 PPDIF3 PPDIFF PPRCT PRCTR PRODPER PROJK PROJN PRZNR PSALT PSEGMENT PSWBT PSWSL PYAMT PYCUR QBSHB QSFBT QSSHB QSSKZ QSZNR RDIF2 RDIF3 RDIFF REBZG REBZJ REBZT REBZZ RECID REWRT REWWR RFZEI RPACQ RSTGR RYACQ SAKNR SAMNR SCTAX SECCO SEGMENT SGTXT SHKZG SHZUZ SKFBT SKNT2 SKNT3 SKNTO SPGRC SPGRG SPGRM SPGRP SPGRQ SPGRS SPGRT SPGRV SRTYPE STBUK STCEG STEKZ STTAX TAXPS TBTKZ TXBFW TXBH2 TXBH3 TXBHW TXDAT TXGRP TXJCD UMSKS UMSKZ UZAWE VALUT VBEL2 VBELN VBEWA VBUND VERTN VERTT VNAME VORGN VPRSV VPTNR VRSDT VRSKZ WERKS WMWST WRBT1 WRBT2 WRBT3 WRBTR WSKTO WVERW XANET XAUTO XBILK XCPDD XEGDR XFAKT XHKOM XHRES XINVE XKRES XNCOP XNEGP XOPVW XPANZ XPYPR XRAGL XREF1 XREF2 XREF3 XSAUF XSERG XSKRL XSKST XSPRO XUMAN XUMSW XZAHL ZBD1P ZBD1T ZBD2P ZBD2T ZBD3T ZBFIX ZEKKN ZFBDT ZINKZ ZLSCH ZLSPR ZOLLD ZOLLT ZTERM ZUMSK ZUONR FROM BSEG WHERE BELNR IN (SELECT BELNR FROM BKPF WHERE BLDAT >= '20130401' AND BLDAT <= '20130402')

mmichalke
New Contributor III

Re: Problem while extracting tables using SAP Connector

Here an example from another SQL statement that works:

SQL SELECT
<fields>

FROM <table>

WHERE <Field>
IN (

SELECT <Field>

FROM <table> WHERE AEDAT >= '$(vTimeStamp_SAP)');

The variable vTimeStamp_SAP = 20120221

Hope this helps !

Kevincool
Contributor III

Re: Problem while extracting tables using SAP Connector

Mine and yours are the same script. I am able to extract many tables with my script but only has problem with BSEG...