CORE_DATEFUNCTION

DDL: CORE_DATEFUNCTION SQL: COREDATEFUNC Type: view Package: VDM_CAL
11 Fields 1 Data Sources 2 Associations

Get Details of all Date Functions

CORE_DATEFUNCTION is a CDS View that provides data about "Get Details of all Date Functions" in SAP S/4HANA. It reads from 1 data source (datefunction) and exposes 11 fields with key field id. It has 2 associations to related views. Part of development package VDM_CAL.

Data Sources (1)

SourceAliasJoin Type
datefunction datefunction from

Associations (2)

CardinalityTargetAliasCondition
[1..*] CORE_DATEFUNCTION_TEXT _Text datefunction.id = _Text.id
[1] DATEFUNCTION_SIMULATE_QUERY _SimulatedTimePeriod datefunction.id = _SimulatedTimePeriod.id

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName COREDATEFUNC view
EndUserText.label Get Details of all Date Functions view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
type type Worklist Type
granularity granularity Granularity
calendartype calendartype Calendar Type
startoffset startoffset Start Offset Value
startpoint startpoint Start Point
endfixeddate endfixeddate Fixed Date
endoffset endoffset Start Offset Value
endpoint endpoint Start Point
_Text _Text
_SimulatedTimePeriod _SimulatedTimePeriod

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 CORE_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: COREDATEFUNC

CREATE VIEW CORE_DATEFUNCTION AS
SELECT
  id,
  type,
  granularity,
  calendartype,
  startoffset,
  startpoint,
  endfixeddate,
  endoffset,
  endpoint
FROM datefunction
LEFT OUTER JOIN CORE_DATEFUNCTION_TEXT AS _Text ON datefunction.id = _Text.id  -- association [1..*]
LEFT OUTER JOIN DATEFUNCTION_SIMULATE_QUERY AS _SimulatedTimePeriod ON datefunction.id = _SimulatedTimePeriod.id  -- association [1]
;

Learn More