Data is appearing from all clients in the target

[SAPSupport]

We are replicating tables from S4HANA system to SQL server by using SLT server. Once the table is replicated to sql server it is having all client data, but our requirement is to replicate only business client data of a table.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Client is a field in the table, by default SLT will replicate data for all clients unless you have "Read from Single Client" checked, however, if you maintain "Read from Single Client" it affects the triggers so you will only be able to replicate from one client even in new configurations. 

The other way to filter out the data for unwanted clients is by maintaining a filter on the MANDT field (sometimes MANDANT) - https://me.sap.com/notes/2581611

Best Regards,
SAP Support