What is I_FiscalCalendarDate in SAP S/4HANA?

I_FiscalCalendarDate is a basic CDS view in SAP S/4HANA. Fiscal Calendar Date It contains 31 fields.

Which tables does I_FiscalCalendarDate read from?

I_FiscalCalendarDate reads data from: P_FiscalCalendarDate.

What VDM layer is I_FiscalCalendarDate?

I_FiscalCalendarDate is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_FiscalCalendarDate

DDL: I_FISCALCALENDARDATE Type: view_entity BASIC

31 Fields 1 Data Sources 10 Associations

Fiscal Calendar Date

I_FiscalCalendarDate (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_FiscalCalendarDate is a Basic CDS View (Dimension) that provides data about "Fiscal Calendar Date" in SAP S/4HANA. It reads from 1 data source (P_FiscalCalendarDate) and exposes 31 fields with key fields FiscalYearVariant, CalendarDate. It has 10 associations to related views.

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	CA-GTF-GL-CAL
Capabilities	Analytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides access to all fiscal calendar details of a calendar date in a fiscal year variant. The most important attributes of business entities are included, such as fiscal year, fiscal quarter, fiscal period, fiscal week with the corresponding start and end date.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul><li><p>What are the fiscal time frames of a calendar date?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_FiscalCalendarDate	P_FiscalCalendarDate	from

Associations (10)

Cardinality	Target	Alias	Condition
[0..1]	I_FiscalYearVariant	_FiscalYearVariant	`$projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant`
[0..1]	I_CalendarDate	_CalendarDate	`$projection.CalendarDate = _CalendarDate.CalendarDate`
[0..*]	I_FiscalYearPeriodText	_Text	`$projection.FiscalYearVariant = _Text.FiscalYearVariant and $projection.FiscalYear = _Text.FiscalYear and $projection.FiscalPeriod = _Text.FiscalPeriod`
[0..1]	I_FiscalYear	_FiscalYear	`$projection.FiscalYearVariant = _FiscalYear.FiscalYearVariant and $projection.FiscalYear = _FiscalYear.FiscalYear`
[0..1]	I_FiscalYearPeriod	_FiscalPeriod	`$projection.FiscalYearVariant = _FiscalPeriod.FiscalYearVariant and $projection.FiscalYear = _FiscalPeriod.FiscalYear and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod`
[0..1]	I_FiscalYearQuarter	_FiscalQuarter	`$projection.FiscalYearVariant = _FiscalQuarter.FiscalYearVariant and $projection.FiscalYear = _FiscalQuarter.FiscalYear and $projection.FiscalQuarter = _FiscalQuarter.FiscalQuarter`
[0..1]	I_FiscalWeek	_FiscalWeek	`$projection.FiscalYearVariant = _FiscalWeek.FiscalYearVariant and $projection.FiscalYear = _FiscalWeek.FiscalYear and $projection.FiscalYearWeek = _FiscalWeek.FiscalYearWeek and $projection.FiscalWeek = _FiscalWeek.FiscalWeek`
[0..1]	I_FiscalYearPeriodForVariant	_FiscalYearPeriod	`$projection.FiscalYearVariant = _FiscalYearPeriod.FiscalYearVariant and $projection.FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod`
[0..1]	I_FiscalYearQuarterForVariant	_FiscalYearQuarter	`$projection.FiscalYearVariant = _FiscalYearQuarter.FiscalYearVariant and $projection.FiscalYear = _FiscalYearQuarter.FiscalYear and $projection.FiscalYearQuarter = _FiscalYearQuarter.FiscalYearQuarter`
[0..1]	I_FiscalYearWeek	_FiscalYearWeek	`$projection.FiscalYearVariant = _FiscalYearWeek.FiscalYearVariant and $projection.FiscalYear = _FiscalYearWeek.FiscalYear and $projection.FiscalYearWeek = _FiscalYearWeek.FiscalYearWeek`

Annotations (13)

Name	Value	Level
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Fiscal Calendar Date	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.representativeKey	CalendarDate	view
Analytics.technicalName	IFIFCALENDARDATE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view

Fields (31)

Key	Field	Source Table	Source Field	Description
KEY	FiscalYearVariant	P_FiscalCalendarDate	fiscal_year_variant	Fiscal Year Variant
KEY	CalendarDate	P_FiscalCalendarDate	calendar_date	Calendar Date
	FiscalYear	P_FiscalCalendarDate	fiscal_year	Tax Item Fiscal Year
	FiscalYearStartDate	P_FiscalCalendarDate	fiscal_year_start_date	Start Date of Fiscal Year
	FiscalYearEndDate	P_FiscalCalendarDate	fiscal_year_end_date	End Date of Fiscal Year
	FiscalPeriod	P_FiscalCalendarDate	fiscal_period	Posting Period
	FiscalPeriodStartDate	P_FiscalCalendarDate	fiscal_period_start_date	Start Date of Fiscal Period
	FiscalPeriodEndDate	P_FiscalCalendarDate	fiscal_period_end_date	End Date of Fiscal Period
	FiscalQuarter	P_FiscalCalendarDate	fiscal_quarter	Fiscal Quarter
	FiscalQuarterStartDate	P_FiscalCalendarDate	fiscal_quarter_start_date	Start Date of Fiscal Quarter
	FiscalQuarterEndDate	P_FiscalCalendarDate	fiscal_quarter_end_date	End Date of Fiscal Quarter
	FiscalWeek	P_FiscalCalendarDate	fiscal_week	Fiscal Week
	FiscalWeekStartDate	P_FiscalCalendarDate	fiscal_week_start_date	Start Date of Fiscal Week
	FiscalWeekEndDate	P_FiscalCalendarDate	fiscal_week_end_date	End Date of Fiscal Week
	FiscalYearPeriod	P_FiscalCalendarDate	fiscal_year_period	Fiscal Year + Fiscal Period
	FiscalYearQuarter	P_FiscalCalendarDate	fiscal_year_quarter	Fiscal Year + Fiscal Quarter
	FiscalYearWeek	P_FiscalCalendarDate	fiscal_year_week	Fiscal Year + Fiscal Week
	FiscalYearConsecutiveNumber			Fiscal Year (Integer)
	FiscalPeriodConsecutiveNumber	P_FiscalCalendarDate	fiscal_year_period_int	Fiscal Year Period (Numbering)
	FiscalQuarterConsecutiveNumber	P_FiscalCalendarDate	fiscal_year_quarter_int	Fiscal Year Quarter (Numbering)
	FiscalWeekConsecutiveNumber	P_FiscalCalendarDate	fiscal_year_week_int	Fiscal Year Week (Numbering)
	_FiscalYearVariant		_FiscalYearVariant
	_CalendarDate		_CalendarDate
	_FiscalYear		_FiscalYear
	_Text		_Text
	_FiscalPeriod		_FiscalPeriod
	_FiscalQuarter		_FiscalQuarter
	_FiscalWeek		_FiscalWeek
	_FiscalYearPeriod		_FiscalYearPeriod
	_FiscalYearQuarter		_FiscalYearQuarter
	_FiscalYearWeek		_FiscalYearWeek

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FiscalCalendarDate.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FiscalCalendarDate AS
SELECT
  P_FiscalCalendarDate.fiscal_year_variant AS FiscalYearVariant,
  P_FiscalCalendarDate.calendar_date AS CalendarDate,
  P_FiscalCalendarDate.fiscal_year AS FiscalYear,
  P_FiscalCalendarDate.fiscal_year_start_date AS FiscalYearStartDate,
  P_FiscalCalendarDate.fiscal_year_end_date AS FiscalYearEndDate,
  P_FiscalCalendarDate.fiscal_period AS FiscalPeriod,
  P_FiscalCalendarDate.fiscal_period_start_date AS FiscalPeriodStartDate,
  P_FiscalCalendarDate.fiscal_period_end_date AS FiscalPeriodEndDate,
  P_FiscalCalendarDate.fiscal_quarter AS FiscalQuarter,
  P_FiscalCalendarDate.fiscal_quarter_start_date AS FiscalQuarterStartDate,
  P_FiscalCalendarDate.fiscal_quarter_end_date AS FiscalQuarterEndDate,
  P_FiscalCalendarDate.fiscal_week AS FiscalWeek,
  P_FiscalCalendarDate.fiscal_week_start_date AS FiscalWeekStartDate,
  P_FiscalCalendarDate.fiscal_week_end_date AS FiscalWeekEndDate,
  P_FiscalCalendarDate.fiscal_year_period AS FiscalYearPeriod,
  P_FiscalCalendarDate.fiscal_year_quarter AS FiscalYearQuarter,
  P_FiscalCalendarDate.fiscal_year_week AS FiscalYearWeek,
  cast(P_FiscalCalendarDate.fiscal_year as fins_fiscalyear_i) AS FiscalYearConsecutiveNumber,
  P_FiscalCalendarDate.fiscal_year_period_int AS FiscalPeriodConsecutiveNumber,
  P_FiscalCalendarDate.fiscal_year_quarter_int AS FiscalQuarterConsecutiveNumber,
  P_FiscalCalendarDate.fiscal_year_week_int AS FiscalWeekConsecutiveNumber
FROM P_FiscalCalendarDate
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON CalendarDate = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodText AS _Text ON FiscalYearVariant = _Text.FiscalYearVariant AND FiscalYear = _Text.FiscalYear AND FiscalPeriod = _Text.FiscalPeriod  -- association [0..*]
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND FiscalYear = _FiscalYear.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriod AS _FiscalPeriod ON FiscalYearVariant = _FiscalPeriod.FiscalYearVariant AND FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearQuarter AS _FiscalQuarter ON FiscalYearVariant = _FiscalQuarter.FiscalYearVariant AND FiscalYear = _FiscalQuarter.FiscalYear AND FiscalQuarter = _FiscalQuarter.FiscalQuarter  -- association [0..1]
LEFT OUTER JOIN I_FiscalWeek AS _FiscalWeek ON FiscalYearVariant = _FiscalWeek.FiscalYearVariant AND FiscalYear = _FiscalWeek.FiscalYear AND FiscalYearWeek = _FiscalWeek.FiscalYearWeek AND FiscalWeek = _FiscalWeek.FiscalWeek  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriod ON FiscalYearVariant = _FiscalYearPeriod.FiscalYearVariant AND FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearQuarterForVariant AS _FiscalYearQuarter ON FiscalYearVariant = _FiscalYearQuarter.FiscalYearVariant AND FiscalYear = _FiscalYearQuarter.FiscalYear AND FiscalYearQuarter = _FiscalYearQuarter.FiscalYearQuarter  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearWeek AS _FiscalYearWeek ON FiscalYearVariant = _FiscalYearWeek.FiscalYearVariant AND FiscalYear = _FiscalYearWeek.FiscalYear AND FiscalYearWeek = _FiscalYearWeek.FiscalYearWeek  -- association [0..1]
;

Depth:

I_FiscalCalendarDate view_entity

P_FiscalCalendarDate view_entity