I_FiscalPeriodForVariant

DDL: I_FISCALPERIODFORVARIANT Type: view_entity BASIC
15 Fields 1 Data Sources 4 Associations

Fiscal Period For Fiscal Year Variant

I_FiscalPeriodForVariant (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_FiscalPeriodForVariant is a Basic CDS View (Dimension) that provides data about "Fiscal Period For Fiscal Year Variant" in SAP S/4HANA. It reads from 1 data source (P_FiscalYearPeriod) and exposes 15 fields with key fields FiscalYearVariant, FiscalYear, FiscalPeriod. It has 4 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 (4)

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

Annotations (12)

NameValueLevelField
EndUserText.label Fiscal Period For Fiscal Year Variant view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.representativeKey FiscalPeriod view
Analytics.technicalName IFIFFSCLPERDFYV 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
Analytics.dataCategory #DIMENSION view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (15)

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
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
_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_FiscalPeriodForVariant.
-- 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_FiscalPeriodForVariant 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,
  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_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..*]
;

Learn More