I_UsgeDcsnSelectedSetCodeGrp

DDL: I_USGEDCSNSELECTEDSETCODEGRP Type: view_entity BASIC Package: VDM_QM_INSPECTION

Code Group of Selected Set for UD

I_UsgeDcsnSelectedSetCodeGrp is a Basic CDS View that provides data about "Code Group of Selected Set for UD" in SAP S/4HANA. It reads from 1 data source (qpgr) and exposes 8 fields with key fields SelectedCodeSetPlant, SelectedCodeSet, UsageDecisionCodeGroup. It has 5 associations to related views. Part of development package VDM_QM_INSPECTION.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
qpgr qpgr inner

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_Plant _SelectedCodeSetPlant $projection.SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant
[0..1] I_InspUsgeDcsnSelectedSet _SelectedCodeSet _SelectedCodeSet.SelectedCodeSetPlant = $projection.SelectedCodeSetPlant and _SelectedCodeSet.SelectedCodeSet = $projection.SelectedCodeSet
[0..1] I_UsageDcsnSelectedCodeSet _UsageDcsnSelectedCodeSet _UsageDcsnSelectedCodeSet.SelectedCodeSetPlant = $projection.SelectedCodeSetPlant and _UsageDcsnSelectedCodeSet.SelectedCodeSet = $projection.SelectedCodeSet
[0..1] I_UsageDecisionCodeGroup _UsageDecisionCodeGroup $projection.UsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup
[0..*] I_UsgeDcsnSelectedSetCode _UsgeDcsnSelectedSetCode $projection.SelectedCodeSetPlant = _UsgeDcsnSelectedSetCode.SelectedCodeSetPlant and $projection.SelectedCodeSet = _UsgeDcsnSelectedSetCode.SelectedCodeSet and $projection.UsageDecisionCodeGroup = _UsgeDcsnSelectedSetCode.UsageDecisionCodeGroup

Annotations (10)

NameValueLevelField
EndUserText.label Code Group of Selected Set for UD view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey UsageDecisionCodeGroup view
Analytics.technicalName IUDSELSETCDGRP view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SelectedCodeSetPlant qpac werks
KEY SelectedCodeSet qpac auswahlmge
KEY UsageDecisionCodeGroup qpac codegruppe
_SelectedCodeSetPlant _SelectedCodeSetPlant
_UsageDcsnSelectedCodeSet _UsageDcsnSelectedCodeSet
_SelectedCodeSet _SelectedCodeSet
_UsgeDcsnSelectedSetCode _UsgeDcsnSelectedSetCode
_UsageDecisionCodeGroup _UsageDecisionCodeGroup 
@EndUserText.label: 'Code Group of Selected Set for UD'
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.usageType: {
    dataClass: #CUSTOMIZING,
    sizeCategory: #S,
    serviceQuality: #A
}
@ObjectModel.representativeKey: 'UsageDecisionCodeGroup'
@Analytics.technicalName: 'IUDSELSETCDGRP'
@Metadata.ignorePropagatedAnnotations: true

define view entity I_UsgeDcsnSelectedSetCodeGrp 
  as select distinct from qpac
    inner join qpgr
       on  qpgr.katalogart = '3' // Usage Decision

       and qpgr.codegruppe = qpac.codegruppe

   association [0..1] to I_Plant as _SelectedCodeSetPlant
      on $projection.SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant

   association [0..1] to I_InspUsgeDcsnSelectedSet as _SelectedCodeSet
      on  _SelectedCodeSet.SelectedCodeSetPlant = $projection.SelectedCodeSetPlant 
      and _SelectedCodeSet.SelectedCodeSet      = $projection.SelectedCodeSet

   association [0..1] to I_UsageDcsnSelectedCodeSet as _UsageDcsnSelectedCodeSet
      on  _UsageDcsnSelectedCodeSet.SelectedCodeSetPlant = $projection.SelectedCodeSetPlant 
      and _UsageDcsnSelectedCodeSet.SelectedCodeSet      = $projection.SelectedCodeSet
      
   association [0..1] to I_UsageDecisionCodeGroup as _UsageDecisionCodeGroup
      on $projection.UsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup
      
   association [0..*] to I_UsgeDcsnSelectedSetCode as _UsgeDcsnSelectedSetCode
      on $projection.SelectedCodeSetPlant = _UsgeDcsnSelectedSetCode.SelectedCodeSetPlant
      and $projection.SelectedCodeSet     = _UsgeDcsnSelectedSetCode.SelectedCodeSet
      and $projection.UsageDecisionCodeGroup = _UsgeDcsnSelectedSetCode.UsageDecisionCodeGroup
                        
{
    @ObjectModel.foreignKey.association: '_SelectedCodeSetPlant'
    key qpac.werks      as SelectedCodeSetPlant,
    //key katalogart as --> hard coded value '3' as where condition,

    @ObjectModel.foreignKey.association: '_SelectedCodeSet'
    key qpac.auswahlmge as SelectedCodeSet,
    key qpac.codegruppe as UsageDecisionCodeGroup,
    //  key qpac.code      --> Not necessary as we want to select only code group

    //  key qpac.versionam --> is always 1 so we could leave out

    //  qpac.bewertung     --> does not make sence

    
    
    /* Associations */
    _SelectedCodeSetPlant,
    _UsageDcsnSelectedCodeSet,
    _SelectedCodeSet,
    _UsgeDcsnSelectedSetCode,
    _UsageDecisionCodeGroup
        
} where qpac.katalogart = '3' and qpac.code is not null and qpac.versionam = '000001'

Learn More