How to create delta logic for ckis table

[KunalBansal]

Hello @Keerthana1,
As I'm not fully sure of your query, have you tried using CKIS cost est. table fields - ERDAT (created), AEDAT (changed), and DELFLAG (deletion flag) in your logic to extract data and load it into the target system incrementally?

• slect * from CKIS where ERDAT > lasttimestamp or AEDAT > lasttimestamp;
• select * from CKIS where DELFLAG = 'X' and AEDAT > lasttimestamp;

I hope this answers your query.

Thanks and Regards,
Kunal Bansal
SAP CX Solution Architect

[Keerthana1]

Hi @Kunal Bansal, thanks for the solution...As I am a fresher I would like to know the step by step for creating delta logic...

[Keerthana1]

Hi @Kunal Bansal, thanks for the solution...As I am a fresher I would like to know the step by step for creating delta logic.I have some doubts.what value do we have to pass in the lasttimestamp to get the latest data?Could you please tell me what is delflag=X?Do we have to use both the queries?