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

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)

Additional observations:

• 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):

```
SELECT VIEW_NAME, IS_VALID FROM VIEWS
WHERE VIEW_NAME IN ('C_MX_DIOTTAXITEMBPTOTAL')
```

• 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

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