F_GregorianCalDteFuncRngeVal

DDL: F_GREGORIANCALDTEFUNCRNGEVAL SQL: FGDFRNGVAL Type: view DERIVATION_FUNCTION

Gregorian Range Date Functions

F_GregorianCalDteFuncRngeVal is a CDS View that provides data about "Gregorian Range Date Functions" in SAP S/4HANA. It reads from 1 data source (I_DateFunctionValue) and exposes 1 field.

Data Sources (1)

SourceAliasJoin Type
I_DateFunctionValue I_DateFunctionValue from

Parameters (1)

NameTypeDefault
P_DateFunction datefunctionid

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName FGDFRNGVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey DateFunction view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #DERIVATION_FUNCTION view
ObjectModel.derivationFunction.result.type #INTERVAL view
ObjectModel.derivationFunction.result.multipleRecords false view
ObjectModel.derivationFunction.result.element DateFunctionStartDate view
ObjectModel.derivationFunction.result.elementHigh DateFunctionEndDate view
VDM.viewType #DERIVATION_FUNCTION view
EndUserText.label Gregorian Range Date Functions view

Fields (1)

KeyFieldSource TableSource FieldDescription
DateFunctionEndDate

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 F_GregorianCalDteFuncRngeVal.
-- 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: FGDFRNGVAL
-- Parameters: P_DateFunction : datefunctionid

CREATE VIEW F_GregorianCalDteFuncRngeVal AS
SELECT
  entity: { name: 'C_GregorianCalDateFuncVH', element: 'DateFunction' AS DateFunctionEndDate
FROM I_DateFunctionValue
;