I_UtilitiesTimeSeriesType

DDL: I_UTILITIESTIMESERIESTYPE Type: view_entity BASIC
4 Fields 1 Data Sources 2 Associations

Time series type

I_UtilitiesTimeSeriesType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

UtilsTimeSeriesType · Utilities

I_UtilitiesTimeSeriesType is a Basic CDS View (Dimension) that provides data about "Time series type" in SAP S/4HANA. It reads from 1 data source (eproftype) and exposes 4 fields with key field UtilitiesTimeSeriesType. It has 2 associations to related views.

SAP Help Documentation

CategoryEnergy Data Management
Data CategoryDimension
StatusC1
Purpose
This CDS view provides data for the time series type.

Prerequisites
Authorizations Not applicable.

Structure
Important fields in this view include the following: Field Name Description UtilitiesTimeSeriesType Time series type UtilitiesTimeSeriesCategory Time series category

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-EDM
CapabilitiesData Source in SQL Select, Analytical Dimension, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageUtilities for SAP S/4HANA
Description <p>This CDS view provides data for the time series type.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
eproftype eproftype from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_UtilitiesTimeSeriesTypeText _Text $projection.UtilitiesTimeSeriesType = _Text.UtilitiesTimeSeriesType
[0..1] I_UtilitiesTimeSeriesCategory _UtilitiesTimeSeriesCategory $projection.UtilitiesTimeSeriesCategory = _UtilitiesTimeSeriesCategory.UtilitiesTimeSeriesCategory

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Time series type view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey UtilitiesTimeSeriesType view
ObjectModel.sapObjectNodeType.name UtilsTimeSeriesType view
ObjectModel.compositionRoot true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesTimeSeriesType Utilities Time Series Type
UtilitiesTimeSeriesCategory Time Series Category
_Text _Text
_UtilitiesTimeSeriesCategory _UtilitiesTimeSeriesCategory

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_UtilitiesTimeSeriesType.
-- 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_UtilitiesTimeSeriesType AS
SELECT
  cast(proftype as e_time_series_type_vdm ) AS UtilitiesTimeSeriesType,
  cast(profcategory as e_time_series_category_vdm ) AS UtilitiesTimeSeriesCategory
FROM eproftype
LEFT OUTER JOIN I_UtilitiesTimeSeriesTypeText AS _Text ON UtilitiesTimeSeriesType = _Text.UtilitiesTimeSeriesType  -- association [0..*]
LEFT OUTER JOIN I_UtilitiesTimeSeriesCategory AS _UtilitiesTimeSeriesCategory ON UtilitiesTimeSeriesCategory = _UtilitiesTimeSeriesCategory.UtilitiesTimeSeriesCategory  -- association [0..1]
;

Learn More