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>
