Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

riavanlinn
New Contributor

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

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>


Tags (1)
Community Browser