I_UtilitiesServiceDuration

DDL: I_UTILITIESSERVICEDURATION Type: view_entity BASIC
9 Fields 1 Data Sources

IS U BR Avg Serv Time Service Duration

I_UtilitiesServiceDuration is a Basic CDS View that provides data about "IS U BR Avg Serv Time Service Duration" in SAP S/4HANA. It reads from 1 data source (crms4d_actv_h) and exposes 9 fields with key fields CustMgmtObjectType, CustMgmtActivity.

Data Sources (1)

SourceAliasJoin Type
crms4d_actv_h crms4d_actv_h from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label IS U BR Avg Serv Time Service Duration view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CustMgmtObjectType objtype_h Trans. Cat.
KEY CustMgmtActivity object_id Transaction ID
CustMgmtActivityType process_type Type of Data
CreatedByUser created_by_h Created By
DistributionChannel dis_channel Distribution Channel
InvgCsMActivityStatusCode inbox_status Status
CustMgmtActivityStartDateTime date_from Validity Start Date
CustMgmtActivityEndDateTime date_to Validity End Date
WorkDuration

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_UtilitiesServiceDuration.
-- 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_UtilitiesServiceDuration AS
SELECT
  objtype_h AS CustMgmtObjectType,
  object_id AS CustMgmtActivity,
  process_type AS CustMgmtActivityType,
  created_by_h AS CreatedByUser,
  dis_channel AS DistributionChannel,
  inbox_status AS InvgCsMActivityStatusCode,
  date_from AS CustMgmtActivityStartDateTime,
  date_to AS CustMgmtActivityEndDateTime,
  TSTMP_SECONDS_BETWEEN(date_from,date_to,'INITIAL') AS WorkDuration
FROM crms4d_actv_h
;

Learn More