I_DEFECTCATEGORYTEXT

CDS View

Defect Category Text

I_DEFECTCATEGORYTEXT is a CDS View in S/4HANA. Defect Category Text. It contains 3 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 3 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_DefectCategoryText view from COMPOSITE Defect Category Texts
I_DefectCategoryStdVH view left_outer COMPOSITE Defect Category
SHSM_IDEFCAT view left_outer Defect Category

Fields (3)

KeyField CDS FieldsUsed in Views
KEY DefectCategory DefectCategory 1
KEY Language Language 1
DefectCategoryText DefectCategoryText 3 
@AbapCatalog.sqlViewName: 'IDEFECTCATEGORYT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Defect Category Text'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
    usageType: {
        dataClass: #ORGANIZATIONAL,
        sizeCategory: #S,
        serviceQuality: #A
    },
    dataCategory: #TEXT,
    representativeKey: 'DefectCategory',
    resultSet.sizeCategory: #XS
}

define view I_DefectCategoryText as select from tqdefcatt

   association [0..1] to I_Language as _Language  on $projection.Language = _Language.Language

   association [1..1] to I_DefectCategory as _DefectCategory on $projection.DefectCategory = _DefectCategory.DefectCategory

{
   key tqdefcatt.category as DefectCategory,
   @Semantics.language: true
   key tqdefcatt.langu as Language,

   @Semantics.text: true
   tqdefcatt.text as DefectCategoryText,

   // Associations 

   _DefectCategory,
   _Language
   
}

union select from tqdefccatt

  association [0..1] to I_Language as _Language  on $projection.Language = _Language.Language

  association [1..1] to I_DefectCategory as _DefectCategory on $projection.DefectCategory = _DefectCategory.DefectCategory
  
{
   key tqdefccatt.category as DefectCategory,
   @Semantics.language: true
   key tqdefccatt.langu as Language,

   @Semantics.text: true
   tqdefccatt.text as DefectCategoryText,

   // Associations 

   _DefectCategory,
   _Language
   
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TQDEFCATT",
"TQDEFCCATT"
],
"ASSOCIATED":
[
"I_DEFECTCATEGORY",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More