Replication Agent for Microsoft SQL Server introduces the sp_SybTruncateTable stored procedure to support truncation of tables marked for replication from SAP enterprise resource planning (ERP) or any applications.
Earlier versions of Replication Agent for Microsoft SQL Server does not support truncation of tables marked for replication from any applications due to the Microsoft SQL Server database limitation.
In 15.7.1 SP200, you can execute the sp_SybTruncateTable stored procedure to truncate tables marked for replication from SAP enterprise resource planning (ERP) applications. When you issue sp_SybTruncateTable, the stored procedure turns off the replication flag for the marked tables temporarily, issues the truncate table command, and then turns on the replication flag.
The SAP ERP system that uses Replication Agent for Microsoft SQL Server for replication requires the latest patch of the SAP Kernel that has the sp_SybTruncateTable stored procedure.
See SAP Note 1972365 – Retry on error 4711: https://css.wdf.sap.corp/sap/support/notes/1972365 for the SAP Kernel download and installation instructions.
The sp_SybTruncateTable stored procedure is installed during first-time initialization with server_admin init. The truncate table DDL statements are always sent to SAP Replication Server as data manipulation language (DML) transactions.
See The sp_SybTruncateTable Stored Procedure in the Replication Agent Primary Database Guide.