I_DefectCodeText

DDL: I_DEFECTCODETEXT SQL: IDEFECTCODET Type: view BASIC

Defect Code - Text

I_DefectCodeText is a Basic CDS View that provides data about "Defect Code - Text" in SAP S/4HANA. It reads from 1 data source (qpct) and exposes 6 fields with key fields DefectCodeGroup, DefectCode, Language. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
qpct qpct from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_DefectCodeGroup _DefectCodeGroup $projection.DefectCodeGroup = _DefectCodeGroup.DefectCodeGroup
[1..1] I_DefectCode _DefectCode $projection.DefectCodeGroup = _DefectCode.DefectCodeGroup and $projection.DefectCode = _DefectCode.DefectCode

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IDEFECTCODET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Defect Code - Text view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey DefectCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #TEXT view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DefectCodeGroup
KEY DefectCode
KEY Language qpct sprache
DefectCodeText
_DefectCodeGroup _DefectCodeGroup
_DefectCode _DefectCode 
@AbapCatalog.sqlViewName: 'IDEFECTCODET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Defect Code - Text'
@AccessControl.authorizationCheck: #CHECK
@VDM: {
    viewType:#BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT ]
@ObjectModel: {
    representativeKey: 'DefectCode',
    usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #CUSTOMIZING },
    dataCategory: #TEXT
}
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
define view I_DefectCodeText as select from qpct 

   association [1..1] to I_DefectCodeGroup as _DefectCodeGroup on  $projection.DefectCodeGroup = _DefectCodeGroup.DefectCodeGroup

   association [1..1] to I_DefectCode as _DefectCode on  $projection.DefectCodeGroup = _DefectCode.DefectCodeGroup
                                                     and $projection.DefectCode      = _DefectCode.DefectCode

{
   @ObjectModel.foreignKey.association: '_DefectCodeGroup'
   key cast( qpct.codegruppe as vdm_qfegrp preserving type )  as DefectCodeGroup,
   key cast( qpct.code       as vdm_qfecod preserving type )  as DefectCode,
   @Semantics.language: true
   key qpct.sprache                                           as Language,
// key qpcd.version --> is always 1 so we could leave out


   @Semantics.text: true
   @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
   cast( qpct.kurztext as  vdm_qfecod_text preserving type )  as DefectCodeText,
   
   // Associations

   _DefectCodeGroup,
   _DefectCode
   
} where qpct.katalogart = '9' // Defects

    and qpct.version    = '000001'

Learn More