demo_cds_time_functions

DDL: DEMO_CDS_TIME_FUNCTIONS SQL: DEMO_CDS_TIMFNC Type: view
3 Fields 1 Data Sources

demo_cds_time_functions is a CDS View in SAP S/4HANA. It reads from 1 data source (demo_expressions) and exposes 3 fields with key field id.

Data Sources (1)

SourceAliasJoin Type
demo_expressions demo_expressions from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName DEMO_CDS_TIMFNC view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
time1 tims1
valid1

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 demo_cds_time_functions.
-- 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: DEMO_CDS_TIMFNC

CREATE VIEW demo_cds_time_functions AS
SELECT
  id,
  tims1 AS time1,
  tims_is_valid(tims1) AS valid1
FROM demo_expressions
;

Learn More