I_ConfigurableCodesCodeText

DDL: I_CONFIGURABLECODESCODETEXT Type: view_entity BASIC

Code of Configurable Codes - Text

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

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
qpct qpct 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..1] I_ConfigurableCodesCode _ConfigurableCodesCode $projection.ConfigurableCodesCatalog = _ConfigurableCodesCode.ConfigurableCodesCatalog and $projection.ConfigurableCodesCodeGroup = _ConfigurableCodesCode.ConfigurableCodesCodeGroup and $projection.ConfigurableCodesCode = _ConfigurableCodesCode.ConfigurableCodesCode

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Code of Configurable Codes - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.representativeKey ConfigurableCodesCode view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ConfigurableCodesCatalog katalogart
KEY ConfigurableCodesCodeGroup codegruppe
KEY ConfigurableCodesCode code
KEY Language sprache
ConfigurableCodesCodeText
_ConfigurableCodesCatalog _ConfigurableCodesCatalog
_ConfigurableCodesCodeGroup _ConfigurableCodesCodeGroup
_ConfigurableCodesCode _ConfigurableCodesCode 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Code of Configurable Codes - Text'
@ObjectModel.dataCategory: #TEXT
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel:{
  supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT, #EXTRACTION_DATA_SOURCE ],
  modelingPattern: #LANGUAGE_DEPENDENT_TEXT,
  usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #CUSTOMIZING } }
@Analytics: {
  dataExtraction.enabled: true,
  dataExtraction.delta.changeDataCapture.automatic: true
}
@ObjectModel.representativeKey: 'ConfigurableCodesCode'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_ConfigurableCodesCodeText
  as select from qpct
  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..1] to I_ConfigurableCodesCode      as _ConfigurableCodesCode      on  $projection.ConfigurableCodesCatalog   = _ConfigurableCodesCode.ConfigurableCodesCatalog
                                                                                    and $projection.ConfigurableCodesCodeGroup = _ConfigurableCodesCode.ConfigurableCodesCodeGroup
                                                                                    and $projection.ConfigurableCodesCode      = _ConfigurableCodesCode.ConfigurableCodesCode
{
      @ObjectModel.foreignKey.association: '_ConfigurableCodesCatalog'
  key katalogart                                        as ConfigurableCodesCatalog,
      @ObjectModel.foreignKey.association: '_ConfigurableCodesCodeGroup'
  key codegruppe                                        as ConfigurableCodesCodeGroup,
      @ObjectModel.foreignKey.association: '_ConfigurableCodesCode'
  key code                                              as ConfigurableCodesCode,
      @Semantics.language: true
  key sprache                                           as Language,
      @Semantics.text: true
      cast( kurztext as vdm_qtxt_code preserving type ) as ConfigurableCodesCodeText,

      // Associations

      _ConfigurableCodesCatalog,
      _ConfigurableCodesCodeGroup,
      _ConfigurableCodesCode

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

Learn More