I_ConfigurableCodesCodeGroup

DDL: I_CONFIGURABLECODESCODEGROUP Type: view_entity BASIC Package: VDM_QM_PLANNING

Code Group of Configurable Codes

I_ConfigurableCodesCodeGroup is a Basic CDS View (Dimension) that provides data about "Code Group of Configurable Codes" in SAP S/4HANA. It reads from 1 data source (qpgr) and exposes 6 fields with key fields ConfigurableCodesCatalog, ConfigurableCodesCodeGroup. It has 3 associations to related views. Part of development package VDM_QM_PLANNING.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
qpgr qpgr from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ConfigurableCodesCatalog _ConfigurableCodesCatalog $projection.ConfigurableCodesCatalog = _ConfigurableCodesCatalog.ConfigurableCodesCatalog
[1..*] I_ConfigblCodesCodeGroupText _Text $projection.ConfigurableCodesCatalog = _Text.ConfigurableCodesCatalog and $projection.ConfigurableCodesCodeGroup = _Text.ConfigurableCodesCodeGroup
[1..*] I_ConfigurableCodesCode _ConfigurableCodesCode $projection.ConfigurableCodesCatalog = _ConfigurableCodesCode.ConfigurableCodesCatalog and $projection.ConfigurableCodesCodeGroup = _ConfigurableCodesCode.ConfigurableCodesCodeGroup

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ConfigurableCodesCodeGroup view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
EndUserText.label Code Group of Configurable Codes view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name ConfigurableCodesCodeGroup view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConfigurableCodesCatalog qpgr katalogart
KEY ConfigurableCodesCodeGroup qpgr codegruppe
ConfigblCodesCodeGroupStatus qpgr status
_ConfigurableCodesCatalog _ConfigurableCodesCatalog
_ConfigurableCodesCode _ConfigurableCodesCode
_Text _Text 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.representativeKey: 'ConfigurableCodesCodeGroup'
@Analytics: {
  dataExtraction.enabled: true,
  dataExtraction.delta.changeDataCapture.automatic: true,
  dataCategory: #DIMENSION
}
@Analytics.internalName:#LOCAL
@EndUserText.label: 'Code Group of Configurable Codes'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel:{
    supportedCapabilities:[ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ],
    modelingPattern: #ANALYTICAL_DIMENSION }
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING }
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@ObjectModel.sapObjectNodeType.name: 'ConfigurableCodesCodeGroup'
define view entity I_ConfigurableCodesCodeGroup
  as select from qpgr
  association [1..1] to I_ConfigurableCodesCatalog   as _ConfigurableCodesCatalog on  $projection.ConfigurableCodesCatalog = _ConfigurableCodesCatalog.ConfigurableCodesCatalog

  association [1..*] to I_ConfigblCodesCodeGroupText as _Text                     on  $projection.ConfigurableCodesCatalog   = _Text.ConfigurableCodesCatalog
                                                                                  and $projection.ConfigurableCodesCodeGroup = _Text.ConfigurableCodesCodeGroup
  association [1..*] to I_ConfigurableCodesCode      as _ConfigurableCodesCode    on  $projection.ConfigurableCodesCatalog   = _ConfigurableCodesCode.ConfigurableCodesCatalog
                                                                                  and $projection.ConfigurableCodesCodeGroup = _ConfigurableCodesCode.ConfigurableCodesCodeGroup

{
      @ObjectModel.foreignKey.association: '_ConfigurableCodesCatalog'
      @ObjectModel.sapObjectNodeTypeReference: 'ConfigurableCodesCatalog'
  key qpgr.katalogart as ConfigurableCodesCatalog,
      @ObjectModel.text.association: '_Text'
  key qpgr.codegruppe as ConfigurableCodesCodeGroup,
      case qpgr.inaktiv
        when ' ' then cast( ' ' as vdm_qm_codegroupisinactive preserving type )
        else cast( 'X' as vdm_qm_codegroupisinactive preserving type )
      end             as ConfigblCodesCodeGrpIsInactv,
      qpgr.status     as ConfigblCodesCodeGroupStatus,

      //Associations

      _ConfigurableCodesCatalog,
      _ConfigurableCodesCode,
      _Text
}

Learn More