I_MDChgProcessTypeText

DDL: I_MDCHGPROCESSTYPETEXT SQL: IMDCHGPROCTYPT Type: view COMPOSITE

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 3 data sources (I_MDChgProcessTypeDescription, I_MDChgProcTypeDescRAPCustom, I_MDChgProcTypeDescRapBased) and exposes 13 fields with key fields MDChgProcessTypeID, Language, Language, Language. It has 2 associations to related views.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_MDChgProcessTypeDescription ClassicDescription union
I_MDChgProcTypeDescRAPCustom I_MDChgProcTypeDescRAPCustom from
I_MDChgProcTypeDescRapBased RAPBasedDescription union

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
AbapCatalog.preserveKey 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
EndUserText.label MD Change Process Type - Text view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessTypeID MDChgProcessTypeID
KEY Language Language
MDChgProcessTypeDesc 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'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'MDChgProcessTypeID'
@ObjectModel.usageType: { sizeCategory: #S, dataClass: #CUSTOMIZING, serviceQuality: #C }
@VDM.viewType: #COMPOSITE
@Search.searchable: true
@EndUserText.label: 'MD Change Process Type - Text'
define view I_MDChgProcessTypeText
  as select from I_MDChgProcTypeDescRAPCustom
  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 MDChgProcessTypeID,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key Language,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #LOW }
      @Semantics.text
      @EndUserText: { label: 'Template Description', quickInfo: 'Template Description' }
      MDChgProcessTypeDesc,

      /* Associations */
      _Language,
      @Consumption.hidden: true
      _MDChgProcessType
}
union select from         I_MDChgProcTypeDescRapBased  as RAPBasedDescription
  left outer to many join I_MDChgProcTypeDescRAPCustom as RapCustomDescription on RAPBasedDescription.MDChgProcessTypeID like '%'
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,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key RAPBasedDescription.Language,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #LOW }
      @Semantics.text
      @EndUserText: { label: 'Template Description', quickInfo: 'Template Description' }
      RAPBasedDescription.MDChgProcessTypeDesc,

      /* Associations */
      _Language,
      @Consumption.hidden: true
      _MDChgProcessType
}
where
  RAPBasedDescription.MDChgProcessTypeID is null

union select from        I_MDChgProcessTypeDescription as ClassicDescription
  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,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key ClassicDescription.Language,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #LOW }
      @Semantics.text
      @EndUserText: { label: 'Template Description', quickInfo: 'Template Description' }
      ClassicDescription.MDChgProcessTypeDesc,

      /* Associations */
      _Language,
      @Consumption.hidden: true
      _MDChgProcessType
}
where
      RAPBasedDescription.MDChgProcessTypeID  is null
  and RapCustomDescription.MDChgProcessTypeID is null

Learn More