Symptom
- While using local table with enabled delta as source for other datasphere models, you noticed 'Change Date' and 'Change Type' fields are missing
- You copy information of delta fields to other models but the same don't behave as expected. There are missing fields of 'Change Type' 'D' or similar unexpected behavior.
Environment
SAP Datasphere
Reproducing the Issue
Attempting to use any delta enabled object information on other exposed models.
Cause
The delta mechanism of Datasphere is as of now only intended to be used on this product.
For this reason there are blocks to impede this information from being used on exposed models or being propagated through objects such as Analytic Models, Graphical Views, SQL Views...
Resolution
Currently, these fields are not allowed to be used externally. With enough influence this might change in the future.
More details about this are in the link below:
SAP Wiki - Capturing Delta Changes in Your Local Table
Already some customers created influence request for the same:
Delta table used as source in Graphical Views:
SAP Influence 343486 - Improvement Request Details - Customer Influence
See Also
SAP Note 3332382 - How to create an enhancement request for SAP Datasphere?
Keywords
Delta table, delta fields, change type, change date , KBA , DS-MD , Modeling (Data Builder) , Problem
SAP Knowledge Base Article - Public