I_DefectLocationCodeGroupText

DDL: I_DEFECTLOCATIONCODEGROUPTEXT SQL: IDEFLOCCODEGRPT Type: view BASIC

Defect Location Code Group Text

I_DefectLocationCodeGroupText is a Basic CDS View that provides data about "Defect Location Code Group Text" in SAP S/4HANA. It reads from 1 data source (qpgt) and exposes 6 fields with key fields DefectLocationCatalog, DefectLocationCodeGroup, Language. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
qpgt qpgt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_DefectLocationCatalog _DefectLocationCatalog $projection.DefectLocationCatalog = _DefectLocationCatalog.DefectLocationCatalog
[1..1] I_DefectLocationCodeGroup _DefectLocationCodeGroup $projection.DefectLocationCatalog = _DefectLocationCodeGroup.DefectLocationCatalog and $projection.DefectLocationCodeGroup = _DefectLocationCodeGroup.DefectLocationCodeGroup

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDEFLOCCODEGRPT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.representativeKey DefectLocationCodeGroup view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #TEXT view
EndUserText.label Defect Location Code Group Text view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DefectLocationCatalog
KEY DefectLocationCodeGroup
KEY Language qpgt sprache
DefectLocationCodeGroupText
_DefectLocationCatalog _DefectLocationCatalog
_DefectLocationCodeGroup _DefectLocationCodeGroup 
@AbapCatalog.sqlViewName: 'IDEFLOCCODEGRPT'
@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel: {
    representativeKey: 'DefectLocationCodeGroup',
    usageType: { serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING },
    dataCategory: #TEXT
}
@EndUserText.label: 'Defect Location Code Group Text'
define view I_DefectLocationCodeGroupText as select from qpgt 

    association [1..1] to I_DefectLocationCatalog as _DefectLocationCatalog on $projection.DefectLocationCatalog = _DefectLocationCatalog.DefectLocationCatalog
    association [1..1] to I_DefectLocationCodeGroup as _DefectLocationCodeGroup on  $projection.DefectLocationCatalog = _DefectLocationCodeGroup.DefectLocationCatalog and
                                                                                    $projection.DefectLocationCodeGroup = _DefectLocationCodeGroup.DefectLocationCodeGroup

{
   @ObjectModel.foreignKey.association: '_DefectLocationCatalog'
   key cast( katalogart as vdm_qfeocat preserving type )        as DefectLocationCatalog,
   @ObjectModel.foreignKey.association: '_DefectLocationCodeGroup'
   key cast( qpgt.codegruppe as vdm_qfeogrp preserving type )   as DefectLocationCodeGroup,
   @Semantics.language: true
   key qpgt.sprache                                             as Language,
   
   @Semantics.text: true
   cast( qpgt.kurztext as vdm_qfeogrp_text preserving type )    as DefectLocationCodeGroupText,
   
   // Association

   _DefectLocationCatalog,
   _DefectLocationCodeGroup
      
} where //katalogart = 'B' or //Object Parts

        katalogart = 'E'    //Defect Locations   

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QPGT"
],
"ASSOCIATED":
[
"I_DEFECTLOCATIONCATALOG",
"I_DEFECTLOCATIONCODEGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More