Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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