I_SERVICEDEFECT

CDS View

Service Defect

I_SERVICEDEFECT is a CDS View in S/4HANA. Service Defect. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_ServiceOrderDefect view from COMPOSITE Defect Data Within Service Order
A_ServiceOrderItemDefect view from COMPOSITE Defect Data Within Service Order Item
A_ServiceRequestDefect view from COMPOSITE Service Request Defect
I_UtilitiesServiceDefectTP view_entity from TRANSACTIONAL IS U BR Avg Serv Time Serv Defect - TP 
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Service Defect'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ISERVICEDEFECT',
  preserveKey:true,
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   //representativeKey: 'ServiceDefectSequence',

   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view I_ServiceDefect
  as select from crms4d_srv_subj

  association [1..1] to I_BusinessObjType          as _ServiceObjectType   on  $projection.ServiceObjectType = _ServiceObjectType.BusinessObjectType

  association [1..*] to I_ServiceDocumentEnhcd     as _ServiceDocument     on  $projection.ServiceDocument = _ServiceDocument.ServiceDocument

  association [1..*] to I_ServiceDocumentItemEnhcd as _ServiceDocumentItem on  $projection.ServiceDocument     = _ServiceDocumentItem.ServiceDocument
                                                                           and $projection.ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem
{
//      @ObjectModel.foreignKey.association: '_ServiceObjectType'

  key objtype_h                             as ServiceObjectType,

//      @ObjectModel.foreignKey.association: '_ServiceDocument'

  key object_id                             as ServiceDocument,

//      @ObjectModel.foreignKey.association: '_ServiceDocumentItem'

  key number_int                            as ServiceDocumentItem,
 
  key profile_type                          as SrvcDocTypeDefectCodeProfType,
  
  key sort                                  as ServiceDefectSequence,    
        
      subject_profile                       as SrvcDocTypeDefectCodeProfile,
      katalogart                            as ServiceDefectCodeCatalog,
      codegruppe                            as ServiceDefectCodeGroup,
      code                                  as ServiceDefectCode,
      asp_id                                as ServiceDefectSchema,
      cat_id                                as ServiceDefectCategory,

      //Associations

      _ServiceObjectType,
      _ServiceDocument,
      _ServiceDocumentItem

}

Learn More