5 Replies Latest reply: Jun 1, 2015 11:30 AM by German Avanzato RSS

    SAP Extractor Connector: Where clause no filtering

    Ferran Puchol

      Hi everyone,

       

      i'm trying to add a where clause into sap extraction but it is not working. I'm always downloading all the table without filtering by my where clause.

       

      [2LIS_13_VDHDR]:

      LOAD

      [ANZFK] as [ANZFK.No.of billing docs],

      [BUKRS] as [BUKRS.Company Code],

      [BZIRK] as [BZIRK.Sales district],

      [ERDAT] as [ERDAT.Date on Which Record Was Created],

      [FKART] as [FKART.Billing Type],

      [FKDAT] as [FKDAT.Billing date for billing index and printout],

      // [FKSTO] as [FKSTO.Billing document is cancelled],

      [FKTYP] as [FKTYP.Billing category],

      [HWAER] as [HWAER.Local Currency],

      [KDGRP] as [KDGRP.Customer group],

      // [KNUMV] as [KNUMV.Number of the document condition],

      [KUNAG] as [KUNAG.Sold-to party],

      [KUNRG] as [KUNRG.Payer],

      [KURRF] as [KURRF.Exchange rate for FI postings],

      [KURST] as [KURST.Exchange Rate Type],

      [PERIV] as [PERIV.Fiscal Year Variant],

      [PVRTNR] as [PVRTNR.Sales employee],

      [ROCANCEL] as [ROCANCEL.Indicator: Cancel Data Record],

      [STWAE] as [STWAE.Statistics currency],

      [VBELN] as [VBELN.Sales and Distribution Document Number],

      [VBTYP] as [VBTYP.SD document category],

      [VKORG] as [VKORG.Sales Organization],

      [VTWEG] as [VTWEG.Distribution Channel],

      [WAERK] as [WAERK.SD Document Currency];

      SQL EXTRACTOR 2LIS_13_VDHDR

      TFRMETHOD T   // tRFC transfer method

      UPDMODE F   // full extractor

      //UPDMODE C   // initial extraction, to be followed by delta extractions

      //UPDMODE D   // delta extraction

      //INITRNR <NR>  // Resend extraction

      //IDOC <NR>  // Resend single IDoc

      EXTRLANGUAGE E

      LOGSYS QTQVCEXTR1

      WHERE

      KUNRG I EQ 'D128125';

       

      I tried it without single quotes, but it doesn't work either.

       

      Can someone help me please?

       

      THX!

       

      Ferran

        • Re: SAP Extractor Connector: Where clause no filtering
          Clive Rouse

          Hi, Just a thought, only specific fields are selectable in BW datasources, it depends on the configuration for that datasource.  Is KUNRG selectable when you use the SAP transaction RSA3?  I'm guessing that only selectable fields can be used in the where clause.  In our system only BUKRS, Company Code and VKORG, Sales Organisation are selectable.

            • Re: SAP Extractor Connector: Where clause no filtering
              Ferran Puchol

              Thanks for your answer.

               

              KUNRG is no selectable at RSA3. I tried what you said:

               

              [2LIS_13_VDHDR]:

              LOAD

              [ANZFK] as [ANZFK.No.of billing docs],

              [BUKRS] as [BUKRS.Company Code],

              [BZIRK] as [BZIRK.Sales district],

              [ERDAT] as [ERDAT.Date on Which Record Was Created],

              [FKART] as [FKART.Billing Type],

              [FKDAT] as [FKDAT.Billing date for billing index and printout],

              // [FKSTO] as [FKSTO.Billing document is cancelled],

              [FKTYP] as [FKTYP.Billing category],

              [HWAER] as [HWAER.Local Currency],

              [KDGRP] as [KDGRP.Customer group],

              // [KNUMV] as [KNUMV.Number of the document condition],

              [KUNAG] as [KUNAG.Sold-to party],

              [KUNRG] as [KUNRG.Payer],

              [KURRF] as [KURRF.Exchange rate for FI postings],

              [KURST] as [KURST.Exchange Rate Type],

              [PERIV] as [PERIV.Fiscal Year Variant],

              [PVRTNR] as [PVRTNR.Sales employee],

              [ROCANCEL] as [ROCANCEL.Indicator: Cancel Data Record],

              [STWAE] as [STWAE.Statistics currency],

              [VBELN] as [VBELN.Sales and Distribution Document Number],

              [VBTYP] as [VBTYP.SD document category],

              [VKORG] as [VKORG.Sales Organization],

              [VTWEG] as [VTWEG.Distribution Channel],

              [WAERK] as [WAERK.SD Document Currency];

              SQL EXTRACTOR 2LIS_13_VDHDR

              TFRMETHOD T   // tRFC transfer method

              UPDMODE F   // full extractor

              //UPDMODE C   // initial extraction, to be followed by delta extractions

              //UPDMODE D   // delta extraction

              //INITRNR <NR>  // Resend extraction

              //IDOC <NR>  // Resend single IDoc

              EXTRLANGUAGE E

              LOGSYS QTQVCEXTR1

              WHERE VKORG I EQ 1002;

               

              It should had returned 0 values due to VKORG is 1000 at all records, but it returned all the data without filtering.

               

              Any idea what's happening?

               

              Thanks!

            • Re: SAP Extractor Connector: Where clause no filtering
              Ivan Likhachev

              Hi Ferran!

               

              I have the same problem. Did you fine a solution?

              • Re: SAP Extractor Connector: Where clause no filtering
                Tomas Sommergyll

                Hi,

                 

                Please upgrade to the latest version of the Qlik Extractor Connector for SAP.

                 

                The issue with WHERE clause (e.g. WHERE VKORG I LT "1001") is fixed in version 6.00 IR.

                 

                Thanks,

                Tomas

                • Re: SAP Extractor Connector: Where clause no filtering
                  German Avanzato

                  Hi,

                   

                  You are using the 2LIS_13_VDHDR in full mode , you already filled the setup tables??