I_MDCHANGEPROCESSTYPEUNION

CDS View

Master Data Change Process Type

I_MDCHANGEPROCESSTYPEUNION is a CDS View in S/4HANA. Master Data Change Process Type. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDChangeProcessTypeVH view from COMPOSITE Master Data Change Process Type VH 
@AbapCatalog.sqlViewName: 'IMDCHGPROCTYPEU'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Master Data Change Process Type'
@ObjectModel: {
    resultSet.sizeCategory: #XS,
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #L,
    usageType.dataClass: #MIXED }
@VDM.viewType: #COMPOSITE
define view I_MDChangeProcessTypeUnion
  as select from            I_MDChgProcTemplate       as _prctyp
    left outer to many join I_MDChgProcRAPBasedSwitch as _switch on  (
        _switch.MDChgProcessSuiteObjTypeCode                                                               = _prctyp.MDChgProcessSrceObjectTypeCode
        or _switch.MDChgProcessSrceObjectTypeCode                                                          = _prctyp.MDChgProcessSrceObjectTypeCode
      )
{
  key _prctyp.MDChgProcessTypeID,
      _prctyp.MDChgProcessSrceObjectTypeCode,
      _prctyp.MDChgProcessWorkflowTemplate,
      _prctyp.MDChgProcessDelSrceDataIsRqd,
      _prctyp.MDChgProcessGoal,
      _prctyp.MDChgProcTypeIsMassProcgDflt as MDChgProcessIsDefaultMassType,
      _prctyp.MDChgProcDplRecdStrategyCode
}
where
  _switch.MDChgProcRAPBsdSwitchIsActive <> 'X'
union select distinct from I_MDChgProcTmplRAPBasedExtd as _prctypc
  left outer to many join  I_MDChgProcRAPBasedSwitch   as _switch on  (
        _switch.MDChgProcessSuiteObjTypeCode                                                               = _prctypc.MDChgProcessSrceObjectTypeCode
        or _switch.MDChgProcessSrceObjectTypeCode                                                          = _prctypc.MDChgProcessSrceObjectTypeCode
    )

{
  key _prctypc.MDChgProcessTypeID,
      _prctypc.MDChgProcessSrceObjectTypeCode,
      _prctypc.MDChgProcessWorkflowTemplate,
      _prctypc.MDChgProcessDelSrceDataIsRqd,
      _prctypc.MDChgProcessGoal,
      _prctypc.MDChgProcTypeIsMassProcgDflt as MDChgProcessIsDefaultMassType,
      _prctypc.MDChgProcDplRecdStrategyCode
}
where
  _switch.MDChgProcRAPBsdSwitchIsActive = 'X'
union select distinct from I_MDChgProcTmplRAPBased     as _prctype
  left outer to many join  I_MDChgProcTmplRAPBasedExtd as _prctypc on _prctype.MDChgProcessTypeID like '%'
  left outer to many join  I_MDChgProcRAPBasedSwitch   as _switch  on  (
        _switch.MDChgProcessSuiteObjTypeCode                                                               = _prctype.MDChgProcessSrceObjectTypeCode
        or _switch.MDChgProcessSrceObjectTypeCode                                                          = _prctype.MDChgProcessSrceObjectTypeCode
     )
{
  key _prctype.MDChgProcessTypeID,
      _prctype.MDChgProcessSrceObjectTypeCode,
      _prctype.MDChgProcessWorkflowTemplate,
      _prctype.MDChgProcessDelSrceDataIsRqd,
      _prctype.MDChgProcessGoal,
      _prctype.MDChgProcTypeIsMassProcgDflt as MDChgProcessIsDefaultMassType,
      _prctype.MDChgProcDplRecdStrategyCode
}
where
      _prctypc.MDChgProcessTypeID           is null
  and _switch.MDChgProcRAPBsdSwitchIsActive = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDCHGPROCRAPBASEDSWITCH",
"I_MDCHGPROCTEMPLATE",
"I_MDCHGPROCTMPLRAPBASED",
"I_MDCHGPROCTMPLRAPBASEDEXTD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More