SAP Knowledge Base Article - Public

3725855 - Delta Change columns not visible in Data Viewer for Local Tables (File) in SAP Datasphere

Symptom

Local tables created via Replication Flows in SAP Datasphere spaces of type SAP HANA Data Lake Files (HDLF) do not display the following technical delta change columns in the Datasphere modeling layer:

  • CHANGE_TYPE
  • CHANGE_DATE

The columns:

  • Are present in the physical target table in SAP HANA Data Lake.
  • Are not displayed in the Datasphere Data Viewer.

Environment

SAP Datasphere 1.0

Cause

Replication Flows targeting Local Tables (File) in HDLF spaces create technical delta columns such as CHANGE_TYPE and CHANGE_DATE as internal replication metadata in the physical target table.

These technical columns are not exposed as regular columns in the Datasphere modeling layer/Data Viewer.

Delta consumption for Local Tables (File) is provided through the Delta Sharing Change Data Feed (CDF) API, rather than by exposing the technical replication columns directly for general modeling consumption.

For more information, refer to the SAP Datasphere documentation on capturing delta changes in Local Tables (File).

Resolution

The absence of CHANGE_TYPE and CHANGE_DATE in the Datasphere Data Viewer is expected behavior for Local Tables (File) in HDLF spaces.

If delta data needs to be consumed from a Local Table (File), the supported approach is to use the Delta Sharing Change Data Feed (CDF) API.

For graphical views, consumption of Local Tables (File) with delta capture is supported for active records. Delta consumption in graphical views is not provided through the technical CHANGE_TYPE and CHANGE_DATE columns.

For further information, refer to the SAP Datasphere documentation:

Please refer to the latest SAP Datasphere documentation for the currently supported delta capture and consumption scenarios.

Keywords

CHANGE_DATE, CHANGE_TYPE, Delta, Space, Replication, DWC, Datasphere, Table, Column, visible, HDLF , KBA , DS-DI-RF , Replication Flow Runtime , Problem

Product

SAP Datasphere 1.0