A_DefectCodeGroup

DDL: A_DEFECTCODEGROUP SQL: ADEFECTCODEGRP Type: view BASIC

Defect Code Groups

A_DefectCodeGroup is a Basic CDS View that provides data about "Defect Code Groups" in SAP S/4HANA. It reads from 1 data source (I_DefectCodeGroup) and exposes 5 fields with key field DefectCodeGroup. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_DefectCodeGroup _DefectCodeGroup from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_DefectCodeGroupText _Text $projection.DefectCodeGroup = _Text.DefectCodeGroup
[0..*] A_DefectCode _DefectCode $projection.DefectCodeGroup = _DefectCode.DefectCodeGroup

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ADEFECTCODEGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Defect Code Groups view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey DefectCodeGroup view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY DefectCodeGroup I_DefectCodeGroup DefectCodeGroup
CodeGroupIsInactive
CodeGroupStatus I_DefectCodeGroup CodeGroupStatus
_Text _Text
_DefectCode _DefectCode 
@AbapCatalog.sqlViewName: 'ADEFECTCODEGRP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@EndUserText.label: 'Defect Code Groups'

@ObjectModel: {
    usageType: {
        dataClass: #CUSTOMIZING,
        sizeCategory: #S,
        serviceQuality: #A
    },
    representativeKey: 'DefectCodeGroup'
}
@Metadata.ignorePropagatedAnnotations: true

define view A_DefectCodeGroup as select from I_DefectCodeGroup as _DefectCodeGroup

  association [0..*] to A_DefectCodeGroupText as _Text
    on $projection.DefectCodeGroup     = _Text.DefectCodeGroup
    
  association [0..*] to A_DefectCode as _DefectCode
    on $projection.DefectCodeGroup = _DefectCode.DefectCodeGroup
    
{
  key _DefectCodeGroup.DefectCodeGroup,
  cast( _DefectCodeGroup.CodeGroupIsInactive as qinak preserving type ) as CodeGroupIsInactive,
  @Consumption.hidden: true  
  _DefectCodeGroup.CodeGroupStatus,
  cast ( 
    case _DefectCodeGroup.CodeGroupStatus
        when '2' then 'X'
        else ' '
    end as vdm_codegroupisusable preserving type ) as CodeGroupIsUsable,

  //Associations

  _Text,
  _DefectCode
} where _DefectCodeGroup.CodeGroupStatus <> '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECTCODEGROUP"
],
"ASSOCIATED":
[
"A_DEFECTCODE",
"A_DEFECTCODEGROUPTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More