1632044 - Custom Financial Report returns Errors - Fiscal Year Variant Missing

Some errors are returned when opening a custom created report based on the standard data source Material Inventory- Reconciliation (technical ID FININVU08).

SAP Business by Design

1. From the Business Analytics work center choose the view Design Reports.
2. Create a new report from scratch, based on the standard data source Material Inventories - Reconciliation (FININVU08), choosing New then Report.
3. Do not change anything and click on Next then Finish.
4. When you open the newly created report the following errors are shown:
   • INTERNAL_MDAV_FISCVARNT_MISSING
   • An exception with the type CM_MDRS_MDAV_FAILED occurred, but was neither handled locally, nor declared in a RAISING clause
   • Error reading the data of InfoProvider @MFININVU08
   • Error reading the data of InfoProvider @MFININVU08
   • Error while reading data; navigation is possible

To enable full and consistent data in financial reports the following characteristics are always required:

• Company
• Set of Books
• Accounting Period/Year
• Chart of Accounts
• Fiscal Year Variant

In a financial report the Fiscal Year Variant has to be part of the report. The reason for this is that the Accounting Period relies on this characteristic.
In this case you need to add the Fiscal Year Variant (FISCVARNT), via the report wizard, either do the fixed or variable selection criteria.

Note: The required characteristics will already be included when you make a copy of an existing report. Therefore it is recommended to use the Report copy functionality.

You find additional information on custom finance reports on our SAP Help Center in the article Custom Financial Reports.

fin report; fin reports; financial reports; custom reports; financial custom reports; fiscal year variant missing; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To