Problem mit incremental load for SAP table KEPH

geam1988 — Fri, 14 Sep 2018 10:29:11 GMT

Hello,

I wrote following script for incremental load of KEPH and getting script error.

LET vLoadDaysFrom = Date(Today()-6, 'YYYYMMDD');

KEKO:
Load *;
SQL SELECT KALNR CPUDT TOPKA   FROM KEKO
WHERE TOPKA EQ 'X' and CPUDT EQ '$(vLoadDaysFrom)' ;
STORE KEKO into $(QVDPath)\KEKO.QVD;

KEPH:
Concatenate
Load *;
SELECT MANDT KALNR BZOBJ KALKA KADKY TVERS BWVAR KKZMA PATNR KKZMM LOSFX KEART KKZST DIPA FROM KEPH
WHERE KKZST NE 'X' ;

Load * Resident KEKO WHERE CPUDT = '$(vLoadDaysFrom)' ;
DROP TABLE KEKO;

Concatenate (KEPH)
LOAD * FROM (qvd) ;
STORE KEPH into $(QVDPath)\KEPH - Kopie.QVD;
DROP TABLE KEPH;

topic Problem mit incremental load for SAP table KEPH in QlikView

Problem mit incremental load for SAP table KEPH