0 Replies Latest reply: Apr 21, 2016 6:18 AM by Van Linn Ria RSS

    Hi, I am working on the subselect on BSEG and wonder if the following is possible.

    Van Linn Ria

      SQL SUBSELECT MANDT BUKRS BELNR GJAHR BUZEI BSCHL SHKZG MWSKZ DMBTR WRBTR PSWSL TXGRP VALUT ZUONR KOKRS HKONT MATNR WERKS MENGE MEINS PRCTR PAOBJNR PASUBNR KIDNO KSTAR VBELN VBEL2 POSN2

           FROM BSEG WHERE ( BSCHL= '40' OR BSCHL= '50' ) 

                           AND ( BUKRS BELNR GJAHR IN  ( SELECT BUKRS BELNR GJAHR FROM BKPF WHERE  (BUKRS = '5100' or BUKRS = '2000') AND (CPUDT >= '20160420' ) ) ) ;


      Without the   "( BSCHL= '40' OR BSCHL= '50' ) AND " part this SUBSELECT works fine.


      According to "Qlik Connector for SAP - Tips and Tricks Version 1.2.docx"  on the subject SUBSELECT this where clause  should be possible.


      But I am getting the error message  "Field not found -<MANDT>