I_DEFECTCATEGORY

CDS View

Defect Category

I_DEFECTCATEGORY is a CDS View in S/4HANA. Defect Category. It contains 2 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 2 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_DefectCategory view_entity from COMPOSITE Defect Categories
C_DefectCatVH view_entity from CONSUMPTION Defect Category Value Help
C_MfgExecDefectRecord view inner CONSUMPTION View with UI attributes for defect
I_DefectCategoryStdVH view_entity from COMPOSITE Defect Category
SHSM_IDEFCAT view_entity from Defect Category

Fields (2)

KeyField CDS FieldsUsed in Views
DefectCategory DefectCategory 2
DefectCategoryContext DefectCategoryContext 1 
@AbapCatalog.sqlViewName: 'IDEFECTCATEGORY'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Defect Category'
@Analytics.dataCategory: #DIMENSION
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
    usageType: {
        dataClass: #ORGANIZATIONAL,
        sizeCategory: #S,
        serviceQuality: #B
    },
    representativeKey: 'DefectCategory',
    resultSet.sizeCategory: #XS
}

define view I_DefectCategory as select from tqdefcat
  left outer join tqdefccatsttgs
     on tqdefccatsttgs.category = tqdefcat.category 
   
   association [0..*] to I_DefectCategoryText as _Text on $projection.DefectCategory = _Text.DefectCategory
   
{
   @ObjectModel.text.association: '_Text'
   key tqdefcat.category       as DefectCategory,

   // For setings merge defaults from system table with values from customizing/settings table tqdefccatsttgs

   case tqdefccatsttgs.origin
     when '1' then tqdefccatsttgs.default_tasktype
     else tqdefcat.default_tasktype
   end                                                                        as DefectCategoryDefaultTaskType,
   
   case tqdefccatsttgs.origin
     when '1' then tqdefccatsttgs.has_affected_objects
     else tqdefcat.has_affected_objects
   end                                                                        as DefectHasAffectedObjects,

   case tqdefccatsttgs.origin
     when '1' then tqdefccatsttgs.categorycontext
     else tqdefcat.categorycontext
   end                                                                        as DefectCategoryContext,   
   
   // Associations

   _Text
}

///////

// Skip the below union branch, as the feature is not used in PuC (and was never)

//union select from tqdefccat

//  inner join tqdefccatsttgs

//     on tqdefccatsttgs.category = tqdefccat.category 

//// hint: due to the inner join no settings for system category (origin = 1) shall be read from tqdefccatsttgs; this cas is handled above

//

//  association [0..*] to I_DefectCategoryText as _Text on $projection.DefectCategory = _Text.DefectCategory

//  

//{

//   @ObjectModel.text.association: '_Text'

//   key tqdefccat.category       as DefectCategory,

//

//   tqdefccatsttgs.default_tasktype                                            as DefectCategoryDefaultTaskType,

//   tqdefccatsttgs.has_affected_objects                                        as DefectHasAffectedObjects,

//   tqdefccatsttgs.categorycontext                                             as DefectCategoryContext,

//   

//   // Associations

//   _Text

//}

Learn More