topic INCREMENTAL SAP in QlikView https://community.qlik.com/t5/QlikView/INCREMENTAL-SAP/m-p/678681#M1084600 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Mon, 30 Jun 2014 08:44:05 GMT abhaysingh 2014-06-30T08:44:05Z INCREMENTAL SAP https://community.qlik.com/t5/QlikView/INCREMENTAL-SAP/m-p/678681#M1084600 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Mon, 30 Jun 2014 08:44:05 GMT https://community.qlik.com/t5/QlikView/INCREMENTAL-SAP/m-p/678681#M1084600 abhaysingh 2014-06-30T08:44:05Z Re: INCREMENTAL SAP https://community.qlik.com/t5/QlikView/INCREMENTAL-SAP/m-p/678682#M1084601 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In KONV table you have KNUMV and KPOSN and which is nothing but VBAK-KNUMV and VBAK-POSNR</P><P></P><P>so you can find Changed on date(VBAK-AEDAT) in VBAK can changed records can be filted out .</P><P></P><P>load KNUMV POSNR AEDAT&nbsp; from VBAK .</P><P></P><P>left join </P><P></P><P>Load * from KONV where for matching fieldes of&nbsp; KNUMV .</P></BODY></HTML> Mon, 30 Jun 2014 10:03:17 GMT https://community.qlik.com/t5/QlikView/INCREMENTAL-SAP/m-p/678682#M1084601 Anonymous 2014-06-30T10:03:17Z Re: INCREMENTAL SAP https://community.qlik.com/t5/QlikView/INCREMENTAL-SAP/m-p/678683#M1084602 <HTML><HEAD></HEAD><BODY><P>thanks for your feedback , but I need more clarity in last line</P><P></P><P>i.e. load * from KONV where for matching fields of KNUMV</P></BODY></HTML> Mon, 30 Jun 2014 11:06:30 GMT https://community.qlik.com/t5/QlikView/INCREMENTAL-SAP/m-p/678683#M1084602 abhaysingh 2014-06-30T11:06:30Z