SAP Knowledge Base Article - Public

3366950 - The table name _I_XYZ is unknown or obscured by an alias in Custom CDS Views app - SAP S/4HANA Cloud Public Edition

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

  1. Open Custom CDS Views app.
  2. Select a custom CDS view.
  3. Go to Data Sources tab.
  4. Remove an association (as long as the association is not being used by a dependency).
  5. Click on publish.
  6. The error "The table name _I_XYZ is unknown or obscured by an alias." is raised.

Or

  1. Open Custom CDS Views app.
  2. Select a custom CDS view.
  3. Add a calculation to the Element.
  4. Check the custom CDS view.
  5. 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

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions