I_UtilsRegTmeSersAllocation

DDL: I_UTILSREGTMESERSALLOCATION Type: view_entity BASIC
19 Fields 1 Data Sources 5 Associations

Register time series allocation

I_UtilsRegTmeSersAllocation (Basic)

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

UtilsRegTmeSersAllocation · Utilities

I_UtilsRegTmeSersAllocation is a Basic CDS View that provides data about "Register time series allocation" in SAP S/4HANA. It reads from 1 data source (eprofass) and exposes 19 fields with key fields UtilitiesLogicalRegisterNumber, UtilsTmeSersAllocationRole, UtilsTmeSersAllocValdtyEndDte, UtilsTmeSersAllocValdtyEndTme, UtilsTmeSersAllocationNumber. It has 5 associations to related views.

SAP Help Documentation

CategoryEnergy Data Management
Purpose
This CDS view retrieves data for the utilities register time series allocation.

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: E_LOG_REG (Authorization Object for Logical Registers)

Structure
Important Fields Important fields in this view include the following: Field Name Description UtilitiesLogicalRegisterNumber Logical register number UtilsTmeSersAllocationRole Time Series Allocation Role UtilsTmeSersAllocValdtyEndDte To-Date UtilsTmeSersAllocValdtyEndTme To-Time UtilsTmeSersAllocationNumber Consecutive Number of Time Series Allocation per Role UtilsTmeSersAllocValdtyStrtDte From-Date UtilsTmeSersAllocValdtyStrtTme From-time UtilitiesTimeSeries Identifier for Utilities Time Series UtilsTmeSersAllocRoleCntxtCat Context Category for Time Series Allocation Role UtilsTmeSersAllocRoleContext Context for Time Series Allocation Roles UtilsTmeSersAllocCreationDate Record Creation Date UtilsTmeSersAllocCreatedByUser Name of Person Responsible for Creating the Object UtilsTmeSersAllocChangeDate Last Changed On UtilsTmeSersAllocChangedByUser Name of Person Who Changed Object

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in delta mode as well as in full mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-MD
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageUtilities for SAP S/4HANA

Documentation

Data Sources (1)

SourceAliasJoin Type
eprofass eprofass from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_UtilsTmeSersAllocRole _UtilsTmeSersAllocRole $projection.UtilsTmeSersAllocationRole = _UtilsTmeSersAllocRole.UtilsTmeSersAllocationRole
[1..1] I_UtilitiesTimeSeriesHeader _UtilitiesTimeSeriesHeader $projection.UtilitiesTimeSeries = _UtilitiesTimeSeriesHeader.UtilitiesTimeSeries
[1..1] I_UtilsTmeSersAllocCntxtCat _UtilsTmeSersAllocCntxtCat $projection.UtilsTmeSersAllocRoleCntxtCat = _UtilsTmeSersAllocCntxtCat.UtilsTmeSersAllocRoleCntxtCat
[1..1] I_User _CreatedByUser $projection.UtilsTmeSersAllocCreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.UtilsTmeSersAllocChangedByUser = _LastChangedByUser.UserID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Register time series allocation view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name UtilsRegTmeSersAllocation view
ObjectModel.compositionRoot true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesLogicalRegisterNumber logikzw Logical register number
KEY UtilsTmeSersAllocationRole profrole Profile allocation role
KEY UtilsTmeSersAllocValdtyEndDte dateto Valid-To Date
KEY UtilsTmeSersAllocValdtyEndTme timeto Valid-To Time
KEY UtilsTmeSersAllocationNumber roleno Consecutive number of profile allocation per role
UtilsTmeSersAllocValdtyStrtDte datefrom Valid From
UtilsTmeSersAllocValdtyStrtTme timefrom Time from
UtilitiesTimeSeries profile Number of EDM Profile
UtilsTmeSersAllocRoleCntxtCat contextcategory Context Category for Profile Allocation Role
UtilsTmeSersAllocRoleContext profrolecontext Context for Profile Allocation
UtilsTmeSersAllocCreationDate erdat Record Created On
UtilsTmeSersAllocCreatedByUser ernam Name of Person Responsible for Creating the Object
UtilsTmeSersAllocChangeDate aedat Last Changed On
UtilsTmeSersAllocChangedByUser aenam Name of Person Who Changed Object
_UtilsTmeSersAllocRole _UtilsTmeSersAllocRole
_UtilitiesTimeSeriesHeader _UtilitiesTimeSeriesHeader
_UtilsTmeSersAllocCntxtCat _UtilsTmeSersAllocCntxtCat
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_UtilsRegTmeSersAllocation.
-- 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_UtilsRegTmeSersAllocation AS
SELECT
  logikzw AS UtilitiesLogicalRegisterNumber,
  profrole AS UtilsTmeSersAllocationRole,
  dateto AS UtilsTmeSersAllocValdtyEndDte,
  timeto AS UtilsTmeSersAllocValdtyEndTme,
  roleno AS UtilsTmeSersAllocationNumber,
  datefrom AS UtilsTmeSersAllocValdtyStrtDte,
  timefrom AS UtilsTmeSersAllocValdtyStrtTme,
  profile AS UtilitiesTimeSeries,
  contextcategory AS UtilsTmeSersAllocRoleCntxtCat,
  profrolecontext AS UtilsTmeSersAllocRoleContext,
  erdat AS UtilsTmeSersAllocCreationDate,
  ernam AS UtilsTmeSersAllocCreatedByUser,
  aedat AS UtilsTmeSersAllocChangeDate,
  aenam AS UtilsTmeSersAllocChangedByUser
FROM eprofass
LEFT OUTER JOIN I_UtilsTmeSersAllocRole AS _UtilsTmeSersAllocRole ON UtilsTmeSersAllocationRole = _UtilsTmeSersAllocRole.UtilsTmeSersAllocationRole  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesTimeSeriesHeader AS _UtilitiesTimeSeriesHeader ON UtilitiesTimeSeries = _UtilitiesTimeSeriesHeader.UtilitiesTimeSeries  -- association [1..1]
LEFT OUTER JOIN I_UtilsTmeSersAllocCntxtCat AS _UtilsTmeSersAllocCntxtCat ON UtilsTmeSersAllocRoleCntxtCat = _UtilsTmeSersAllocCntxtCat.UtilsTmeSersAllocRoleCntxtCat  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON UtilsTmeSersAllocCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON UtilsTmeSersAllocChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;

Learn More