I_DefectCategoryText

DDL: I_DEFECTCATEGORYTEXT SQL: IDEFECTCATEGORYT Type: view BASIC

Defect Category Text

I_DefectCategoryText is a Basic CDS View that provides data about "Defect Category Text" in SAP S/4HANA. It reads from 2 data sources (tqdefcatt, tqdefccatt) and exposes 9 fields with key fields DefectCategory, Language, Language. It has 2 associations to related views.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
tqdefcatt tqdefcatt from
tqdefccatt tqdefccatt union

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_DefectCategory _DefectCategory $projection.DefectCategory = _DefectCategory.DefectCategory

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IDEFECTCATEGORYT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
EndUserText.label Defect Category Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey DefectCategory view
ObjectModel.resultSet.sizeCategory #XS view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DefectCategory tqdefcatt category
KEY Language tqdefcatt langu
DefectCategoryText tqdefcatt text
_DefectCategory _DefectCategory
categoryasDefectCategory
KEY Language tqdefccatt langu
DefectCategoryText tqdefccatt text
_DefectCategory _DefectCategory
_Language _Language 
@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