I_DEFECTCATEGORYTEXT
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.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
}