/UCOM/I_ProfVal15IntervalsUTC

DDL: /UCOM/I_PROFVAL15INTERVALSUTC SQL: /UCOM/IPROFVUTCI Type: view_entity COMPOSITE

Profile Value Intervals 15 UTC for CET

/UCOM/I_ProfVal15IntervalsUTC is a Composite CDS View that provides data about "Profile Value Intervals 15 UTC for CET" in SAP S/4HANA. It reads from 3 data sources (/UCOM/I_EPROFVAL15, /UCOM/I_EPROFVAL15, /UCOM/I_EPROFVAL15) and exposes 12 fields with key fields EdmProfile, Valueday, ValuedayCET, TimeFrom, TimeTo.

Data Sources (3)

SourceAliasJoin Type
/UCOM/I_EPROFVAL15 _ProfValues from
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Profile Value Intervals 15 UTC for CET view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EdmProfile /UCOM/I_EPROFVAL15 EdmProfile WBS sched. prof
KEY Valueday Valueday Day
KEY ValuedayCET Valueday Day
KEY TimeFrom
KEY TimeTo
KEY Valueday Valueday Day
KEY TimeFrom
KEY TimeTo
KEY Valueday Valueday Day
KEY TimeFrom
KEY TimeTo
Value

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 /UCOM/I_ProfVal15IntervalsUTC.
-- 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: /UCOM/IPROFVUTCI

CREATE VIEW /UCOM/I_ProfVal15IntervalsUTC AS
SELECT
  _ProfValues.EdmProfile AS EdmProfile,
  Valueday,
  Valueday AS ValuedayCET,
  cast('000000' as abap.tims) AS TimeFrom,
  cast('214500' as abap.tims) AS TimeTo,
  Val2300 + Val2315 + Val2330 + Val2345 AS Value
FROM /UCOM/I_EPROFVAL15 AS _ProfValues
-- UNION ALL with additional select branch(es): /UCOM/I_EPROFVAL15
;