I_MDChangeProcessTypeUnion

DDL: I_MDCHANGEPROCESSTYPEUNION SQL: IMDCHGPROCTYPEU Type: view COMPOSITE Package: MDC_PROCESS_OBJECT

Master Data Change Process Type

I_MDChangeProcessTypeUnion is a Composite CDS View that provides data about "Master Data Change Process Type" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcTemplate) and exposes 19 fields with key field MDChgProcessTypeID. Part of development package MDC_PROCESS_OBJECT.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcTemplate _prctyp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCTYPEU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Master Data Change Process Type view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessTypeID I_MDChgProcTemplate MDChgProcessTypeID
MDChgProcessSrceObjectTypeCode I_MDChgProcTemplate MDChgProcessSrceObjectTypeCode
MDChgProcessWorkflowTemplate I_MDChgProcTemplate MDChgProcessWorkflowTemplate
MDChgProcessDelSrceDataIsRqd I_MDChgProcTemplate MDChgProcessDelSrceDataIsRqd
MDChgProcessGoal I_MDChgProcTemplate MDChgProcessGoal
MDChgProcessIsDefaultMassType I_MDChgProcTemplate MDChgProcTypeIsMassProcgDflt
MDChgProcessTypeID
MDChgProcessSrceObjectTypeCode _prctypc MDChgProcessSrceObjectTypeCode
MDChgProcessWorkflowTemplate _prctypc MDChgProcessWorkflowTemplate
MDChgProcessDelSrceDataIsRqd _prctypc MDChgProcessDelSrceDataIsRqd
MDChgProcessGoal _prctypc MDChgProcessGoal
MDChgProcessIsDefaultMassType _prctypc MDChgProcTypeIsMassProcgDflt
MDChgProcessTypeID
MDChgProcessSrceObjectTypeCode _prctype MDChgProcessSrceObjectTypeCode
MDChgProcessWorkflowTemplate _prctype MDChgProcessWorkflowTemplate
MDChgProcessDelSrceDataIsRqd _prctype MDChgProcessDelSrceDataIsRqd
MDChgProcessGoal _prctype MDChgProcessGoal
MDChgProcessIsDefaultMassType _prctype MDChgProcTypeIsMassProcgDflt
MDChgProcDplRecdStrategyCode _prctype MDChgProcDplRecdStrategyCode 
@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