I_MASTERDATACHANGEPROCESSTP

CDS View

Master Data Change Proc

I_MASTERDATACHANGEPROCESSTP is a CDS View in S/4HANA. Master Data Change Proc. It contains 43 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 43 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_MasterDataChangeProcess view_entity from CONSUMPTION Master Data Change Process
C_MasterDataMyBPChangeProcess view_entity from CONSUMPTION Master Data My BP Change Process
C_MDChangeProcessCriticality view_entity from CONSUMPTION MD Change Process Criticality

Fields (43)

KeyField CDS FieldsUsed in Views
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID 2
MasterDataChangeProcess MasterDataChangeProcess 2
MasterDataChangeProcessDueDate MasterDataChangeProcessDueDate 2
MasterDataChangeProcessReason MasterDataChangeProcessReason 2
MDChangeProcessPriority MDChangeProcessPriority 2
MDChangeProcessRejectionReason MDChangeProcessRejectionReason 1
MDChgProcessChangeDate MDChgProcessChangeDate 2
MDChgProcessChangeTime MDChgProcessChangeTime 2
MDChgProcessChkPointIsActive MDChgProcessChkPointIsActive 2
MDChgProcessCompletionIsReqd MDChgProcessCompletionIsReqd 2
MDChgProcessCreationDate MDChgProcessCreationDate 2
MDChgProcessCreationTime MDChgProcessCreationTime 2
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber 2
MDChgProcessDelSrceDataIsRqd MDChgProcessDelSrceDataIsRqd 2
MDChgProcessDescription MDChgProcessDescription 2
MDChgProcessDuplicateStrategy MDChgProcessDuplicateStrategy 2
MDChgProcessErrorsAreLogged MDChgProcessErrorsAreLogged 2
MDChgProcessFilterChain MDChgProcessFilterChain 2
MDChgProcessFinalDateTime MDChgProcessFinalDateTime 2
MDChgProcessFinishDate MDChgProcessFinishDate 2
MDChgProcessFinishTime MDChgProcessFinishTime 2
MDChgProcessGoal MDChgProcessGoal 2
MDChgProcessIsErased MDChgProcessIsErased 2
MDChgProcessIsFinalized MDChgProcessIsFinalized 2
MDChgProcessIsInitialized MDChgProcessIsInitialized 2
MDChgProcessIsReliable MDChgProcessIsReliable 2
MDChgProcessIsStarted MDChgProcessIsStarted 2
MDChgProcessLastActKey MDChgProcessLastActKey 2
MDChgProcessLastStepIsFinished MDChgProcessLastStepIsFinished 2
MDChgProcessNextStpAtDateTime MDChgProcessNextStpAtDateTime 2
MDChgProcessPredecessor MDChgProcessPredecessor 2
MDChgProcessProtectionReason MDChgProcessProtectionReason 2
MDChgProcessRequestor MDChgProcessRequestor 1
MDChgProcessSrceDeletionIsRqd MDChgProcessSrceDeletionIsRqd 2
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode 2
MDChgProcessStatus MDChgProcessStatus 2
MDChgProcessTypeID MDChgProcessTypeID 2
MDChgProcessUpdateToken MDChgProcessUpdateToken 2
MDChgProcessWorkflowTemplate MDChgProcessWorkflowTemplate 2
MDChgProcessWrkFlwDeltnIsRqd MDChgProcessWrkFlwDeltnIsRqd 2
MDChgProcFederationBusSystName MDChgProcFederationBusSystName 1
MDChgProcRefcdFederationStp MDChgProcRefcdFederationStp 1
MDChgProcRefcdFederationToken MDChgProcRefcdFederationToken 1 
@AbapCatalog.sqlViewName: 'IMDCHGPROCESSTP'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Data Change Proc'

