I_FiscalCalDateFunction

DDL: I_FISCALCALDATEFUNCTION SQL: IFISCCALDTF Type: view COMPOSITE
21 Fields 1 Data Sources 2 Associations

Dates for Fiscal Calendar Date Functions

I_FiscalCalDateFunction is a Composite CDS View that provides data about "Dates for Fiscal Calendar Date Functions" in SAP S/4HANA. It reads from 1 data source (I_FiscalDateFunctionValue) and exposes 21 fields with key field DateFunction. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Fiscal Calendar
Purpose
This CDS view provides: Start and end dates of all available fiscal date functions Fiscal time periods, such as for example fiscal week for start or end date

Structure
Main CDS parameters and filters The main CDS parameters are: P_DateFunction : Date function P_FiscalYearVariant : Fiscal year variant Measures and attributes Some important measures and attributes are: Date Function Date Function Start Date Date Function End Date

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_FiscalDateFunctionValue I_FiscalDateFunctionValue from

Parameters (2)

NameTypeDefault
P_DateFunction datefunctionid
P_FiscalYearVariant fis_periv

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FiscalCalendarDate _calDateForStartDate _calDateForStartDate.FiscalYearVariant = $parameters.P_FiscalYearVariant and _calDateForStartDate.CalendarDate = $projection.DateFunctionStartDate
[1..1] I_FiscalCalendarDate _calDateForEndDate _calDateForEndDate.FiscalYearVariant = $parameters.P_FiscalYearVariant and _calDateForEndDate.CalendarDate = $projection.DateFunctionEndDate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFISCCALDTF view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Dates for Fiscal Calendar Date Functions view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY DateFunction DateFunction Relative Date Function
DateFunctionName
DateFunctionDescription
DateFunctionGranularity _Datefunction DateFunctionGranularity
DateFunctionType _Datefunction DateFunctionType
DateFunctionStartDate DateFunctionStartDate Date Func Start Date
DateFunctionEndDate DateFunctionEndDate Date Func End Date
DateFuncStartFiscalYearWeek _calDateForStartDate FiscalYearWeek
DateFuncEndFiscalYearWeek _calDateForEndDate FiscalYearWeek
DateFuncStartFiscalWeek _calDateForStartDate FiscalWeek
DateFuncEndFiscalWeek _calDateForEndDate FiscalWeek
DateFuncStartFiscalYearPeriod _calDateForStartDate FiscalYearPeriod Period/Year
DateFuncEndFiscalYearPeriod _calDateForEndDate FiscalYearPeriod Period/Year
DateFuncStartFiscalPeriod _calDateForStartDate FiscalPeriod Tax period
DateFuncEndFiscalPeriod _calDateForEndDate FiscalPeriod Tax period
DateFuncStartFiscalYearQuarter _calDateForStartDate FiscalYearQuarter
DateFuncEndFiscalYearQuarter _calDateForEndDate FiscalYearQuarter
DateFuncStartFiscalQuarter _calDateForStartDate FiscalQuarter
DateFuncEndFiscalQuarter _calDateForEndDate FiscalQuarter
DateFuncStartFiscalYear _calDateForStartDate FiscalYear G/L Fiscal Year
DateFuncEndFiscalYear _calDateForEndDate FiscalYear G/L Fiscal Year

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_FiscalCalDateFunction.
-- 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.
-- SQL view name: IFISCCALDTF
-- Parameters: P_DateFunction : datefunctionid, P_FiscalYearVariant : fis_periv

CREATE VIEW I_FiscalCalDateFunction AS
SELECT
  DateFunction,
  _Datefunction._DateFunctionText[1: Language = $session.system_language].DateFunctionName AS DateFunctionName,
  _Datefunction._DateFunctionText[1: Language = $session.system_language].DateFunctionDescription AS DateFunctionDescription,
  _Datefunction.DateFunctionGranularity AS DateFunctionGranularity,
  _Datefunction.DateFunctionType AS DateFunctionType,
  DateFunctionStartDate,
  DateFunctionEndDate,
  _calDateForStartDate.FiscalYearWeek AS DateFuncStartFiscalYearWeek,
  _calDateForEndDate.FiscalYearWeek AS DateFuncEndFiscalYearWeek,
  _calDateForStartDate.FiscalWeek AS DateFuncStartFiscalWeek,
  _calDateForEndDate.FiscalWeek AS DateFuncEndFiscalWeek,
  _calDateForStartDate.FiscalYearPeriod AS DateFuncStartFiscalYearPeriod,
  _calDateForEndDate.FiscalYearPeriod AS DateFuncEndFiscalYearPeriod,
  _calDateForStartDate.FiscalPeriod AS DateFuncStartFiscalPeriod,
  _calDateForEndDate.FiscalPeriod AS DateFuncEndFiscalPeriod,
  _calDateForStartDate.FiscalYearQuarter AS DateFuncStartFiscalYearQuarter,
  _calDateForEndDate.FiscalYearQuarter AS DateFuncEndFiscalYearQuarter,
  _calDateForStartDate.FiscalQuarter AS DateFuncStartFiscalQuarter,
  _calDateForEndDate.FiscalQuarter AS DateFuncEndFiscalQuarter,
  _calDateForStartDate.FiscalYear AS DateFuncStartFiscalYear,
  _calDateForEndDate.FiscalYear AS DateFuncEndFiscalYear
FROM I_FiscalDateFunctionValue
LEFT OUTER JOIN I_FiscalCalendarDate AS _calDateForStartDate ON _calDateForStartDate.FiscalYearVariant = $parameters.P_FiscalYearVariant AND _calDateForStartDate.CalendarDate = DateFunctionStartDate  -- association [1..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _calDateForEndDate ON _calDateForEndDate.FiscalYearVariant = $parameters.P_FiscalYearVariant AND _calDateForEndDate.CalendarDate = DateFunctionEndDate  -- association [1..1]
;

Learn More