Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

INCREMENTAL SAP

I want to do incremental on KONV table but the problem is I don't have the date in KONV table, so how can I do incremental load in that particular table

2 Replies
Anonymous
Not applicable

Hi,

In KONV table you have KNUMV and KPOSN and which is nothing but VBAK-KNUMV and VBAK-POSNR

so you can find Changed on date(VBAK-AEDAT) in VBAK can changed records can be filted out .

load KNUMV POSNR AEDAT  from VBAK .

left join

Load * from KONV where for matching fieldes of  KNUMV .

abhaysingh
Specialist II
Specialist II
Author

thanks for your feedback , but I need more clarity in last line

i.e. load * from KONV where for matching fields of KNUMV