Symptom
- Delete an association from Data Source tab in Custom CDS Views app.
- Getting error: The table name _I_XYZ is unknown or obscured by an alias.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open Custom CDS Views app.
- Select a custom CDS view.
- Go to Data Sources tab.
- Remove an association (as long as the association is not being used by a dependency).
- Click on publish.
- The error "The table name _I_XYZ is unknown or obscured by an alias." is raised.
Or
- Open Custom CDS Views app.
- Select a custom CDS view.
- Add a calculation to the Element.
- Check the custom CDS view.
- The error "The table name _I_XYZ is unknown or obscured by an alias." is raised.
Cause
The association is still used in the custom CDS view, very likely in a Calculation field.
Or you are using the data source that not in the data source tab of the custom CDS view.
Resolution
A review should be carried out of the calculation fields in the Custom CDS view, in order to remove the usages.
And the data source that not in the data source tab should not be used in the Custom CDS view.
Keywords
custom cds view, calculation, table name, unknown or obscured by an alias, The table name _I_XYZ is unknown or obscured by an alias , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem