Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

abhaysingh
Contributor III

Incremental Load CLUSTER TABLE SAP


How to do Incremental load in CLUSTER TABLES in SAP

3 Replies

Re: Incremental Load CLUSTER TABLE SAP

It is tough with the cluster table but you can find the references in its reference tables.

suniljain
Honored Contributor

Re: Incremental Load CLUSTER TABLE SAP

You can load incremental data from SAP cluster table like BSEG by taking help of header table .

e.g

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.

Regards;

Sunil

yfe
Contributor III

Re: Incremental Load CLUSTER TABLE SAP

Hi

It is possible using "SUBSELECT" feature which is available in the SAP connector version 5.7 and forward.

for example:

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.

Thanks

Yaniv

Community Browser