Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
geam1988
Creator
Creator

Problem mit incremental load for SAP table KEPH

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;

0 Replies