I_FiscalCalDateFunction

DDL: I_FISCALCALDATEFUNCTION SQL: IFISCCALDTF Type: view COMPOSITE

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.

1 data source(s) 21 fields

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
DateFunctionName
DateFunctionDescription
DateFunctionGranularity _Datefunction DateFunctionGranularity
DateFunctionType _Datefunction DateFunctionType
DateFunctionStartDate DateFunctionStartDate
DateFunctionEndDate DateFunctionEndDate
DateFuncStartFiscalYearWeek _calDateForStartDate FiscalYearWeek
DateFuncEndFiscalYearWeek _calDateForEndDate FiscalYearWeek
DateFuncStartFiscalWeek _calDateForStartDate FiscalWeek
DateFuncEndFiscalWeek _calDateForEndDate FiscalWeek
DateFuncStartFiscalYearPeriod _calDateForStartDate FiscalYearPeriod
DateFuncEndFiscalYearPeriod _calDateForEndDate FiscalYearPeriod
DateFuncStartFiscalPeriod _calDateForStartDate FiscalPeriod
DateFuncEndFiscalPeriod _calDateForEndDate FiscalPeriod
DateFuncStartFiscalYearQuarter _calDateForStartDate FiscalYearQuarter
DateFuncEndFiscalYearQuarter _calDateForEndDate FiscalYearQuarter
DateFuncStartFiscalQuarter _calDateForStartDate FiscalQuarter
DateFuncEndFiscalQuarter _calDateForEndDate FiscalQuarter
DateFuncStartFiscalYear _calDateForStartDate FiscalYear
DateFuncEndFiscalYear _calDateForEndDate FiscalYear 
@AbapCatalog.sqlViewName: 'IFISCCALDTF'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Dates for Fiscal Calendar Date Functions'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
define view I_FiscalCalDateFunction
  with parameters
    P_DateFunction      : datefunctionid,
    P_FiscalYearVariant : fis_periv

  as select from I_FiscalDateFunctionValue

  association [1..1] to I_FiscalCalendarDate as _calDateForStartDate on  _calDateForStartDate.FiscalYearVariant = $parameters.P_FiscalYearVariant
                                                                     and _calDateForStartDate.CalendarDate      = $projection.DateFunctionStartDate
  association [1..1] to I_FiscalCalendarDate as _calDateForEndDate   on  _calDateForEndDate.FiscalYearVariant = $parameters.P_FiscalYearVariant
                                                                     and _calDateForEndDate.CalendarDate      = $projection.DateFunctionEndDate
{
  key DateFunction,
      _Datefunction._DateFunctionText[1: Language = $session.system_language].DateFunctionName,
      _Datefunction._DateFunctionText[1: Language = $session.system_language].DateFunctionDescription,
      _Datefunction.DateFunctionGranularity,
      _Datefunction.DateFunctionType,

      // Date

      DateFunctionStartDate                  as DateFunctionStartDate,
      DateFunctionEndDate                    as DateFunctionEndDate,

      // FiscalYearWeek

      _calDateForStartDate.FiscalYearWeek    as DateFuncStartFiscalYearWeek,
      _calDateForEndDate.FiscalYearWeek      as DateFuncEndFiscalYearWeek,

      // FiscalWeek

      _calDateForStartDate.FiscalWeek        as DateFuncStartFiscalWeek,
      _calDateForEndDate.FiscalWeek          as DateFuncEndFiscalWeek,

      // FiscalYearPeriod

      _calDateForStartDate.FiscalYearPeriod  as DateFuncStartFiscalYearPeriod,
      _calDateForEndDate.FiscalYearPeriod    as DateFuncEndFiscalYearPeriod,

      // FiscalPeriod

      _calDateForStartDate.FiscalPeriod      as DateFuncStartFiscalPeriod,
      _calDateForEndDate.FiscalPeriod        as DateFuncEndFiscalPeriod,

      // FiscalYearQuarter

      _calDateForStartDate.FiscalYearQuarter as DateFuncStartFiscalYearQuarter,
      _calDateForEndDate.FiscalYearQuarter   as DateFuncEndFiscalYearQuarter,

      // FiscalQuarter

      _calDateForStartDate.FiscalQuarter     as DateFuncStartFiscalQuarter,
      _calDateForEndDate.FiscalQuarter       as DateFuncEndFiscalQuarter,

      // FiscalYear

      _calDateForStartDate.FiscalYear        as DateFuncStartFiscalYear,
      _calDateForEndDate.FiscalYear          as DateFuncEndFiscalYear
}
where
      DateFunction             = $parameters.P_DateFunction
  and FiscalYearVariant        = $parameters.P_FiscalYearVariant
  and DateFunctionValidityDate = $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FISCALCALENDARDATE",
"I_FISCALDATEFUNCTION",
"I_FISCALDATEFUNCTIONTEXT",
"I_FISCALDATEFUNCTIONVALUE"
],
"ASSOCIATED":
[
"I_FISCALCALENDARDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More