I_FiscalYear

DDL: I_FISCALYEAR Type: view_entity BASIC
9 Fields 1 Data Sources

Fiscal Year with Next Fiscal Year

I_FiscalYear (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_FiscalYear is a Basic CDS View (Dimension) that provides data about "Fiscal Year with Next Fiscal Year" in SAP S/4HANA. It reads from 1 data source (P_FiscalYear) and exposes 9 fields with key fields FiscalYearVariant, FiscalYear.

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
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the fiscal year and next fiscal year details of a fiscal year in a fiscal year variant. These attributes of business entities include the start and end date of the fiscal year and the next 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 its subsequent year?</p></li> <li><p>What is the next fiscal year of a selected fiscal year?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_FiscalYear P_FiscalYear from

Annotations (12)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Fiscal Year with Next Fiscal Year view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey FiscalYear view
Analytics.technicalName IFIFISCALYEAR view
Analytics.dataCategory #DIMENSION view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearVariant P_FiscalYear FiscalYearVariant Fiscal Year Variant
KEY FiscalYear P_FiscalYear FiscalYear G/L Fiscal Year
FiscalYearStartDate P_FiscalYear FiscalYearStartDate Start Date of Fiscal Year
FiscalYearEndDate P_FiscalYear FiscalYearEndDate End Date of Fiscal Year
FiscalYearConsecutiveNumber P_FiscalYear FiscalYearConsecutiveNumber Fiscal Year (Integer)
NextFiscalYear Next Fiscal Year
NextFiscalYearStartDate Start Date of Next Fiscal Year
NextFiscalYearEndDate End Date of Next Fiscal Year
_FiscalYearVariant P_FiscalYear _FiscalYearVariant

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_FiscalYear.
-- 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_FiscalYear AS
SELECT
  P_FiscalYear.FiscalYearVariant AS FiscalYearVariant,
  P_FiscalYear.FiscalYear AS FiscalYear,
  P_FiscalYear.FiscalYearStartDate AS FiscalYearStartDate,
  P_FiscalYear.FiscalYearEndDate AS FiscalYearEndDate,
  P_FiscalYear.FiscalYearConsecutiveNumber AS FiscalYearConsecutiveNumber,
  cast( P_FiscalYear.NextFiscalYear as fins_next_fiscalyear_no_conv preserving type ) AS NextFiscalYear,
  cast( P_FiscalYear.NextFiscalYearStartDate as fins_next_fyear_startdate preserving type ) AS NextFiscalYearStartDate,
  cast( P_FiscalYear.NextFiscalYearEndDate as fins_next_fyear_enddate preserving type ) AS NextFiscalYearEndDate,
  P_FiscalYear._FiscalYearVariant AS _FiscalYearVariant
FROM P_FiscalYear
;

Learn More