Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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