I_FiscalYearPeriod

DDL: I_FISCALYEARPERIOD Type: view_entity BASIC Package: FINS_FI_DATE
17 Fields 1 Data Sources 5 Associations

Fiscal Year Period

I_FiscalYearPeriod (Basic)

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

Accounting and Financial Close

I_FiscalYearPeriod is a Basic CDS View (Dimension) that provides data about "Fiscal Year Period" in SAP S/4HANA. It reads from 1 data source (P_FiscalYearPeriod) and exposes 17 fields with key fields FiscalYearVariant, FiscalYear, FiscalPeriod. It has 5 associations to related views. Part of development package FINS_FI_DATE.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCA-GTF-GL-CAL
CapabilitiesAnalytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the relevant fiscal calendar details of a fiscal year and a fiscal period in a fiscal year variant. These attributes of business entities include the start and end date of the fiscal year and the fiscal period but also an indicator, whether the fiscal period is a special period and the next fiscal period together with the corresponding fiscal year.</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 fiscal year and a fiscal period?</p></li> <li><p>What is the next fiscal period of a combination of fiscal year and fiscal period?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_FiscalYearPeriod P_FiscalYearPeriod from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_FiscalYearVariant _FiscalYearVariant $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
[0..1] I_CalendarDate _FiscalPeriodStartDate $projection.FiscalPeriodStartDate = _FiscalPeriodStartDate.CalendarDate
[0..1] I_FiscalYear _FiscalYear $projection.FiscalYearVariant = _FiscalYear.FiscalYearVariant and $projection.FiscalYear = _FiscalYear.FiscalYear
[0..*] I_FiscalYearPeriodText _Text $projection.FiscalYearVariant = _Text.FiscalYearVariant and $projection.FiscalYear = _Text.FiscalYear and $projection.FiscalPeriod = _Text.FiscalPeriod
[0..1] I_FiscalCalendarDate _FiscalCalendarDate $projection.FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant and $projection.FiscalYear = _FiscalCalendarDate.FiscalYear and $projection.FiscalPeriod = _FiscalCalendarDate.FiscalPeriod and $projection.FiscalYearPeriod = _FiscalCalendarDate.FiscalYearPeriod and $projection.FiscalPeriodStartDate = _FiscalCalendarDate.CalendarDate

Annotations (11)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Fiscal Year Period view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey FiscalPeriod view
Analytics.technicalName IFIFYEARPERIOD view
Analytics.dataCategory #DIMENSION view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearVariant P_FiscalYearPeriod fiscal_year_variant Fiscal Year Variant
KEY FiscalYear P_FiscalYearPeriod fiscal_year Tax Item Fiscal Year
KEY FiscalPeriod P_FiscalYearPeriod fiscal_period Posting Period
FiscalPeriodStartDate P_FiscalYearPeriod fiscal_period_start_date Start Date of Fiscal Period
FiscalPeriodEndDate P_FiscalYearPeriod fiscal_period_end_date End Date of Fiscal Period
IsSpecialPeriod P_FiscalYearPeriod is_special_period Indicator: Is Special Period
FiscalYearStartDate P_FiscalYearPeriod fiscal_year_start_date Start Date of Fiscal Year
FiscalYearEndDate P_FiscalYearPeriod fiscal_year_end_date End Date of Fiscal Year
FiscalYearPeriod P_FiscalYearPeriod fiscal_year_period Fiscal Year + Fiscal Period
FiscalPeriodConsecutiveNumber _FiscalCalendarDate FiscalPeriodConsecutiveNumber Fiscal Year Period (Numbering)
NextFiscalPeriod P_FiscalYearPeriod next_fiscal_period Next Fiscal Period
NextFiscalPeriodFiscalYear P_FiscalYearPeriod next_fiscal_period_fiscal_year Fiscal Year of Next Fiscal Period
NextFsclPeriodConsecutiveNmbr
_FiscalYearVariant _FiscalYearVariant
_FiscalPeriodStartDate _FiscalPeriodStartDate
_FiscalYear _FiscalYear
_Text _Text

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_FiscalYearPeriod.
-- 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_FiscalYearPeriod AS
SELECT
  P_FiscalYearPeriod.fiscal_year_variant AS FiscalYearVariant,
  P_FiscalYearPeriod.fiscal_year AS FiscalYear,
  P_FiscalYearPeriod.fiscal_period AS FiscalPeriod,
  P_FiscalYearPeriod.fiscal_period_start_date AS FiscalPeriodStartDate,
  P_FiscalYearPeriod.fiscal_period_end_date AS FiscalPeriodEndDate,
  P_FiscalYearPeriod.is_special_period AS IsSpecialPeriod,
  P_FiscalYearPeriod.fiscal_year_start_date AS FiscalYearStartDate,
  P_FiscalYearPeriod.fiscal_year_end_date AS FiscalYearEndDate,
  P_FiscalYearPeriod.fiscal_year_period AS FiscalYearPeriod,
  _FiscalCalendarDate.FiscalPeriodConsecutiveNumber AS FiscalPeriodConsecutiveNumber,
  P_FiscalYearPeriod.next_fiscal_period AS NextFiscalPeriod,
  P_FiscalYearPeriod.next_fiscal_period_fiscal_year AS NextFiscalPeriodFiscalYear,
  _FiscalCalendarDate.FiscalPeriodConsecutiveNumber + 1 AS NextFsclPeriodConsecutiveNmbr
FROM P_FiscalYearPeriod
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _FiscalPeriodStartDate ON FiscalPeriodStartDate = _FiscalPeriodStartDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND FiscalYear = _FiscalYear.FiscalYear  -- 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_FiscalCalendarDate AS _FiscalCalendarDate ON FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant AND FiscalYear = _FiscalCalendarDate.FiscalYear AND FiscalPeriod = _FiscalCalendarDate.FiscalPeriod AND FiscalYearPeriod = _FiscalCalendarDate.FiscalYearPeriod AND FiscalPeriodStartDate = _FiscalCalendarDate.CalendarDate  -- association [0..1]
;

Learn More