/UCOM/I_ProfVal15ExtensionUTC

DDL: /UCOM/I_PROFVAL15EXTENSIONUTC Type: view_entity COMPOSITE
9 Fields 1 Data Sources 1 Associations

Prof Value Intervals 15 UTC for CET Ext

/UCOM/I_ProfVal15ExtensionUTC is a Composite CDS View that provides data about "Prof Value Intervals 15 UTC for CET Ext" in SAP S/4HANA. It reads from 1 data source (/UCOM/I_ProfVal15IntervalsUTC) and exposes 9 fields with key fields EdmProfile, Valueday, ValuedayCET. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/UCOM/I_ProfVal15IntervalsUTC _ProfVal from

Associations (1)

CardinalityTargetAliasCondition
[1..1] /UCOM/i_EPROFHEAD _ProfileHead _ProfVal.EdmProfile = _ProfileHead.EdmProfile

Annotations (7)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EdmProfile /UCOM/I_ProfVal15IntervalsUTC EdmProfile
KEY Valueday /UCOM/I_ProfVal15IntervalsUTC Valueday Day
KEY ValuedayCET /UCOM/I_ProfVal15IntervalsUTC ValuedayCET Day
TimeFrom /UCOM/I_ProfVal15IntervalsUTC TimeFrom Time from
TimeTo /UCOM/I_ProfVal15IntervalsUTC TimeTo Valid-To Time
TimeStampFrom
TimeStampTo
MeasurementUnit _ProfileHead MeasurementUnit
fltpendasValueConvert

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_ProfVal15ExtensionUTC.
-- 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.

CREATE VIEW /UCOM/I_ProfVal15ExtensionUTC AS
SELECT
  _ProfVal.EdmProfile AS EdmProfile,
  _ProfVal.Valueday AS Valueday,
  _ProfVal.ValuedayCET AS ValuedayCET,
  _ProfVal.TimeFrom AS TimeFrom,
  _ProfVal.TimeTo AS TimeTo,
  dats_tims_to_tstmp(_ProfVal.Valueday,_ProfVal.TimeFrom,'UTC',$session.client,'INITIAL') AS TimeStampFrom,
  dats_tims_to_tstmp(_ProfVal.Valueday,_ProfVal.TimeTo,'UTC', $session.client,'INITIAL') AS TimeStampTo,
  _ProfileHead.MeasurementUnit AS MeasurementUnit,
  case _ProfileHead.ProfileValueDecimals when '01' then cast( _ProfVal.Value as abap.fltp ) / 10.0 when '02' then cast( _ProfVal.Value as abap.fltp ) / 100.0 when '03' then cast( _ProfVal.Value as abap.fltp ) / 1000.0 when '04' then cast( _ProfVal.Value as abap.fltp ) / 10000.0 when '05' then cast( _ProfVal.Value as abap.fltp ) / 100000.0 when '06' then cast( _ProfVal.Value as abap.fltp ) / 1000000.0 when '07' then cast( _ProfVal.Value as abap.fltp ) / 10000000.0 when '08' then cast( _ProfVal.Value as abap.fltp ) / 100000000.0 when '09' then cast( _ProfVal.Value as abap.fltp ) / 1000000000.0 when '10' then cast( _ProfVal.Value as abap.fltp ) / 10000000000.0 else cast( _ProfVal.Value as abap.fltp ) end as ValueConvert AS fltpendasValueConvert
FROM /UCOM/I_ProfVal15IntervalsUTC AS _ProfVal
LEFT OUTER JOIN /UCOM/i_EPROFHEAD AS _ProfileHead ON _ProfVal.EdmProfile = _ProfileHead.EdmProfile  -- association [1..1]
;

Learn More