I am working on building a load script for KONV that loads records based on changes occurring at the PO line item level (EKPO). Below is the subselect query that I am trying to use:
SQL SUBSELECT KSCHL KOPOS ...
FROM KONV
WHERE KNUMV IN (
SELECT h~KNUMV AS KNUMV
FROM EKKO AS h
INNER JOIN EKPO AS l ON h~EBELN = l~EBELN
WHERE l~AEDAT BETWEEN '20080601' AND '20160630' AND l~LOEKZ <> 'L'
);
However, it appears that I can't perform joins within a subselect. I also tried performing the join first and loading it into a table in memory and then using that table within the subselect as follows:
KNUMV_TEMP:
SQL SELECT h~KNUMV AS KNUMV
FROM EKKO AS h
INNER JOIN EKPO AS l ON h~EBELN = l~EBELN
WHERE l~AEDAT BETWEEN '20080601' AND '20160630' AND l~LOEKZ <> 'L';
SQL SUBSELECT KSCHL KOPOS ...
FROM KONV
WHERE KNUMV IN (
SELECT KNUMV
RESIDENT KNUMV_TEMP
);
This also doesn't seem to work. Is something like this even possible in QlikView? I appreciate any feedback/thoughts/help that anybody out there might have.
