I_UtilitiesTimeSeriesHeader

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 I_UtilitiesTimeSeriesHeader.
-- 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 I_UtilitiesTimeSeriesHeader AS
SELECT
  cast(profile as e_time_series_id_vdm ) AS UtilitiesTimeSeries,
  sparte AS Division,
  cast(proftype as e_time_series_type_vdm ) AS UtilitiesTimeSeriesType,
  cast(profvalcat as e_time_series_value_cat_vdm ) AS UtilsTmeSersValCategory,
  valuecum AS UtilsTmeSersValueIsCumulated,
  intsizeid AS UtilsTmeSersIntvlLenCode,
  mass AS UnitOfMeasure,
  cast(profdecimals as e_time_series_nbr_of_dec_vdm ) AS UtilsTmeSersValNmbrOfDcmlsVal,
  cast(profoffset as e_time_series_value_offset_vdm ) AS UtilsTimeSeriesValueOffsetTime,
  concheckgrp AS UtilsTmeSersConstcyChkGrp,
  begru AS AuthorizationGroup,
  loevm AS UtilitiesTimeSeriesIsDeleted,
  waers AS UtilitiesTimeSeriesCurrency,
  cast(ref_profile as e_refcd_time_series_id_vdm ) AS ReferencedUtilitiesTimeSeries,
  replacemethodgrp AS UtilsTmeSersRplcmtValProcedGrp,
  day_offset AS UtilsTmeSersDayOffsetTime,
  time_zone AS TimeZoneID,
  cast(mdus_located as e_time_series_val_location_vdm ) AS UtilsTmeSersOriglValLoc
FROM eprofhead
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesTimeSeriesHeaderTxt AS _Text ON UtilitiesTimeSeries = _Text.UtilitiesTimeSeries  -- association [0..*]
LEFT OUTER JOIN I_UtilitiesTimeSeriesType AS _UtilitiesTimeSeriesType ON UtilitiesTimeSeriesType = _UtilitiesTimeSeriesType.UtilitiesTimeSeriesType  -- association [0..1]
LEFT OUTER JOIN I_UtilsTmeSersValCategory AS _UtilsTmeSersValCategory ON UtilsTmeSersValCategory = _UtilsTmeSersValCategory.UtilsTmeSersValCategory  -- association [0..1]
LEFT OUTER JOIN I_UtilsTmeSersIntervalLength AS _UtilsTmeSersIntervalLength ON UtilsTmeSersIntvlLenCode = _UtilsTmeSersIntervalLength.UtilsTmeSersIntvlLenCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UtilsTmeSersConstcyChkGrp AS _UtilsTmeSersConstcyChkGrp ON UtilsTmeSersConstcyChkGrp = _UtilsTmeSersConstcyChkGrp.UtilsTmeSersConstcyChkGrp  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON UtilitiesTimeSeriesCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UtilsTmeSersRplcmtValProced AS _UtilsTmeSersRplcmtValProced ON UtilsTmeSersRplcmtValProcedGrp = _UtilsTmeSersRplcmtValProced.UtilsTmeSersRplcmtValProcedGrp  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON TimeZoneID = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_UtilsTmeSersOrigValLoc AS _UtilsTmeSersOrigValLoc ON UtilsTmeSersOriglValLoc = _UtilsTmeSersOrigValLoc.UtilsTmeSersOriglValLoc  -- association [0..1]
;