CORE_DATEFUNCTION_TEXT

DDL: CORE_DATEFUNCTION_TEXT SQL: COREDATEFUNCTEXT Type: view
5 Fields 2 Data Sources

Get name and desc of the Date Function

CORE_DATEFUNCTION_TEXT is a CDS View that provides data about "Get name and desc of the Date Function" in SAP S/4HANA. It reads from 2 data sources (Datefunction_Languages, datefunction_t) and exposes 5 fields with key fields id, language.

Data Sources (2)

SourceAliasJoin Type
Datefunction_Languages Languages left_outer
datefunction_t Texts from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName COREDATEFUNCTEXT view
EndUserText.label Get name and desc of the Date Function view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY id datefunction_t id WorklistID
KEY language datefunction_t language Report Text Language
languageISOCode
name datefunction_t name Zone name
description datefunction_t description Well Code Des.

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_TEXT.
-- 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: COREDATEFUNCTEXT

CREATE VIEW CORE_DATEFUNCTION_TEXT AS
SELECT
  Texts.id AS id,
  Texts.language AS language,
  coalesce( Languages.LanguageISOCode, Texts.language ) AS languageISOCode,
  Texts.name AS name,
  Texts.description AS description
FROM datefunction_t AS Texts
LEFT OUTER JOIN Datefunction_Languages AS Languages ON /* join condition not captured in parsed metadata */
;

Learn More