During replication from supported databases into SAP HANA database, Replication Server supports the replication of LOB columns in a table without a unique key.
If a table has no unique key and has LOB columns, the status of the LOB columns should be set to replicate_if_changed.
By default, the Replication Agents for Oracle, Microsoft SQL Server, or IBM DB2 UDB set the status of all LOB columns to replicate_if_changed.
For SAP Adaptive Server Replication Agent Thread, by default, sp_setreptable sets the replication status to always_replicate. You must use sp_setrepcol to set the replication status for LOB columns to replicate_if_changed.