SAP Knowledge Base Article - Public

1628498 - Custom report shows a wrong selection for Accounting Period/Year and Fiscal Variant.

Symptom

A custom report shows an incorrect value for the Accounting Period/Year from the variable selection. In fact, the value of the Accounting Period/Year, from the value help, doesn't match the Fiscal Year Variant one.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. From the Business Analytics work center choose the Design Data Sources view.
  2. Create a custom combined data source based on the following data sources:
    - Cost Center - Line Items (FINCACU01)
    - Purchase Ledger Account Line Items (FININVU03)
    - G/L Account Items (FINGLAU02)
  3. Build a custom report XYZ (XYZ means the Report ID) based on the newly created combined data source.
  4. Assign the report XYZ to the desired work center.
  5. Open the report XYZ.
  6. From the variable screen, click the value help for the Accounting Period/Year and search for a period, for example 005.2025, and notice that the value shown for the Accounting Period/Year doesn't match the one shown for the Fiscal Year Variant.
  7. When checking the same for a standard report, it can be seen that the value match.

Cause

The Fiscal Year Variant has been selected wrongly while joining the three data sources.

Resolution

In this example, the Fiscal Year Variant has been selected wrongly for the G/L account Items while joining the three data sources.

To have the matching values the following selection should have been done:

  • Combined data source field:  Fiscal Year Variant.
  • Cost Center – Line Items: Fiscal Year Variant.
  • Purchase Ledger Account Line Items: Fiscal Year Variant.
  • G/L Account Items: Fiscal Year Variant.

Note: when building a combined data source the following recommendation should be considered:

  • Choose only characteristics which can be mapped from the combined data sources.
  • Choose key figures which are unique per Data Source (otherwise data will be aggregated).

See Also

Further information on finance reports is available on SAP Help Portal in the document Custom Financial Reports.

Keywords

custom report; custom financial report; fin report; fiscal variant; accounting period/year; selection; incorrect selection , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions