C_GregorianCalDateFuncVH

DDL: C_GREGORIANCALDATEFUNCVH SQL: CGCALDFVH Type: view CONSUMPTION
5 Fields 1 Data Sources

Value Help for Gregorian Calendar Date Functions

C_GregorianCalDateFuncVH (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_GregorianCalDateFuncVH is a Consumption CDS View that provides data about "Value Help for Gregorian Calendar Date Functions" in SAP S/4HANA. It reads from 1 data source (I_DateFunctionValue) and exposes 5 fields with key field DateFunction.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentCA-GTF-DF
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_DateFunctionValue I_DateFunctionValue from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CGCALDFVH view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Value Help for Gregorian Calendar Date Functions view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY DateFunction DateFunction Relative Date Function ID
DateFunctionName Date Function Name
DateFunctionDescription Date Function Description
DateFunctionStartDate DateFunctionStartDate Date Function Start Date
DateFunctionEndDate DateFunctionEndDate Date Function End Date

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 C_GregorianCalDateFuncVH.
-- 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: CGCALDFVH

CREATE VIEW C_GregorianCalDateFuncVH AS
SELECT
  DateFunction,
  _Datefunction._DateFunctionText[1: Language = $session.system_language].DateFunctionName AS DateFunctionName,
  _Datefunction._DateFunctionText[1: Language = $session.system_language].DateFunctionDescription AS DateFunctionDescription,
  DateFunctionStartDate,
  DateFunctionEndDate
FROM I_DateFunctionValue
;

Learn More