Area for people to learn more about current Qlik related job postings.
How to do Incremental load in CLUSTER TABLES in SAP
It is tough with the cluster table but you can find the references in its reference tables.
You can load incremental data from SAP cluster table like BSEG by taking help of header table .
To extract data from BSEG we have to fetch latest bill number from BKPF and then you can fetch data for that bills from BSEG.
It is possible using "SUBSELECT" feature which is available in the SAP connector version 5.7 and forward.
SQL SUBSELECT BUKRS BELNR GJAHR BUZEI BUZID AUGDT FROM BSEG WHERE BUKRS BELNR GJAHR IN ( SELECT BUKRS BELNR GJAHR FROM BKPF WHERE BLDAT GE '20070101' );
You can find guidance in the QlikView SAP Connector reference manual.