I_Datefunction

DDL: I_DATEFUNCTION SQL: IDATEFNC Type: view BASIC

Date Function

I_Datefunction is a Basic CDS View that provides data about "Date Function" in SAP S/4HANA. It reads from 1 data source (datefunction) and exposes 20 fields with key field DateFunction. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
datefunction datefunction from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_Datefunctiontext _DateFunctionText $projection.DateFunction = _DateFunctionText.DateFunction

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDATEFNC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Date Function view
ObjectModel.representativeKey DateFunction view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY DateFunction id
ABAPLanguageVersion abap_language_version
DateFunctionType type
DateFunctionGranularity granularity
DateFunctionCalendarType calendartype
DateFunctionStartPoint startpoint
DateFunctionStartOffsetValue startoffset
DateFuncStartRelativeOffset startrelativeoffset
DateFunctionStartOffsetUnit startoffsetunit
DateFunctionStartRelOffsetUnit startrelativeoffsetunit
DateFunctionStartYearOffset startyearoffset
DateFunctionStartFixedDate startfixeddate
DateFunctionEndPoint endpoint
DateFunctionEndOffsetValue endoffset
DateFunctionEndRelativeOffset endrelativeoffset
DateFunctionEndOffsetUnit endoffsetunit
DateFunctionEndRelOffsetUnit endrelativeoffsetunit
DateFunctionEndYearOffset endyearoffset
DateFunctionEndFixedDate endfixeddate
_DateFunctionText _DateFunctionText 
@AbapCatalog.sqlViewName: 'IDATEFNC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Date Function'
@ObjectModel.representativeKey: 'DateFunction'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #A
@ObjectModel.usageType.sizeCategory:  #S
@ClientHandling.algorithm: #SESSION_VARIABLE
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@VDM.viewType: #BASIC 
define view I_Datefunction as select from datefunction 
    association [0..*] to I_Datefunctiontext as _DateFunctionText
        on $projection.DateFunction = _DateFunctionText.DateFunction
{
  @ObjectModel.text.association:'_DateFunctionText'
  key id as DateFunction,
  abap_language_version as ABAPLanguageVersion, 
  type as DateFunctionType, 
  granularity as DateFunctionGranularity,
  calendartype as DateFunctionCalendarType,
  startpoint as DateFunctionStartPoint, 
  startoffset as DateFunctionStartOffsetValue, 
  startrelativeoffset as DateFuncStartRelativeOffset, 
  startoffsetunit as DateFunctionStartOffsetUnit, 
  startrelativeoffsetunit as DateFunctionStartRelOffsetUnit,
  startyearoffset as DateFunctionStartYearOffset, 
  startfixeddate as DateFunctionStartFixedDate, 
  endpoint as DateFunctionEndPoint, 
  endoffset as DateFunctionEndOffsetValue, 
  endrelativeoffset as DateFunctionEndRelativeOffset, 
  endoffsetunit as DateFunctionEndOffsetUnit, 
  endrelativeoffsetunit as DateFunctionEndRelOffsetUnit,
  endyearoffset as DateFunctionEndYearOffset, 
  endfixeddate as DateFunctionEndFixedDate,
  
  _DateFunctionText
} 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DATEFUNCTION"
],
"ASSOCIATED":
[
"I_DATEFUNCTIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More