3329003 - Data discrepancies in SAC Planning Bi-directional connection to SAP Datasphere

Some rows are missing in a remote table that is being used in SAP Datasphere and it is being replicated in real-time via the real-time replication functionalities in the Data Integration Monitor.

SAP Datasphere

Via database explorer from the SAP Datastphere tenant execute the following sql to check how many rows there are in  $VT and $CT tables.

SELECT count(*) FROM "<Space_name>"."<Table_name>$CT" 

Check how many rows returns. Now check the $VT table

SELECT count(*) FROM "<Space_name>"."<Table_name>$VT"

Replace the <Space_name> and <Table_name> byt the corresponding space and tables name.  If you know which row is missing, you may use the where clause to reduce the number of rows returned.

Stop and start the real time replication, that will reload all rows. Doing that check if the row(s) still missing.

KBA , DS-DI-RT , Remote Tables , Problem