I_FiscalYearPeriodForVariant

DDL: I_FISCALYEARPERIODFORVARIANT Type: view_entity BASIC
17 Fields 1 Data Sources 6 Associations

Fiscal Year Period For Fiscal Year Variant

I_FiscalYearPeriodForVariant (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_FiscalYearPeriodForVariant is a Basic CDS View (Dimension) that provides data about "Fiscal Year Period For Fiscal Year Variant" in SAP S/4HANA. It reads from 1 data source (P_FiscalYearPeriod) and exposes 17 fields with key fields FiscalYearVariant, FiscalYearPeriod. It has 6 associations to related views.

SAP API Hub

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, Data Source for Data Extraction
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_FiscalYearPeriod P_FiscalYearPeriod from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_FiscalYearVariant _FiscalYearVariant $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
[0..1] I_CalendarDate _FiscalPeriodStartDate $projection.FiscalPeriodStartDate = _FiscalPeriodStartDate.CalendarDate
[0..1] I_FiscalYearForVariant _FiscalYear $projection.FiscalYearVariant = _FiscalYear.FiscalYearVariant and $projection.FiscalYear = _FiscalYear.FiscalYear
[0..1] I_FiscalPeriodForVariant _FiscalPeriod $projection.FiscalYearVariant = _FiscalPeriod.FiscalYearVariant and $projection.FiscalYear = _FiscalPeriod.FiscalYear and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod
[0..*] I_FiscalYearPeriodText _Text $projection.FiscalYearVariant = _Text.FiscalYearVariant and $projection.FiscalYear = _Text.FiscalYear and $projection.FiscalPeriod = _Text.FiscalPeriod
[0..1] I_FiscalYearForVariant _FiscalYearForVariant $projection.FiscalYearVariant = _FiscalYearForVariant.FiscalYearVariant and $projection.FiscalYear = _FiscalYearForVariant.FiscalYear

Annotations (12)

NameValueLevelField
EndUserText.label Fiscal Year Period For Fiscal Year Variant view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey FiscalYearPeriod view
Analytics.technicalName IFIFYEARPERDFYV 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 FiscalYearPeriod P_FiscalYearPeriod fiscal_year_period Fiscal Year + Fiscal Period
FiscalYear P_FiscalYearPeriod fiscal_year Tax Item Fiscal Year
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
NextFiscalPeriod P_FiscalYearPeriod next_fiscal_period Next Fiscal Period
NextFiscalPeriodFiscalYear P_FiscalYearPeriod next_fiscal_period_fiscal_year Fiscal Year of Next Fiscal Period
_FiscalYearVariant _FiscalYearVariant
_FiscalPeriodStartDate _FiscalPeriodStartDate
_FiscalYear _FiscalYear
_FiscalPeriod _FiscalPeriod
_Text _Text
_FiscalYearForVariant _FiscalYearForVariant

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_FiscalYearPeriodForVariant.
-- 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_FiscalYearPeriodForVariant AS
SELECT
  P_FiscalYearPeriod.fiscal_year_variant AS FiscalYearVariant,
  P_FiscalYearPeriod.fiscal_year_period AS FiscalYearPeriod,
  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.next_fiscal_period AS NextFiscalPeriod,
  P_FiscalYearPeriod.next_fiscal_period_fiscal_year AS NextFiscalPeriodFiscalYear
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_FiscalYearForVariant AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND FiscalYear = _FiscalYear.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriod ON FiscalYearVariant = _FiscalPeriod.FiscalYearVariant AND FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod  -- 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_FiscalYearForVariant AS _FiscalYearForVariant ON FiscalYearVariant = _FiscalYearForVariant.FiscalYearVariant AND FiscalYear = _FiscalYearForVariant.FiscalYear  -- association [0..1]
;

Learn More