/UCOM/I_PROFVAL60INTERVALSUTC

DDL: /UCOM/I_PROFVAL60INTERVALSUTC SQL: /UCOM/IPROFV60I Type: view_entity COMPOSITE
14 Fields 4 Data Sources

Profile Value Intervals 60 UTC for CET

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

Data Sources (4)

SourceAliasJoin Type
/UCOM/I_EPROFVAL60 _ProfValues from
/UCOM/I_EPROFVAL60 /UCOM/I_EPROFVAL60 union_all
/UCOM/I_EPROFVAL60 /UCOM/I_EPROFVAL60 union_all
/UCOM/I_EPROFVAL60 /UCOM/I_EPROFVAL60 union_all

Annotations (7)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY EdmProfile /UCOM/I_EPROFVAL60 EdmProfile WBS sched. prof
KEY Valueday Valueday Day
KEY TimeFrom
KEY TimeTo
KEY Valueday Valueday Day
KEY TimeFrom
KEY TimeTo
KEY Valueday Valueday Day
KEY TimeFrom
KEY TimeTo
KEY Valueday Valueday Day
KEY TimeFrom
KEY TimeTo
Value Val2300 Profile val.

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_PROFVAL60INTERVALSUTC.
-- 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/IPROFV60I

CREATE VIEW /UCOM/I_PROFVAL60INTERVALSUTC AS
SELECT
  _ProfValues.EdmProfile AS EdmProfile,
  Valueday,
  cast('000000' as abap.tims) AS TimeFrom,
  cast('050000' as abap.tims) AS TimeTo,
  Val2300 AS Value
FROM /UCOM/I_EPROFVAL60 AS _ProfValues
-- UNION ALL with additional select branch(es): /UCOM/I_EPROFVAL60
;

Learn More