/UCOM/I_ProfVal15TimezoneConv

DDL: /UCOM/I_PROFVAL15TIMEZONECONV Type: view_entity COMPOSITE
10 Fields 1 Data Sources 1 Associations

Profile Values 15 Minute timezone conv

/UCOM/I_ProfVal15TimezoneConv is a Composite CDS View that provides data about "Profile Values 15 Minute timezone conv" in SAP S/4HANA. It reads from 1 data source (/UCOM/I_ProfVal15TransposeUTC) and exposes 10 fields with key fields EdmProfile, DayUTC. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/UCOM/I_ProfVal15TransposeUTC _ProfValues from

Associations (1)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Profile Values 15 Minute timezone conv view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EdmProfile /UCOM/I_ProfVal15TransposeUTC EdmProfile
KEY DayUTC /UCOM/I_ProfVal15TransposeUTC Valueday Day
TimeUTC /UCOM/I_ProfVal15TransposeUTC Time Time Stamp
EdmObjectTimeZone _ProfileHead EdmObjectTimeZone
MeasurementUnit _ProfileHead MeasurementUnit
clientINITIALasDayTZConv
clientINITIALasTimeTZConv
ProfileValueDecimals _ProfileHead ProfileValueDecimals
Value /UCOM/I_ProfVal15TransposeUTC Value Value from table
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_ProfVal15TimezoneConv.
-- 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_ProfVal15TimezoneConv AS
SELECT
  _ProfValues.EdmProfile AS EdmProfile,
  _ProfValues.Valueday AS DayUTC,
  _ProfValues.Time AS TimeUTC,
  _ProfileHead.EdmObjectTimeZone AS EdmObjectTimeZone,
  _ProfileHead.MeasurementUnit AS MeasurementUnit,
  tstmp_to_dats( dats_tims_to_tstmp(_ProfValues.Valueday, _ProfValues.Time, 'UTC', $session.client, 'INITIAL'), _ProfileHead.EdmObjectTimeZone, $session.client, 'INITIAL' ) as DayTZConv AS clientINITIALasDayTZConv,
  tstmp_to_tims( dats_tims_to_tstmp(_ProfValues.Valueday, _ProfValues.Time, 'UTC', $session.client, 'INITIAL'), _ProfileHead.EdmObjectTimeZone, $session.client, 'INITIAL' ) as TimeTZConv AS clientINITIALasTimeTZConv,
  _ProfileHead.ProfileValueDecimals AS ProfileValueDecimals,
  _ProfValues.Value AS Value,
  case cast(_ProfileHead.ProfileValueDecimals as abap.int1 ) when 1 then cast( _ProfValues.Value as abap.fltp ) / 10.0 when 2 then cast( _ProfValues.Value as abap.fltp ) / 100.0 when 3 then cast( _ProfValues.Value as abap.fltp ) / 1000.0 when 4 then cast( _ProfValues.Value as abap.fltp ) / 10000.0 when 5 then cast( _ProfValues.Value as abap.fltp ) / 100000.0 when 6 then cast( _ProfValues.Value as abap.fltp ) / 1000000.0 when 7 then cast( _ProfValues.Value as abap.fltp ) / 10000000.0 when 8 then cast( _ProfValues.Value as abap.fltp ) / 100000000.0 when 9 then cast( _ProfValues.Value as abap.fltp ) / 1000000000.0 when 10 then cast( _ProfValues.Value as abap.fltp ) / 10000000000.0 else cast( _ProfValues.Value as abap.fltp ) end as ValueConvert AS fltpendasValueConvert
FROM /UCOM/I_ProfVal15TransposeUTC AS _ProfValues
LEFT OUTER JOIN /UCOM/i_EPROFHEAD AS _ProfileHead ON _ProfValues.EdmProfile = _ProfileHead.EdmProfile  -- association [1..1]
;

Learn More