I_MDChangeProcessTypeUnion

DDL: I_MDCHANGEPROCESSTYPEUNION SQL: IMDCHGPROCTYPEU Type: view COMPOSITE

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.

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.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