I_MDCHANGEPROCESSMODELTABLE

CDS View

Process model table

I_MDCHANGEPROCESSMODELTABLE is a CDS View in S/4HANA. Process model table. It contains 3 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 3 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_MDChangeProcessModelField view from COMPOSITE Process model field
I_MDChangeProcessModelField view left_outer COMPOSITE Process model field
I_MDChangeProcessModelField view union COMPOSITE Process model field
I_MDChangeProcessModelFieldVH view from BASIC Process model field value help
I_MDChgProcStepEditKPI view left_outer BASIC MD Change Process Step Edit KPI
I_MDChgProcStepUpdateKPI view left_outer BASIC MD Change Process Step Update KPI

Fields (3)

KeyField CDS FieldsUsed in Views
KEY MDChgProcessModelTableName MDChangeProcessStepTable,MDChgProcessModelTableName 4
KEY MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode 2
MDChangeProcModelTableDesc MDChangeProcModelTableDesc 2 
@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
  and   Table.table_name     <> 'BUT053'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MDC_MODELCTABLES",
"MDC_MODELCTABLET",
"MDC_MODEL_TABLES",
"MDC_MODEL_TABLET"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More