@ObjectModel: {
  sapObjectNodeType.name: 'MasterDataChangeProcess',
  compositionRoot: true,
  writeActivePersistence: 'TMDCHGPROCESS_W',
  transactionalProcessingEnabled: true,
  createEnabled,
  updateEnabled,
  deleteEnabled,
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #B,
    sizeCategory: #M
  },
  alternativeKey: [{
//    id: 'MASTERDATACHANGEPROCESS',

    uniqueness: #UNIQUE_IF_NOT_INITIAL,
    element: ['MasterDataChangeProcess']
  }],
  entityChangeStateId: 'MDChgProcessUpdateToken'
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view I_MasterDataChangeProcessTP
  as select from mdc_d_prcroot as _Process

  association [1..1] to I_MDChgProcessAuthorityCheck as _Auth   on _Auth.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [0..*] to I_MDChangeProcessSourceTP    as _Source on _Source.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [0..*] to I_MDChgProcessStepTP         as _Step   on _Step.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID  
{
  key _Process.db_key                                      as MasterDataChangeProcessUUID,
      _Process.id                                          as MasterDataChangeProcess,
      _Process.description                                 as MDChgProcessDescription,
      _Process.type_id                                     as MDChgProcessTypeID,
      _Process.goal                                        as MDChgProcessGoal,
      @ObjectModel.readOnly: false
      _Process.status                                      as MDChgProcessStatus,
      _Process.source_otc                                  as MDChgProcessSrceObjectTypeCode,
      @ObjectModel.readOnly: true
      _Process.workflow                                    as MDChgProcessWorkflowTemplate,
      @ObjectModel.readOnly: true
      _Process.requestor                                   as MDChgProcessRequestor,
      _Process.delete_source                               as MDChgProcessDelSrceDataIsRqd,
      @ObjectModel.readOnly: true
      _Process.create_date                                 as MDChgProcessCreationDate,
      @ObjectModel.readOnly: true
      _Process.create_time                                 as MDChgProcessCreationTime,
      @ObjectModel.readOnly: false
      _Process.change_date                                 as MDChgProcessChangeDate,
      @ObjectModel.readOnly: false
      _Process.change_time                                 as MDChgProcessChangeTime,
      @ObjectModel.readOnly: true
      _Process.finish_date                                 as MDChgProcessFinishDate,
      @ObjectModel.readOnly: true
      _Process.finish_time                                 as MDChgProcessFinishTime,
      @ObjectModel.readOnly: true
      _Process.update_counter                              as MDChgProcessUpdateToken,
      @ObjectModel.readOnly: true
      _Process.started                                     as MDChgProcessIsStarted,
      @ObjectModel.readOnly: true
      _Process.initialized                                 as MDChgProcessIsInitialized,
      @ObjectModel.readOnly: true
      _Process.finalized                                   as MDChgProcessIsFinalized,
      @ObjectModel.readOnly: true
      _Process.last_step_finished                          as MDChgProcessLastStepIsFinished,
      @ObjectModel.readOnly: true
      _Process.current_step_no                             as MDChgProcessCurrentStepNumber,
      @ObjectModel.readOnly: true
      _Process.check_point_active                          as MDChgProcessChkPointIsActive,
      @ObjectModel.readOnly: true
      _Process.complete_requested                          as MDChgProcessCompletionIsReqd,
      @ObjectModel.readOnly: true
      _Process.wf_delete_requested                         as MDChgProcessWrkFlwDeltnIsRqd,
      @ObjectModel.readOnly: true
      _Process.src_delete_requested                        as MDChgProcessSrceDeletionIsRqd,
      @ObjectModel.readOnly: true
      ltrim ( rtrim( _Process.filter_chain, '\\' ), '\\' ) as MDChgProcessFilterChain,
      _Process.log_error                                   as MDChgProcessErrorsAreLogged,
      @ObjectModel.readOnly: true
      _Process.last_act_key                                as MDChgProcessLastActKey,
      _Process.predecessor_id                              as MDChgProcessPredecessor,
      @ObjectModel.readOnly: true
      _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.mass_intention                              as MDChgProcessMassIntention,
      _Process.protection_reason                           as MDChgProcessProtectionReason,
      @ObjectModel.enabled: true
      _Process.due_date                                    as MasterDataChangeProcessDueDate,
      @ObjectModel.enabled: true
      _Process.reason                                      as MasterDataChangeProcessReason,
      @ObjectModel.enabled: true
      _Process.priority                                    as MDChangeProcessPriority,
      _Process.rejection_reason                            as MDChangeProcessRejectionReason,
      _Process.referenced_federation_token                 as MDChgProcRefcdFederationToken,
      _Process.referenced_fed_proc_step                    as MDChgProcRefcdFederationStp,
      _Process.federation_proc_bus_system                  as MDChgProcFederationBusSystName,
      //    associations

      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Source,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Step,
      _Auth
}
where
  _Auth.MasterDataChangeProcessUUID is not null

Learn More