C_UtilsTmeSersDayIntvlValDP

DDL: C_UTILSTMESERSDAYINTVLVALDP Type: view_entity CONSUMPTION

DP for time series day interval val

C_UtilsTmeSersDayIntvlValDP is a Consumption CDS View that provides data about "DP for time series day interval val" in SAP S/4HANA. It reads from 1 data source (I_UtilsTmeSersDayIntvlVal) and exposes 35 fields with key fields UtilitiesTimeSeries, UtilitiesTimeSeriesValueDate.

Data Sources (1)

SourceAliasJoin Type
I_UtilsTmeSersDayIntvlVal I_UtilsTmeSersDayIntvlVal from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label DP for time series day interval val view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name UtilsTmeSersDayIntvlVal view
DataIntegration.deltaReplication.intended true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesTimeSeries UtilitiesTimeSeries
KEY UtilitiesTimeSeriesValueDate UtilitiesTimeSeriesValueDate
UtilsTimeSeriesOnDay1Value UtilsTimeSeriesOnDay1Value
UtilsTimeSeriesOnDay2Value UtilsTimeSeriesOnDay2Value
UtilsTimeSeriesOnDay3Value UtilsTimeSeriesOnDay3Value
UtilsTimeSeriesOnDay4Value UtilsTimeSeriesOnDay4Value
UtilsTimeSeriesOnDay5Value UtilsTimeSeriesOnDay5Value
UtilsTimeSeriesOnDay6Value UtilsTimeSeriesOnDay6Value
UtilsTimeSeriesOnDay7Value UtilsTimeSeriesOnDay7Value
UtilsTimeSeriesOnDay8Value UtilsTimeSeriesOnDay8Value
UtilsTimeSeriesOnDay9Value UtilsTimeSeriesOnDay9Value
UtilsTimeSeriesOnDay10Value UtilsTimeSeriesOnDay10Value
UtilsTimeSeriesOnDay11Value UtilsTimeSeriesOnDay11Value
UtilsTimeSeriesOnDay12Value UtilsTimeSeriesOnDay12Value
UtilsTimeSeriesOnDay13Value UtilsTimeSeriesOnDay13Value
UtilsTimeSeriesOnDay14Value UtilsTimeSeriesOnDay14Value
UtilsTimeSeriesOnDay15Value UtilsTimeSeriesOnDay15Value
UtilsTimeSeriesOnDay16Value UtilsTimeSeriesOnDay16Value
UtilsTimeSeriesOnDay17Value UtilsTimeSeriesOnDay17Value
UtilsTimeSeriesOnDay18Value UtilsTimeSeriesOnDay18Value
UtilsTimeSeriesOnDay19Value UtilsTimeSeriesOnDay19Value
UtilsTimeSeriesOnDay20Value UtilsTimeSeriesOnDay20Value
UtilsTimeSeriesOnDay21Value UtilsTimeSeriesOnDay21Value
UtilsTimeSeriesOnDay22Value UtilsTimeSeriesOnDay22Value
UtilsTimeSeriesOnDay23Value UtilsTimeSeriesOnDay23Value
UtilsTimeSeriesOnDay24Value UtilsTimeSeriesOnDay24Value
UtilsTimeSeriesOnDay25Value UtilsTimeSeriesOnDay25Value
UtilsTimeSeriesOnDay26Value UtilsTimeSeriesOnDay26Value
UtilsTimeSeriesOnDay27Value UtilsTimeSeriesOnDay27Value
UtilsTimeSeriesOnDay28Value UtilsTimeSeriesOnDay28Value
UtilsTimeSeriesOnDay29Value UtilsTimeSeriesOnDay29Value
UtilsTimeSeriesOnDay30Value UtilsTimeSeriesOnDay30Value
UtilsTimeSeriesOnDay31Value UtilsTimeSeriesOnDay31Value
_UtilitiesTimeSeriesHeader _UtilitiesTimeSeriesHeader
_UtilitiesTimeSeriesHeaderDP _UtilitiesTimeSeriesHeaderDP

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 C_UtilsTmeSersDayIntvlValDP.
-- 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 C_UtilsTmeSersDayIntvlValDP AS
SELECT
  UtilitiesTimeSeries,
  UtilitiesTimeSeriesValueDate,
  UtilsTimeSeriesOnDay1Value,
  UtilsTimeSeriesOnDay2Value,
  UtilsTimeSeriesOnDay3Value,
  UtilsTimeSeriesOnDay4Value,
  UtilsTimeSeriesOnDay5Value,
  UtilsTimeSeriesOnDay6Value,
  UtilsTimeSeriesOnDay7Value,
  UtilsTimeSeriesOnDay8Value,
  UtilsTimeSeriesOnDay9Value,
  UtilsTimeSeriesOnDay10Value,
  UtilsTimeSeriesOnDay11Value,
  UtilsTimeSeriesOnDay12Value,
  UtilsTimeSeriesOnDay13Value,
  UtilsTimeSeriesOnDay14Value,
  UtilsTimeSeriesOnDay15Value,
  UtilsTimeSeriesOnDay16Value,
  UtilsTimeSeriesOnDay17Value,
  UtilsTimeSeriesOnDay18Value,
  UtilsTimeSeriesOnDay19Value,
  UtilsTimeSeriesOnDay20Value,
  UtilsTimeSeriesOnDay21Value,
  UtilsTimeSeriesOnDay22Value,
  UtilsTimeSeriesOnDay23Value,
  UtilsTimeSeriesOnDay24Value,
  UtilsTimeSeriesOnDay25Value,
  UtilsTimeSeriesOnDay26Value,
  UtilsTimeSeriesOnDay27Value,
  UtilsTimeSeriesOnDay28Value,
  UtilsTimeSeriesOnDay29Value,
  UtilsTimeSeriesOnDay30Value,
  UtilsTimeSeriesOnDay31Value
FROM I_UtilsTmeSersDayIntvlVal
;