I_MDChgProcessTypeText

DDL: I_MDCHGPROCESSTYPETEXT Type: view COMPOSITE Package: MDC_ANALYTICS

MD Change Process Type - Text

I_MDChgProcessTypeText is a Composite CDS View that provides data about "MD Change Process Type - Text" in SAP S/4HANA. It reads from 6 data sources and exposes 13 fields with key fields MDChgProcessTypeID, Language, Language, Language. It has 2 associations to related views. Part of development package MDC_ANALYTICS.

6 data source(s) 13 fields

Data Sources (6)

SourceAliasJoin Type
I_MDChgProcTypeDescRAPCustom c from
I_MDChgProcessTypeDescription ClassicDescription union
I_MDChgProcTypeDescRapBased RAPBasedDescription union
I_MDChangeProcessTypeUnion type inner
I_MDChangeProcessTypeUnion type inner
I_MDChangeProcessTypeUnion type inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_MDChangeProcessTypeUnion _MDChgProcessType $projection.MDChgProcessTypeID = _MDChgProcessType.MDChgProcessTypeID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCTYPT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey MDChgProcessTypeID view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
Search.searchable true view
UI.textArrangement #TEXT_ONLY view
EndUserText.label MD Change Process Type - Text view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessTypeID I_MDChgProcTypeDescRAPCustom MDChgProcessTypeID
KEY Language I_MDChgProcTypeDescRAPCustom Language
MDChgProcessTypeDesc I_MDChgProcTypeDescRAPCustom MDChgProcessTypeDesc
_Language _Language
MDChgProcessTypeID
KEY Language I_MDChgProcTypeDescRapBased Language
MDChgProcessTypeDesc I_MDChgProcTypeDescRapBased MDChgProcessTypeDesc
_Language _Language
MDChgProcessTypeID
KEY Language I_MDChgProcessTypeDescription Language
MDChgProcessTypeDesc I_MDChgProcessTypeDescription MDChgProcessTypeDesc
_Language _Language
_MDChgProcessType _MDChgProcessType 
@AbapCatalog: {
  sqlViewName: 'IMDCHGPROCTYPT',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  dataCategory: #TEXT,
  representativeKey: 'MDChgProcessTypeID',
  usageType: { sizeCategory: #S, dataClass: #CUSTOMIZING, serviceQuality: #C }
}
@VDM.viewType: #COMPOSITE
@Search.searchable: true
@UI.textArrangement: #TEXT_ONLY
@EndUserText.label: 'MD Change Process Type - Text'
define view I_MDChgProcessTypeText
  as select from I_MDChgProcTypeDescRAPCustom as c
    inner join   I_MDChangeProcessTypeUnion   as type on c.MDChgProcessTypeID = type.MDChgProcessTypeID
  association [0..1] to I_Language                 as _Language         on $projection.Language = _Language.Language
  association [1..1] to I_MDChangeProcessTypeUnion as _MDChgProcessType on $projection.MDChgProcessTypeID = _MDChgProcessType.MDChgProcessTypeID
{
  key c.MDChgProcessTypeID,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key c.Language,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #LOW }
      @Semantics.text
      @EndUserText: { label: 'Template Description', quickInfo: 'Template Description'}
      @Consumption.filter.hidden: true
      c.MDChgProcessTypeDesc,

      // Associations

      _Language,
      @Consumption.hidden: true
      _MDChgProcessType
}
union select from I_MDChgProcTypeDescRapBased as RAPBasedDescription
    inner join   I_MDChangeProcessTypeUnion   as type on RAPBasedDescription.MDChgProcessTypeID = type.MDChgProcessTypeID
  left outer to many join I_MDChgProcTypeDescRAPCustom as RapCustomDescription on RapCustomDescription.MDChgProcessTypeID = type.MDChgProcessTypeID
association [0..1] to I_Language                 as _Language         on $projection.Language = _Language.Language
association [1..1] to I_MDChangeProcessTypeUnion as _MDChgProcessType on $projection.MDChgProcessTypeID = _MDChgProcessType.MDChgProcessTypeID
{
  key RAPBasedDescription.MDChgProcessTypeID,
  key RAPBasedDescription.Language,
      RAPBasedDescription.MDChgProcessTypeDesc,

      // Associations

      _Language,
      _MDChgProcessType
}
where
  RapCustomDescription.MDChgProcessTypeID is null

union select from I_MDChgProcessTypeDescription as ClassicDescription
  inner join      I_MDChangeProcessTypeUnion    as type on ClassicDescription.MDChgProcessTypeID = type.MDChgProcessTypeID
  left outer to one join I_MDChgProcTypeDescRapBased   as RAPBasedDescription  on  ClassicDescription.MDChgProcessTypeID = RAPBasedDescription.MDChgProcessTypeID
                                                                               and ClassicDescription.Language           = RAPBasedDescription.Language
  left outer to one join I_MDChgProcTypeDescRAPCustom  as RapCustomDescription on  ClassicDescription.MDChgProcessTypeID = RapCustomDescription.MDChgProcessTypeID
                                                                               and ClassicDescription.Language           = RapCustomDescription.Language
association [0..1] to I_Language                 as _Language         on $projection.Language = _Language.Language
association [1..1] to I_MDChangeProcessTypeUnion as _MDChgProcessType on $projection.MDChgProcessTypeID = _MDChgProcessType.MDChgProcessTypeID
{
  key ClassicDescription.MDChgProcessTypeID,
  key ClassicDescription.Language,
      ClassicDescription.MDChgProcessTypeDesc,

      // Associations

      _Language,
      _MDChgProcessType
}
where
      RAPBasedDescription.MDChgProcessTypeID  is null
  and RapCustomDescription.MDChgProcessTypeID is null

Learn More