I_Datefunction

DDL: I_DATEFUNCTION SQL: IDATEFNC Type: view BASIC
20 Fields 1 Data Sources 1 Associations

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.

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 WorklistID
ABAPLanguageVersion abap_language_version Language Version
DateFunctionType type Worklist Type
DateFunctionGranularity granularity Granularity
DateFunctionCalendarType calendartype Calendar Type
DateFunctionStartPoint startpoint Start Point
DateFunctionStartOffsetValue startoffset Start Offset Value
DateFuncStartRelativeOffset startrelativeoffset Start Relative Offse
DateFunctionStartOffsetUnit startoffsetunit Start Offset Unit
DateFunctionStartRelOffsetUnit startrelativeoffsetunit Start RelOffset Unit
DateFunctionStartYearOffset startyearoffset Start Year Offset
DateFunctionStartFixedDate startfixeddate Fixed Date
DateFunctionEndPoint endpoint Start Point
DateFunctionEndOffsetValue endoffset Start Offset Value
DateFunctionEndRelativeOffset endrelativeoffset Start Relative Offse
DateFunctionEndOffsetUnit endoffsetunit Start Offset Unit
DateFunctionEndRelOffsetUnit endrelativeoffsetunit End Rel Offset Unit
DateFunctionEndYearOffset endyearoffset Start Year Offset
DateFunctionEndFixedDate endfixeddate Fixed Date
_DateFunctionText _DateFunctionText

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_Datefunction.
-- 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: IDATEFNC

CREATE VIEW I_Datefunction AS
SELECT
  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
FROM datefunction
LEFT OUTER JOIN I_Datefunctiontext AS _DateFunctionText ON DateFunction = _DateFunctionText.DateFunction  -- association [0..*]
;

Learn More