Symptom
In reporting apps (like Year-to-Date Balances), the value help for the Fiscal Year Period field shows unexpected entries instead of the usual monthly and special periods.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open a reporting app with Fiscal Year Period parameter (e.g. Year-to-Date Balances app).
- Fill the required parameters
- Open the value help for the Fiscal Year Period field.
- Observe that the list displays a large number of periods or the same period number appearing multiple times with different descriptions.
Cause
Fiscal Year Period is a compound characteristic that depends on the Fiscal Year Variant (FYV). The system derives the FYV from the combination of Ledger and Company Code. If Company Code is left empty, or the reporting apps does not fill the Company Code when calling Value Help, the system cannot determine which FYV to use and therefore displays periods for all Fiscal Year Variants configured in the system. This is why the same period may appear multiple times — once for each FYV — and why the total count can be very high, especially if the system contains special variants such as a daily ledger.
Resolution
This is expected system behavior. To get a filtered list of periods in apps that support it, follow these steps:
- Before opening the value help for Fiscal Year Period, first provide both Ledger and Company Code in the app's selection/filter.
- Enter or confirm the Fiscal Year.
- Open the value help for Fiscal Year Period again. In many cases the list will now be limited to the periods of the derived fiscal year variant for the specified ledger and company code.
- If the list still shows periods from multiple variants, manually select the correct period according to the fiscal year variant used by the ledger and company code in the system configuration. This behavior is standard when the fiscal year variant cannot be derived in the app.
Keywords
year-to-date balances, value help, fiscal year period, too many periods, fiscal year variant, ledger, company code, F4 help, duplicates, daily ledger,, gl reporting, reporting app, selection help , KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem
SAP Knowledge Base Article - Public