https://community.qlik.com/t5/Official-Support-Articles/SAP-Hana-filter-limitation-on-DELETE/ta-p/1749789 <DIV> <P>&nbsp;</P> <P>In the Replicate User Guide, it states: when using Log-Based CDC method, delete and updated operations are not supported for filtered records for SAP HANA source endpoint.</P> <P>Ref: <A href="https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/SAP%20Hana%20Source/limitations_saphana_source.htm" target="_blank">https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/SAP%20Hana%20Source/limitations_saphana_source.htm</A></P> <P>When Replicate reads a DELETE operation for SAP HANA source, it only gets the values of the columns of the PK and not any values of other columns.</P> <P>Thus, the limitation on DELETE is only for columns that are not part of the primary key.</P> </DIV> <DIV> <P>&nbsp;</P> </DIV> Thu, 05 May 2022 15:16:51 GMT Michael_Litz 2022-05-05T15:16:51Z https://community.qlik.com/t5/Official-Support-Articles/SAP-Hana-filter-limitation-on-DELETE/ta-p/1749789 <DIV> <P>&nbsp;</P> <P>In the Replicate User Guide, it states: when using Log-Based CDC method, delete and updated operations are not supported for filtered records for SAP HANA source endpoint.</P> <P>Ref: <A href="https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/SAP%20Hana%20Source/limitations_saphana_source.htm" target="_blank">https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/SAP%20Hana%20Source/limitations_saphana_source.htm</A></P> <P>When Replicate reads a DELETE operation for SAP HANA source, it only gets the values of the columns of the PK and not any values of other columns.</P> <P>Thus, the limitation on DELETE is only for columns that are not part of the primary key.</P> </DIV> <DIV> <P>&nbsp;</P> </DIV> Thu, 05 May 2022 15:16:51 GMT https://community.qlik.com/t5/Official-Support-Articles/SAP-Hana-filter-limitation-on-DELETE/ta-p/1749789 Michael_Litz 2022-05-05T15:16:51Z