3482638 - MANDT Column Not Visible in Datasphere Replication Flow When Using ABAP CDS Views

When an ABAP CDS view is created on top of a table containing the MANDT (client) field and the CDS view is used as a source object in SAP Datasphere Replication Flow, the MANDT column is not displayed in the Object Properties dialog in Datasphere.

SAP Datasphere

1. Create an ABAP CDS view on top of an ABAP table that includes the MANDT column.
2. Establish a connection from SAP Datasphere to the ABAP source system.
3. Create a replication flow in SAP Datasphere using the CDS view as the source object.
4. Open the Object Properties of the CDS view in Datasphere.
5. The MANDT column is not visible.

The MANDT column is not explicitly included in CDS views.
Client handling is managed automatically by the CDS framework. Including the MANDT field in the CDS definition conflicts with the internal client dependency mechanism.

• The MANDT field should not be exposed in ABAP CDS views.
• For client-dependent tables, the CDS framework automatically restricts data to the logon client.

Further details can be found in: Best Practices for CDS Views and Table Functions - Client Dependency | SAP Help Portal.

• Create a Replication Flow

Replication, MADT, client, CDS view, ABAP  , KBA , DS-DI-RF , Replication Flows , Problem