CORE_DATEFUNCTION

DDL: CORE_DATEFUNCTION SQL: COREDATEFUNC Type: view

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.

1 data source(s) 11 fields

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
type type
granularity granularity
calendartype calendartype
startoffset startoffset
startpoint startpoint
endfixeddate endfixeddate
endoffset endoffset
endpoint endpoint
_Text _Text
_SimulatedTimePeriod _SimulatedTimePeriod 
@AbapCatalog.sqlViewName: 'COREDATEFUNC'
@EndUserText.label: 'Get Details of all Date Functions'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

// CDS Test Double - GTD_CORE_DATEFUNCTION


define view CORE_DATEFUNCTION
  as select from datefunction

  association [1..*] to CORE_DATEFUNCTION_TEXT      as _Text                on datefunction.id = _Text.id

  association [1]    to DATEFUNCTION_SIMULATE_QUERY as _SimulatedTimePeriod on datefunction.id = _SimulatedTimePeriod.id
{
  key id,
      /*
       * Object namespace - 1 (SAP content), 2 (Customer content).
       * 1) ABAP Language Version values '2' (ABAP for Key Users) and '5' (ABAP for Cloud Development) are for customer content.
       * 2) Use older logic as fallback and check the ID prefixes if objects are custom ones (YY*, YZ* and Z*).
       * 3) For Standard ABAP Language Version (' ') and for null cases, mark as predefined.
       */
      case when abap_language_version = '2' or abap_language_version = '5' then 2
           when id like 'YY%' or id like 'YZ%' or id like 'Z%' then 2
           else 1
      end as datefunctiontype,
      type,
      granularity,
      calendartype,
      startfixeddate,
      startoffset,
      startoffsetunit,
      startrelativeoffsetunit,
      startpoint,
      startrelativeoffset,
      startyearoffset,
      endfixeddate,
      endoffset,
      endoffsetunit,
      endrelativeoffsetunit,
      endpoint,
      endrelativeoffset,
      endyearoffset,
      /* Associations */
      _Text,
      _SimulatedTimePeriod
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DATEFUNCTION"
],
"ASSOCIATED":
[
"CORE_DATEFUNCTION_TEXT",
"DATEFUNCTION_SIMULATE_QUERY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More