I_MASTERDATACHANGEPROCESS

CDS View

Master Data Change Process

I_MASTERDATACHANGEPROCESS is a CDS View in S/4HANA. Master Data Change Process. It contains 38 fields. 21 CDS views read from this table.

Used by 21 CDS view(s) 38 fields

CDS Views using this table (21)

ViewTypeJoinVDMDescription
C_MDChgProcessStepDescription view_entity from CONSUMPTION Step descriptions of a process
I_BPChangeProcessGov view from BASIC Master Data Change Process (Governance)
I_BPHierarchyChangeProcessVH view_entity from Value Help for BP Hierarchy Process IDs
I_BPHierChangeProcessGov view_entity from Change Process (Governance) of BPH
I_BPHierNodeChangeProcessGov view_entity from Change Process (Gov) of BP Hierarchy
I_BPProcessKPIRecordType view_entity inner TRANSACTIONAL MD Chg Proc Record Type KPI of a Record
I_BPRelshpChangeProcessGov view_entity from TRANSACTIONAL Business Partner Relationship Change Process Governance
I_MasterDataChangeProcessEnhcd view from COMPOSITE MD Change Process Enhanced
I_MasterDataChangeProcessVH view from BASIC Master Data Change Process Value Help
I_MDChangeProcessIsIdle view from BASIC MD Change Process Status Idle
I_MDChangeProcessProgressRatio view_entity from MD Change Process Progress Ratio
I_MDChangeProcessVariant view_entity from BASIC Variant Definition
I_MDChgProcessActivatedProcess view_entity from BASIC Activated processes
I_MDChgProcessMatchGroupRecord view inner COMPOSITE MD Consolidation Match Group Record
I_MDChgProcessMatchGroupTP view_entity inner TRANSACTIONAL Master Data Consolidation: Match Group
I_MDChgProcessMatchScore view_entity inner COMPOSITE MDC Match Score for matching pairs
I_MDChgProcessRelatedProcess view from BASIC MD Change Process Related Processes
I_MDChgProcessRelatedProcess view union BASIC MD Change Process Related Processes
I_MDChgProcessStatusStateCode view from BASIC MD Change Process Status State Code
I_MDChgProcMatchGrpRecdCount view_entity inner COMPOSITE MD Cons Match Group Rec Count
P_MDChangeProcessLastStep view from BASIC Helper view for process last step

Fields (38)

KeyField CDS FieldsUsed in Views
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID 8
MasterDataChangeProcess MasterDataChangeProcess 2
MasterDataChangeProcessDueDate MasterDataChangeProcessDueDate 2
MasterDataChangeProcessReason MasterDataChangeProcessReason 2
MDChangeProcessPriority MDChangeProcessPriority 2
MDChgProcessChangeDate MDChgProcessChangeDate 1
MDChgProcessChangeTime MDChgProcessChangeTime 1
MDChgProcessChkPointIsActive MDChgProcessChkPointIsActive 1
MDChgProcessCompletionIsReqd MDChgProcessCompletionIsReqd 1
MDChgProcessCreationDate MDChgProcessCreationDate 1
MDChgProcessCreationTime MDChgProcessCreationTime 1
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber 6
MDChgProcessDelSrceDataIsRqd MDChgProcessDelSrceDataIsRqd 1
MDChgProcessDescription MDChgProcessDescription 5
MDChgProcessDuplicateStrategy MDChgProcessDuplicateStrategy 1
MDChgProcessErrorsAreLogged MDChgProcessErrorsAreLogged 1
MDChgProcessFilterChain MDChgProcessFilterChain 1
MDChgProcessFinalDateTime MDChgProcessFinalDateTime 1
MDChgProcessFinishDate MDChgProcessFinishDate 1
MDChgProcessFinishTime MDChgProcessFinishTime 1
MDChgProcessGoal MDChgProcessGoal 8
MDChgProcessIsErased MDChgProcessIsErased 5
MDChgProcessIsFinalized MDChgProcessIsFinalized 5
MDChgProcessIsInitialized MDChgProcessIsInitialized 1
MDChgProcessIsReliable MDChgProcessIsReliable 1
MDChgProcessIsStarted MDChgProcessIsStarted 5
MDChgProcessLastActKey MDChgProcessLastActKey 1
MDChgProcessLastStepIsFinished MDChgProcessLastStepIsFinished 5
MDChgProcessNextStpAtDateTime MDChgProcessNextStpAtDateTime 1
MDChgProcessPredecessor MDChgProcessPredecessor 1
MDChgProcessRequestor MDChgProcessRequestor 5
MDChgProcessSrceDeletionIsRqd MDChgProcessSrceDeletionIsRqd 1
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode 6
MDChgProcessStatus MDChgProcessStatus 5
MDChgProcessTypeID MDChgProcessTypeID 5
MDChgProcessUpdateToken MDChgProcessUpdateToken 1
MDChgProcessWorkflowTemplate MDChgProcessWorkflowTemplate 1
MDChgProcessWrkFlwDeltnIsRqd MDChgProcessWrkFlwDeltnIsRqd 1 
@AbapCatalog.sqlViewName: 'IMDCHGPROCESS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Data Change Process'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MasterDataChangeProcessUUID'
@ObjectModel.semanticKey: 'MasterDataChangeProcess'
@Metadata.allowExtensions:true
@AbapCatalog.preserveKey:true

