I_ConfigurableCodesCode

DDL: I_CONFIGURABLECODESCODE Type: view_entity BASIC

Code of Configurable Codes

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

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
qpcd qpcd from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ConfigurableCodesCatalog _ConfigurableCodesCatalog $projection.ConfigurableCodesCatalog = _ConfigurableCodesCatalog.ConfigurableCodesCatalog
[1..1] I_ConfigurableCodesCodeGroup _ConfigurableCodesCodeGroup $projection.ConfigurableCodesCatalog = _ConfigurableCodesCodeGroup.ConfigurableCodesCatalog and $projection.ConfigurableCodesCodeGroup = _ConfigurableCodesCodeGroup.ConfigurableCodesCodeGroup
[1..*] I_ConfigurableCodesCodeText _Text $projection.ConfigurableCodesCatalog = _Text.ConfigurableCodesCatalog and $projection.ConfigurableCodesCodeGroup = _Text.ConfigurableCodesCodeGroup and $projection.ConfigurableCodesCode = _Text.ConfigurableCodesCode

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Code of Configurable Codes view
ObjectModel.representativeKey ConfigurableCodesCode view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL 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 #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConfigurableCodesCatalog qpcd katalogart
KEY ConfigurableCodesCodeGroup codegruppe
KEY ConfigurableCodesCode code
_ConfigurableCodesCatalog _ConfigurableCodesCatalog
_ConfigurableCodesCodeGroup _ConfigurableCodesCodeGroup
_Text _Text 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Code of Configurable Codes'
@ObjectModel.representativeKey: 'ConfigurableCodesCode'
@Analytics: {
  dataExtraction.enabled: true,
  dataExtraction.delta.changeDataCapture.automatic: true,
  dataCategory: #DIMENSION
}
@Analytics.internalName:#LOCAL
@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,
  usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #CUSTOMIZING } }
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
define view entity I_ConfigurableCodesCode
  as select from qpcd
  association [1..1] to I_ConfigurableCodesCatalog   as _ConfigurableCodesCatalog   on  $projection.ConfigurableCodesCatalog = _ConfigurableCodesCatalog.ConfigurableCodesCatalog
  association [1..1] to I_ConfigurableCodesCodeGroup as _ConfigurableCodesCodeGroup on  $projection.ConfigurableCodesCatalog   = _ConfigurableCodesCodeGroup.ConfigurableCodesCatalog
                                                                                    and $projection.ConfigurableCodesCodeGroup = _ConfigurableCodesCodeGroup.ConfigurableCodesCodeGroup
  association [1..*] to I_ConfigurableCodesCodeText  as _Text                       on  $projection.ConfigurableCodesCatalog   = _Text.ConfigurableCodesCatalog
                                                                                    and $projection.ConfigurableCodesCodeGroup = _Text.ConfigurableCodesCodeGroup
                                                                                    and $projection.ConfigurableCodesCode      = _Text.ConfigurableCodesCode
{
      @ObjectModel.foreignKey.association: '_ConfigurableCodesCatalog'
      @ObjectModel.sapObjectNodeTypeReference: 'ConfigurableCodesCatalog'
  key qpcd.katalogart as ConfigurableCodesCatalog,
      @ObjectModel.foreignKey.association: '_ConfigurableCodesCodeGroup'
  key codegruppe      as ConfigurableCodesCodeGroup,
      @ObjectModel.text.association: '_Text'
  key code            as ConfigurableCodesCode,
      case qpcd.inaktiv
        when ' ' then cast( ' ' as vdm_qm_codeisinactive preserving type )
        else cast( 'X' as vdm_qm_codeisinactive preserving type )
      end             as ConfigblCodesCodeGrpIsInactv,

      //Associations

      _ConfigurableCodesCatalog,
      _ConfigurableCodesCodeGroup,
      _Text

}
where
  qpcd.version = '000001'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QPCD"
],
"ASSOCIATED":
[
"I_CONFIGURABLECODESCATALOG",
"I_CONFIGURABLECODESCODEGROUP",
"I_CONFIGURABLECODESCODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More