Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
katetsan
Creator
Creator

Extract Data From SAP BSEG

Hi Experts,

I'm looking for a way to get incremental data from BSEG.

I've tried SQL Subselect, but it seems not work at Qlik Sense.

Is there any idea?

Thanks in Advance.

Kate

Labels (4)
1 Reply
Sarocame
Partner - Contributor
Partner - Contributor

Hi,

 

Try to do a inner join with the BKPF using the fields AEDAT and CPUDT, and get first the updated records, then createded records and finally concatenate with the qvd saved in the folder, you need to create a Key for the incremental loads and use de clausule Not Exists with the key.

regards,

Sandra