SAP Knowledge Base Article - Public

3300715 - Fiscal Period Date field not avialable in trial balance app

Symptom

Dimension, field Fiscal Period Date is not available in apps Trial Balance (App ID F0996) (CDS View C_Trialbalanceq0001) and Trial Balance Comparison (App ID W0097) (cds view C_Trialbalanceq0002) from release 2302

The Fiscal Period Date is build as concatenation of PostingDate, FiscalPeriod

"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 

Reproducing the Issue

 In app Trial Balance/Trial Balance Comparison search for field Fiscal Period Date

Cause

SADL and AE implemented the logic for considering the annotation Consumption.hidden and Analytics.hidden. The field is a technical field used to define the exception aggregation. There is no business value to it.

Resolution

Fields Posting date and Fiscal Year Period are available for consumption 

See Also

Trial Balance

Change Calculation of Trial Balance

Keywords

C_Trialbalanceq0001, C_Trialbalanceq0002,  FiscalPeriodDate, Fiscal period date,  , KBA , FI-FIO-GL-IS , Reporting Apps , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem

Product

SAP S/4HANA Cloud 2302