1632044 - Errors returned with a Custom Financial report - Fiscal Year variant missing

SAP Knowledge Base Article - Public

1632044 - Errors returned with a Custom Financial report - Fiscal Year variant missing

Symptom

Some errors are returned when opening a Custom Created report based on the Material Inventory- Reconciliation data source.

Reproducing the Issue

  1. From the Business Analytics work center choose the Design Reports view.
  2. Create a new report from scratch, based on the 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 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

Cause

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

  • Company

  • Set of Books

  • Accounting Period/Year

  • Chart of Accounts

  • Fiscal Year Variant

Resolution

In a Financials 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 to 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.

See Also

You may also find additional information on custom report from the Help Center by searching for the guide called Custom Financial Reports.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions