I_MDCHANGEPROCESSTYPEUNION

CDS View

Master Data Change Process Type

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

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_MDChangeProcessTypeVH view from COMPOSITE Master Data Change Process Type VH
I_MDChgProcessTypeText view inner COMPOSITE MD Change Process Type - Text
I_MDChgProcTemplateStepUnion view_entity inner MD Change Process Template Step Union
I_MDChgProcTemplateStepUnionT view_entity inner MD Chg Process Template Step Union Text 
@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.MDChgProcessSrceObjectTypeCode =    _prctypc.MDChgProcessSrceObjectTypeCode
                                                                   and _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'

Learn More