@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #M, serviceQuality: #B }

@ObjectModel.alternativeKey: [{
        id : 'MASTERDATACHANGEPROCESS',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,
        element : ['MASTERDATACHANGEPROCESS']
    }]

define view I_MasterDataChangeProcess
  as select from mdc_d_prcroot as _Process
  //    inner join   I_MDChgProcessAuthorityCheck as _Auth on _Auth.MasterDataChangeProcessUUID = _Process.db_key


  association [1..1] to I_MDChgProcessAuthorityCheck as _Auth                  on _Auth.MasterDataChangeProcessUUID = _Process.db_key
  association [0..*] to I_MDChgProcessStep           as _MDChgProcessStep      on _MDChgProcessStep.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [0..*] to I_MDChangeProcessSource      as _MDChangeProcessSource on _MDChangeProcessSource.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID



{
      // key

  key _Process.db_key                      as MasterDataChangeProcessUUID,
      // data

      _Process.id                          as MasterDataChangeProcess,
      @Semantics.text: true
      _Process.description                 as MDChgProcessDescription,
      _Process.type_id                     as MDChgProcessTypeID,
      _Process.goal                        as MDChgProcessGoal,
      _Process.status                      as MDChgProcessStatus,
      _Process.source_otc                  as MDChgProcessSrceObjectTypeCode,
      _Process.workflow                    as MDChgProcessWorkflowTemplate,
      _Process.requestor                   as MDChgProcessRequestor,
      _Process.delete_source               as MDChgProcessDelSrceDataIsRqd,
      _Process.create_date                 as MDChgProcessCreationDate,
      _Process.create_time                 as MDChgProcessCreationTime,
      _Process.change_date                 as MDChgProcessChangeDate,
      _Process.change_time                 as MDChgProcessChangeTime,
      _Process.finish_date                 as MDChgProcessFinishDate,
      _Process.finish_time                 as MDChgProcessFinishTime,
      _Process.update_counter              as MDChgProcessUpdateToken,
      _Process.started                     as MDChgProcessIsStarted,
      _Process.initialized                 as MDChgProcessIsInitialized,
      _Process.finalized                   as MDChgProcessIsFinalized,
      _Process.last_step_finished          as MDChgProcessLastStepIsFinished,
      _Process.current_step_no             as MDChgProcessCurrentStepNumber,
      _Process.check_point_active          as MDChgProcessChkPointIsActive,
      _Process.complete_requested          as MDChgProcessCompletionIsReqd,
      _Process.wf_delete_requested         as MDChgProcessWrkFlwDeltnIsRqd,
      _Process.src_delete_requested        as MDChgProcessSrceDeletionIsRqd,
      _Process.filter_chain                as MDChgProcessFilterChain,
      _Process.log_error                   as MDChgProcessErrorsAreLogged,
      _Process.last_act_key                as MDChgProcessLastActKey,
      _Process.predecessor_id              as MDChgProcessPredecessor,
      _Process.finalizing_at               as MDChgProcessFinalDateTime,
      _Process.next_step_scheduled_at      as MDChgProcessNextStpAtDateTime,
      _Process.duplicate_strategy          as MDChgProcessDuplicateStrategy,
      _Process.reliable                    as MDChgProcessIsReliable,
      _Process.erased                      as MDChgProcessIsErased,
      _Process.protection_reason           as MDChgProcessProtectionReason,
      _Process.due_date                    as MasterDataChangeProcessDueDate,
      _Process.reason                      as MasterDataChangeProcessReason,
      _Process.priority                    as MDChangeProcessPriority,
      _Process.referenced_federation_token as MDChgProcRefcdFederationToken,
      _Process.referenced_fed_proc_step    as MDChgProcRefcdFederationStp,
      _Process.federation_proc_bus_system  as MDChgProcFederationBusSystName,
      //    associations

      _MDChgProcessStep,
      _MDChangeProcessSource

}
where
  _Auth.MasterDataChangeProcessUUID is not null

Learn More