I_UtilitiesServiceDefectTP

DDL: I_UTILITIESSERVICEDEFECTTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources 1 Associations

IS U BR Avg Serv Time Serv Defect - TP

I_UtilitiesServiceDefectTP is a Transactional CDS View that provides data about "IS U BR Avg Serv Time Serv Defect - TP" in SAP S/4HANA. It reads from 1 data source (I_ServiceDefect) and exposes 13 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem, SrvcDocTypeDefectCodeProfType, ServiceDefectSequence. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDefect I_ServiceDefect from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UtilitiesServiceReason _ServiceReason _ServiceReason.ServiceDefectCodeCatalog = $projection.ServiceDefectCodeCatalog and _ServiceReason.ServiceDefectCodeGroup = $projection.ServiceDefectCodeGroup and _ServiceReason.ServiceDefectCode = $projection.ServiceDefectCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL 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 Serv Defect - TP view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
KEY SrvcDocTypeDefectCodeProfType SrvcDocTypeDefectCodeProfType SubjPrfileCtgry
KEY ServiceDefectSequence ServiceDefectSequence User Types Sort Ord.
SrvcDocTypeDefectCodeProfile SrvcDocTypeDefectCodeProfile Subject Profile
ServiceDefectCodeCatalog ServiceDefectCodeCatalog Catalog
ServiceDefectCodeGroup ServiceDefectCodeGroup Code Group
ServiceDefectCode ServiceDefectCode Water Hazard Cl.
DefectCodeText _ServiceReason DefectCodeText
ServiceDefectSchema ServiceDefectSchema Schema ID
ServiceDefectCategory ServiceDefectCategory Technical Catalog ID
_ServiceReason _ServiceReason

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_UtilitiesServiceDefectTP.
-- 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_UtilitiesServiceDefectTP AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  SrvcDocTypeDefectCodeProfType,
  ServiceDefectSequence,
  SrvcDocTypeDefectCodeProfile,
  ServiceDefectCodeCatalog,
  ServiceDefectCodeGroup,
  ServiceDefectCode,
  _ServiceReason.DefectCodeText AS DefectCodeText,
  ServiceDefectSchema,
  ServiceDefectCategory
FROM I_ServiceDefect
LEFT OUTER JOIN I_UtilitiesServiceReason AS _ServiceReason ON _ServiceReason.ServiceDefectCodeCatalog = ServiceDefectCodeCatalog AND _ServiceReason.ServiceDefectCodeGroup = ServiceDefectCodeGroup AND _ServiceReason.ServiceDefectCode = ServiceDefectCode  -- association [0..1]
;

Learn More