I_DefectLocationCodeGroupText

DDL: I_DEFECTLOCATIONCODEGROUPTEXT Type: view_entity BASIC Package: VDM_QM_NOTIFICATION

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. Part of development package VDM_QM_NOTIFICATION.

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 (9)

NameValueLevelField
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
Analytics.technicalName IDEFLOCCODEGRPT 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 
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel: {
    representativeKey: 'DefectLocationCodeGroup',
    usageType: { serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING },
    dataCategory: #TEXT
}
@Analytics.technicalName: 'IDEFLOCCODEGRPT'
@EndUserText.label: 'Defect Location Code Group Text'
define view entity 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

Learn More