/UCOM/I_EPROFVAL30

DDL: /UCOM/I_EPROFVAL30 Type: view_entity BASIC

Profile Values in 30 Minute Intervals

/UCOM/I_EPROFVAL30 is a Basic CDS View that provides data about "Profile Values in 30 Minute Intervals" in SAP S/4HANA. It reads from 1 data source (eprofval30) and exposes 50 fields with key fields EdmProfile, Valueday.

Data Sources (1)

SourceAliasJoin Type
eprofval30 eprofval30 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Profile Values in 30 Minute Intervals view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY EdmProfile profile WBS sched. prof
KEY Valueday valueday Day
val0000 val0000 Profile val.
val0030 val0030 Profile val.
val0100 val0100 Profile val.
val0130 val0130 Profile val.
val0200 val0200 Profile val.
val0230 val0230 Profile val.
val0300 val0300 Profile val.
val0330 val0330 Profile val.
val0400 val0400 Profile val.
val0430 val0430 Profile val.
val0500 val0500 Profile val.
val0530 val0530 Profile val.
val0600 val0600 Profile val.
val0630 val0630 Profile val.
val0700 val0700 Profile val.
val0730 val0730 Profile val.
val0800 val0800 Profile val.
val0830 val0830 Profile val.
val0900 val0900 Profile val.
val0930 val0930 Profile val.
val1000 val1000 Profile val.
val1030 val1030 Profile val.
val1100 val1100 Profile val.
val1130 val1130 Profile val.
val1200 val1200 Profile val.
val1230 val1230 Profile val.
val1300 val1300 Profile val.
val1330 val1330 Profile val.
val1400 val1400 Profile val.
val1430 val1430 Profile val.
val1500 val1500 Profile val.
val1530 val1530 Profile val.
val1600 val1600 Profile val.
val1630 val1630 Profile val.
val1700 val1700 Profile val.
val1730 val1730 Profile val.
val1800 val1800 Profile val.
val1830 val1830 Profile val.
val1900 val1900 Profile val.
val1930 val1930 Profile val.
val2000 val2000 Profile val.
val2030 val2030 Profile val.
val2100 val2100 Profile val.
val2130 val2130 Profile val.
val2200 val2200 Profile val.
val2230 val2230 Profile val.
val2300 val2300 Profile val.
val2330 val2330 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_EPROFVAL30.
-- 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_EPROFVAL30 AS
SELECT
  profile AS EdmProfile,
  Valueday,
  val0000,
  val0030,
  val0100,
  val0130,
  val0200,
  val0230,
  val0300,
  val0330,
  val0400,
  val0430,
  val0500,
  val0530,
  val0600,
  val0630,
  val0700,
  val0730,
  val0800,
  val0830,
  val0900,
  val0930,
  val1000,
  val1030,
  val1100,
  val1130,
  val1200,
  val1230,
  val1300,
  val1330,
  val1400,
  val1430,
  val1500,
  val1530,
  val1600,
  val1630,
  val1700,
  val1730,
  val1800,
  val1830,
  val1900,
  val1930,
  val2000,
  val2030,
  val2100,
  val2130,
  val2200,
  val2230,
  val2300,
  val2330
FROM eprofval30
;