C_UtilitiesTimeSeriesHeaderDP

DDL: C_UTILITIESTIMESERIESHEADERDP Type: view_entity CONSUMPTION
38 Fields 1 Data Sources 9 Associations

DP for time series header data

C_UtilitiesTimeSeriesHeaderDP is a Consumption CDS View that provides data about "DP for time series header data" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesTimeSeriesHeader) and exposes 38 fields with key field UtilitiesTimeSeries. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesTimeSeriesHeader I_UtilitiesTimeSeriesHeader from

Associations (9)

CardinalityTargetAliasCondition
[0..1] C_UtilitiesTimeSeriesTypeDP _UtilitiesTimeSeriesTypeDP $projection.UtilitiesTimeSeriesType = _UtilitiesTimeSeriesTypeDP.UtilitiesTimeSeriesType
[0..*] C_UtilsTimeSeriesHeaderTextDP _UtilsTimeSeriesHeaderTextDP
[0..*] C_UtilsTmeSers5MinsIntvlValDP _UtilsTmeSers5MinsIntvlValDP
[0..*] C_UtilsTmeSers10MinsIntvlValDP _UtilsTmeSers10MinsIntvlValDP
[0..*] C_UtilsTmeSers15MinsIntvlValDP _UtilsTmeSers15MinsIntvlValDP
[0..*] C_UtilsTmeSers30MinsIntvlValDP _UtilsTmeSers30MinsIntvlValDP
[0..*] C_UtilsTmeSers60MinsIntvlValDP _UtilsTmeSers60MinsIntvlValDP
[0..*] C_UtilsTmeSersDayIntvlValDP _UtilsTmeSersDayIntvlValDP
[0..*] C_UtilsTmeSersValueStatusDP _UtilsTmeSersValueStatusDP

Annotations (9)

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

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesTimeSeries UtilitiesTimeSeries
Division Division Internal Division ID
UtilitiesTimeSeriesType UtilitiesTimeSeriesType
UtilsTmeSersValCategory UtilsTmeSersValCategory
UtilsTmeSersValueIsCumulated UtilsTmeSersValueIsCumulated Cumulative vals
UtilsTmeSersIntvlLenCode UtilsTmeSersIntvlLenCode Interval Length
UnitOfMeasure UnitOfMeasure Unit Protected Qty
UtilsTmeSersValNmbrOfDcmlsVal UtilsTmeSersValNmbrOfDcmlsVal
UtilsTimeSeriesValueOffsetTime UtilsTimeSeriesValueOffsetTime
UtilsTmeSersConstcyChkGrp UtilsTmeSersConstcyChkGrp Cons. check grp
AuthorizationGroup AuthorizationGroup AuthorizGroup
UtilitiesTimeSeriesIsDeleted UtilitiesTimeSeriesIsDeleted End Contract
UtilitiesTimeSeriesCurrency UtilitiesTimeSeriesCurrency Transaction Currency
ReferencedUtilitiesTimeSeries ReferencedUtilitiesTimeSeries
UtilsTmeSersRplcmtValProcedGrp UtilsTmeSersRplcmtValProcedGrp RVP Group
UtilsTmeSersDayOffsetTime UtilsTmeSersDayOffsetTime Day Offset
TimeZoneID TimeZoneID Time Zone
UtilsTmeSersOriglValLoc UtilsTmeSersOriglValLoc
_Currency _Currency
_Division _Division
_Text _Text
_TimeZone _TimeZone
_UnitOfMeasure _UnitOfMeasure
_UtilitiesTimeSeriesType _UtilitiesTimeSeriesType
_UtilsTmeSersConstcyChkGrp _UtilsTmeSersConstcyChkGrp
_UtilsTmeSersIntervalLength _UtilsTmeSersIntervalLength
_UtilsTmeSersOrigValLoc _UtilsTmeSersOrigValLoc
_UtilsTmeSersRplcmtValProced _UtilsTmeSersRplcmtValProced
_UtilsTmeSersValCategory _UtilsTmeSersValCategory
_UtilsTimeSeriesHeaderTextDP _UtilsTimeSeriesHeaderTextDP
_UtilsTmeSers5MinsIntvlValDP _UtilsTmeSers5MinsIntvlValDP
_UtilsTmeSers10MinsIntvlValDP _UtilsTmeSers10MinsIntvlValDP
_UtilsTmeSers15MinsIntvlValDP _UtilsTmeSers15MinsIntvlValDP
_UtilsTmeSers30MinsIntvlValDP _UtilsTmeSers30MinsIntvlValDP
_UtilsTmeSers60MinsIntvlValDP _UtilsTmeSers60MinsIntvlValDP
_UtilsTmeSersDayIntvlValDP _UtilsTmeSersDayIntvlValDP
_UtilsTmeSersValueStatusDP _UtilsTmeSersValueStatusDP
_UtilitiesTimeSeriesTypeDP _UtilitiesTimeSeriesTypeDP

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_UtilitiesTimeSeriesHeaderDP.
-- 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_UtilitiesTimeSeriesHeaderDP AS
SELECT
  UtilitiesTimeSeries,
  Division,
  UtilitiesTimeSeriesType,
  UtilsTmeSersValCategory,
  UtilsTmeSersValueIsCumulated,
  UtilsTmeSersIntvlLenCode,
  UnitOfMeasure,
  UtilsTmeSersValNmbrOfDcmlsVal,
  UtilsTimeSeriesValueOffsetTime,
  UtilsTmeSersConstcyChkGrp,
  AuthorizationGroup,
  UtilitiesTimeSeriesIsDeleted,
  UtilitiesTimeSeriesCurrency,
  ReferencedUtilitiesTimeSeries,
  UtilsTmeSersRplcmtValProcedGrp,
  UtilsTmeSersDayOffsetTime,
  TimeZoneID,
  UtilsTmeSersOriglValLoc
FROM I_UtilitiesTimeSeriesHeader
LEFT OUTER JOIN C_UtilitiesTimeSeriesTypeDP AS _UtilitiesTimeSeriesTypeDP ON UtilitiesTimeSeriesType = _UtilitiesTimeSeriesTypeDP.UtilitiesTimeSeriesType  -- association [0..1]
LEFT OUTER JOIN C_UtilsTimeSeriesHeaderTextDP AS _UtilsTimeSeriesHeaderTextDP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_UtilsTmeSers5MinsIntvlValDP AS _UtilsTmeSers5MinsIntvlValDP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_UtilsTmeSers10MinsIntvlValDP AS _UtilsTmeSers10MinsIntvlValDP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_UtilsTmeSers15MinsIntvlValDP AS _UtilsTmeSers15MinsIntvlValDP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_UtilsTmeSers30MinsIntvlValDP AS _UtilsTmeSers30MinsIntvlValDP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_UtilsTmeSers60MinsIntvlValDP AS _UtilsTmeSers60MinsIntvlValDP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_UtilsTmeSersDayIntvlValDP AS _UtilsTmeSersDayIntvlValDP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_UtilsTmeSersValueStatusDP AS _UtilsTmeSersValueStatusDP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More