I_MDChangeProcessModelTable

DDL: I_MDCHANGEPROCESSMODELTABLE SQL: IMDCHGPROCMDLTBL Type: view BASIC Package: MDC_PROCESS_OBJECT

Process model table

I_MDChangeProcessModelTable is a Basic CDS View that provides data about "Process model table" in SAP S/4HANA. It reads from 4 data sources (mdc_modelctables, mdc_modelctablet, mdc_model_tables, mdc_model_tablet) and exposes 2 fields with key fields MDChgProcessSrceObjectTypeCode, MDChgProcessModelTableName. Part of development package MDC_PROCESS_OBJECT.

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
mdc_modelctables CustomTable left_outer
mdc_modelctablet CustomTableAlias left_outer
mdc_model_tables Table from
mdc_model_tablet TableAlias left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCMDLTBL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Process model table view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessSrceObjectTypeCode mdc_model_tables bo_type
KEY MDChgProcessModelTableName mdc_model_tables table_name 
@AbapCatalog.sqlViewName: 'IMDCHGPROCMDLTBL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Process model table'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true
define view I_MDChangeProcessModelTable
  as select from    mdc_model_tables as Table
    left outer join mdc_modelctables as CustomTable      on  CustomTable.bo_type    = Table.bo_type
                                                         and CustomTable.table_name = Table.table_name
    left outer join mdc_model_tablet as TableAlias       on  TableAlias.bo_type    = Table.bo_type
                                                         and TableAlias.table_name = Table.table_name
                                                         and TableAlias.langu      = $session.system_language
    left outer join mdc_modelctablet as CustomTableAlias on  CustomTableAlias.bo_type    = Table.bo_type
                                                         and CustomTableAlias.table_name = Table.table_name
                                                         and CustomTableAlias.langu      = $session.system_language
{
      @Consumption.filter.hidden
  key Table.bo_type    as MDChgProcessSrceObjectTypeCode,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key Table.table_name as MDChgProcessModelTableName,
      @Semantics.text: true
      @EndUserText.label: 'Table Description'
      case when CustomTableAlias.table_alias is null then TableAlias.table_alias
           else CustomTableAlias.table_alias
      end              as MDChangeProcModelTableDesc
}
where
  (
        CustomTable.obscured is initial
    or  CustomTable.obscured is null
    and Table.obscured       is initial
    or  Table.table_name     = 'BUT020'
    or  Table.table_name     = 'BUT052'
  )
  and   Table.process_data   is not initial

Learn More