SAP Knowledge Base Article - Preview

3783805 - DRC Mexico Statutory Reporting - Database error 391 invalidated view C_MX_DIOTTAXITEMBPTOTAL when generating DIOT 54 report

Symptom

  • When running the MX_VAT_DCL report from the application launchpad, the following error is displayed:

Database error 391 in access to C_MX_DIOTTAXITEMBPTOTAL
> invalidated view: C_MX_DIOTTAXITEMBPTOTAL: line 1 col 1205 (at pos 1204)
Loop query TAXITEMBPTOTAL does not use all non-unique key fields
SQL error on database selection: invalidated view: C_MX_DIOTTAXITEMBPTOTAL: line 1 col 1205 (at pos 1204)

  • The CDS view C_MX_DIOTTAXITEMBPTOTAL is active at the ABAP Dictionary level (SE80), but the corresponding runtime object is inactive in HANA.
  • A validation query using DB02 on the HANA views shows that only the original view C_MX_DIOTTAXITEMBPTOTAL is invalid (IS_VALID = FALSE).


Read more...

Environment

  • DRC Mexico Statutry Reporting
  • SAP S/4HANA
  • SAP S/4HANA Cloud Private Edition
  • SAP Fiori for SAP S/4HANA
  • SAP Fiori for SAP S/4HANA Cloud Private Edition

Product

SAP Fiori for SAP S/4HANA Cloud Private Edition all versions ; SAP Fiori for SAP S/4HANA all versions ; SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA all versions

Keywords

MX_VAT_DCL, DIOT, Mexico VAT, C_MX_DIOTTAXITEMBPTOTAL, TAXITEMBPTOTAL, invalidated view, Database error 391, SQL error 391, CDS view, HANA runtime object, ABAP Dictionary, SE80, Loop query, non-unique key fields, DRC Mexico, MX_VAT_DIOT_V0, MX_RPG_ENT, S4CORE 108, invalid view, recreate view , KBA , FI-LOC-FI-MX-ACR , Statutory Reporting , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.