I_MDChgProcessRelatedProcess

DDL: I_MDCHGPROCESSRELATEDPROCESS SQL: MDPROCRELCPROC Type: view BASIC

MD Change Process Related Processes

I_MDChgProcessRelatedProcess is a Basic CDS View that provides data about "MD Change Process Related Processes" in SAP S/4HANA. It reads from 2 data sources (I_MasterDataChangeProcess, I_MasterDataChangeProcess) and exposes 13 fields with key fields MasterDataChangeProcessUUID, MDChangeProcRelatedProcessUUID, MDChangeProcRelatedProcessUUID.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_MasterDataChangeProcess Root from
I_MasterDataChangeProcess Root union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName MDPROCRELCPROC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
EndUserText.label MD Change Process Related Processes view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID I_MasterDataChangeProcess MasterDataChangeProcessUUID
KEY MDChangeProcRelatedProcessUUID _Predecessor MasterDataChangeProcessUUID
MasterDataChangeProcess _Predecessor MasterDataChangeProcess
MDChangeProcessIsPredecessor
MDChgProcessTypeID _Predecessor MDChgProcessTypeID
MDChgProcessCurrentStepNumber _Predecessor MDChgProcessCurrentStepNumber
MasterDataChangeProcessUUID
KEY MDChangeProcRelatedProcessUUID _Successor MasterDataChangeProcessUUID
MasterDataChangeProcess _Successor MasterDataChangeProcess
MDChangeProcessIsPredecessor
MDChgProcessTypeID _Successor MDChgProcessTypeID
MDChgProcessCurrentStepNumber _Successor MDChgProcessCurrentStepNumber
MDChgProcessSrceObjectTypeCode I_MasterDataChangeProcess MDChgProcessSrceObjectTypeCode 
@AbapCatalog.sqlViewName: 'MDPROCRELCPROC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #D, sizeCategory: #L }
@VDM.viewType: #BASIC
@EndUserText.label: 'MD Change Process Related Processes'
define view I_MDChgProcessRelatedProcess
  as select from I_MasterDataChangeProcess as Root
    join         I_MasterDataChangeProcess as _Predecessor on _Predecessor.MasterDataChangeProcess = Root.MDChgProcessPredecessor
{
  key Root.MasterDataChangeProcessUUID,
  key _Predecessor.MasterDataChangeProcessUUID    as MDChangeProcRelatedProcessUUID,
      _Predecessor.MasterDataChangeProcess,
      @ObjectModel.readOnly: true
      cast( 'X' as abap_boolean preserving type ) as MDChangeProcessIsPredecessor,
      _Predecessor.MDChgProcessTypeID,
      _Predecessor.MDChgProcessCurrentStepNumber,
      Root.MDChgProcessSrceObjectTypeCode
}
union select from I_MasterDataChangeProcess as Root
  join            I_MasterDataChangeProcess as _Successor on _Successor.MDChgProcessPredecessor = Root.MasterDataChangeProcess
{
  key Root.MasterDataChangeProcessUUID,
  key _Successor.MasterDataChangeProcessUUID      as MDChangeProcRelatedProcessUUID,
      _Successor.MasterDataChangeProcess,
      @ObjectModel.readOnly: true
      cast( ' ' as abap_boolean preserving type ) as MDChangeProcessIsPredecessor,
      _Successor.MDChgProcessTypeID,
      _Successor.MDChgProcessCurrentStepNumber,
      Root.MDChgProcessSrceObjectTypeCode
}

Learn More