C_DateFunction

DDL: C_DATEFUNCTION SQL: CDATEFNC Type: view CONSUMPTION

Date Functions

C_DateFunction is a Consumption CDS View that provides data about "Date Functions" in SAP S/4HANA. It reads from 2 data sources (I_Datefunction, dd07t) and exposes 24 fields with key field DateFunction. It has 1 association to related views.

2 data source(s) 24 fields

Data Sources (2)

SourceAliasJoin Type
I_Datefunction _Datefunction from
dd07t d inner

Associations (1)

CardinalityTargetAliasCondition
[1] I_DateFunctionValue _DateFunctionVal $projection.DateFunction = _DateFunctionVal.DateFunction and _DateFunctionVal.DateFunctionValidityDate = $session.system_date

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CDATEFNC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Date Functions view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY DateFunction DateFunction
DateFunctionType DateFunctionType
DateFunctionGranularity DateFunctionGranularity
DateFunctionCalendarType DateFunctionCalendarType
DateFunctionStartPoint DateFunctionStartPoint
DateFunctionStartOffsetValue DateFunctionStartOffsetValue
DateFuncStartRelativeOffset DateFuncStartRelativeOffset
DateFunctionStartOffsetUnit DateFunctionStartOffsetUnit
DateFunctionStartRelOffsetUnit DateFunctionStartRelOffsetUnit
DateFunctionStartYearOffset DateFunctionStartYearOffset
DateFunctionStartFixedDate DateFunctionStartFixedDate
DateFunctionEndPoint DateFunctionEndPoint
DateFunctionEndOffsetValue DateFunctionEndOffsetValue
DateFunctionEndRelativeOffset DateFunctionEndRelativeOffset
DateFunctionEndOffsetUnit DateFunctionEndOffsetUnit
DateFunctionEndRelOffsetUnit DateFunctionEndRelOffsetUnit
DateFunctionEndYearOffset DateFunctionEndYearOffset
DateFunctionEndFixedDate DateFunctionEndFixedDate
DateFunctionName
DateFunctionDescription
_DateFunctionText _DateFunctionText
DateFunctionStartDate _DateFunctionVal DateFunctionStartDate
DateFunctionEndDate _DateFunctionVal DateFunctionEndDate
DateFunctionTypeName 
@AbapCatalog.sqlViewName: 'CDATEFNC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Date Functions'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION 
define view C_DateFunction as select from I_Datefunction as _Datefunction
inner join dd07t as d on d.domvalue_l = _Datefunction.DateFunctionType and d.domname = 'DATEFUNCTIONTYPE' and d.ddlanguage = $session.system_language
association [1] to I_DateFunctionValue as _DateFunctionVal
        on $projection.DateFunction = _DateFunctionVal.DateFunction and _DateFunctionVal.DateFunctionValidityDate = $session.system_date

{
    //I_Datefunction 

    key DateFunction, 
    DateFunctionType, 
    DateFunctionGranularity, 
    DateFunctionCalendarType, 
    DateFunctionStartPoint, 
    DateFunctionStartOffsetValue, 
    DateFuncStartRelativeOffset, 
    DateFunctionStartOffsetUnit, 
    DateFunctionStartRelOffsetUnit, 
    DateFunctionStartYearOffset, 
    DateFunctionStartFixedDate, 
    DateFunctionEndPoint, 
    DateFunctionEndOffsetValue, 
    DateFunctionEndRelativeOffset, 
    DateFunctionEndOffsetUnit, 
    DateFunctionEndRelOffsetUnit, 
    DateFunctionEndYearOffset, 
    DateFunctionEndFixedDate, 
    _DateFunctionText[1: Language = $session.system_language].DateFunctionName,
    _DateFunctionText[1: Language = $session.system_language].DateFunctionDescription,
    /* Associations */ 
    //I_Datefunction 

    _DateFunctionText,
    _DateFunctionVal.DateFunctionStartDate,
    _DateFunctionVal.DateFunctionEndDate,
    cast( d.ddtext as datefunctiontypedesc ) as DateFunctionTypeName
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DATEFUNCTION",
"I_DATEFUNCTIONTEXT",
"I_DATEFUNCTIONVALUE",
"DD07T"
],
"ASSOCIATED":
[
"I_DATEFUNCTIONTEXT",
"I_DATEFUNCTIONVALUE"
],
"BASE":
[
"I_DATEFUNCTION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More