/UCOM/I_ProfVal15TransposeUTC

DDL: /UCOM/I_PROFVAL15TRANSPOSEUTC SQL: /UCOM/IPROFVTRNU Type: view_entity COMPOSITE
194 Fields 96 Data Sources

Profile Values 15 Minute transpose UTC

/UCOM/I_ProfVal15TransposeUTC is a Composite CDS View that provides data about "Profile Values 15 Minute transpose UTC" in SAP S/4HANA. It reads from 96 data sources and exposes 194 fields with key fields EdmProfile, Valueday, Time, Valueday, Time.

Data Sources (96)

SourceAliasJoin Type
/UCOM/I_EPROFVAL15 _ProfValues from
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/UCOM/I_EPROFVAL15 /UCOM/I_EPROFVAL15 union_all
/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 Values 15 Minute transpose UTC 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 (194)

KeyFieldSource TableSource FieldDescription
KEY EdmProfile /UCOM/I_EPROFVAL15 EdmProfile WBS sched. prof
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
KEY Valueday Valueday Day
KEY Time
Value Val2345 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_ProfVal15TransposeUTC.
-- 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/IPROFVTRNU

CREATE VIEW /UCOM/I_ProfVal15TransposeUTC AS
SELECT
  _ProfValues.EdmProfile AS EdmProfile,
  Valueday,
  cast('000000' as abap.tims) AS Time,
  Val2345 AS Value
FROM /UCOM/I_EPROFVAL15 AS _ProfValues
-- UNION ALL with additional select branch(es): /UCOM/I_EPROFVAL15
;

Learn More