I_DATEFUNCTION
Date Function
I_DATEFUNCTION is a CDS View in S/4HANA. Date Function. It contains 1 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_DateFunction | view | from | CONSUMPTION | Date Functions |
| I_FiscalDateFunction | view | from | BASIC | Fiscal Date Function |
| I_FiscalDateFunctionText | view | inner | BASIC | Fiscal Date Function Text |
| I_FsclDateFuncRangeFiscalValue | view_entity | inner | COMPOSITE | Fiscal Time Ranges for Range of Fiscal Date Function |
| I_FsclDateFuncRangeForLedger | view_entity | inner | COMPOSITE | Fiscal Date Function for Ledger |
| P_GregorianCalDateFunction | view | from | CONSUMPTION | All Date Functions along with calculated dates |
| P_LastDayOfFsclDteFunction | view | from | BASIC | Last day of fiscal date function |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DateFunction | DateFunction | 2 |
@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
}