I_UtilitiesServiceDefectTP

DDL: I_UTILITIESSERVICEDEFECTTP Type: view_entity TRANSACTIONAL

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
KEY ServiceDocument ServiceDocument
KEY ServiceDocumentItem ServiceDocumentItem
KEY SrvcDocTypeDefectCodeProfType SrvcDocTypeDefectCodeProfType
KEY ServiceDefectSequence ServiceDefectSequence
SrvcDocTypeDefectCodeProfile SrvcDocTypeDefectCodeProfile
ServiceDefectCodeCatalog ServiceDefectCodeCatalog
ServiceDefectCodeGroup ServiceDefectCodeGroup
ServiceDefectCode ServiceDefectCode
DefectCodeText _ServiceReason DefectCodeText
ServiceDefectSchema ServiceDefectSchema
ServiceDefectCategory ServiceDefectCategory
_ServiceReason _ServiceReason
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.viewEnhancementCategory: [#NONE]
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL

@ObjectModel: {
    usageType:{
      sizeCategory: #L,
      serviceQuality: #X,
      dataClass: #MIXED
    }
}
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'IS U BR Avg Serv Time Serv Defect - TP'
define view entity I_UtilitiesServiceDefectTP
  as select from I_ServiceDefect
  association [0..1] to I_UtilitiesServiceReason as _ServiceReason on  _ServiceReason.ServiceDefectCodeCatalog = $projection.ServiceDefectCodeCatalog
                                                                   and _ServiceReason.ServiceDefectCodeGroup   = $projection.ServiceDefectCodeGroup
                                                                   and _ServiceReason.ServiceDefectCode        = $projection.ServiceDefectCode
{
  key ServiceObjectType,
  key ServiceDocument,
  key ServiceDocumentItem,

  key SrvcDocTypeDefectCodeProfType,

  key ServiceDefectSequence,

      SrvcDocTypeDefectCodeProfile,
      ServiceDefectCodeCatalog,
      ServiceDefectCodeGroup,
      @Consumption.valueHelp: '_ServiceReason'
      @ObjectModel.text.element: ['DefectCodeText']
      ServiceDefectCode,

      @Semantics.text: true
      _ServiceReason.DefectCodeText,

      ServiceDefectSchema,
      ServiceDefectCategory,

      _ServiceReason
}