I_MDChgProcessActivatedProcess

DDL: I_MDCHGPROCESSACTIVATEDPROCESS Type: view_entity BASIC
35 Fields 2 Data Sources

Activated processes

I_MDChgProcessActivatedProcess is a Basic CDS View that provides data about "Activated processes" in SAP S/4HANA. It reads from 2 data sources (mdc_act_acts, I_MasterDataChangeProcess) and exposes 35 fields with key fields MDChgProcessSrceObjectTypeCode, MasterDataChangeProcess.

Data Sources (2)

SourceAliasJoin Type
mdc_act_acts _act inner
I_MasterDataChangeProcess _process from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Activated processes view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessSrceObjectTypeCode mdc_act_acts bo_type SOT Name
KEY MasterDataChangeProcess mdc_act_acts process_id Process Instance ID
MasterDataChangeProcessUUID I_MasterDataChangeProcess MasterDataChangeProcessUUID NodeID
MDChgProcessDescription I_MasterDataChangeProcess MDChgProcessDescription Process Description
MDChgProcessTypeID I_MasterDataChangeProcess MDChgProcessTypeID Process Template
MDChgProcessGoal I_MasterDataChangeProcess MDChgProcessGoal Process Goal
MDChgProcessStatus I_MasterDataChangeProcess MDChgProcessStatus Process Status
MDChgProcessWorkflowTemplate I_MasterDataChangeProcess MDChgProcessWorkflowTemplate Workflow Template
MDChgProcessRequestor I_MasterDataChangeProcess MDChgProcessRequestor Process Requestor
MDChgProcessDelSrceDataIsRqd I_MasterDataChangeProcess MDChgProcessDelSrceDataIsRqd Delete Source
MDChgProcessCreationDate I_MasterDataChangeProcess MDChgProcessCreationDate Time Stamp
MDChgProcessCreationTime I_MasterDataChangeProcess MDChgProcessCreationTime Time
MDChgProcessChangeDate I_MasterDataChangeProcess MDChgProcessChangeDate Time Stamp
MDChgProcessChangeTime I_MasterDataChangeProcess MDChgProcessChangeTime Time Stamp
MDChgProcessFinishDate I_MasterDataChangeProcess MDChgProcessFinishDate Current Date
MDChgProcessFinishTime I_MasterDataChangeProcess MDChgProcessFinishTime Time Stamp
MDChgProcessUpdateToken I_MasterDataChangeProcess MDChgProcessUpdateToken Update Token
MDChgProcessIsStarted I_MasterDataChangeProcess MDChgProcessIsStarted Process Started
MDChgProcessIsInitialized I_MasterDataChangeProcess MDChgProcessIsInitialized Initialized
MDChgProcessIsFinalized I_MasterDataChangeProcess MDChgProcessIsFinalized Finalized
MDChgProcessLastStepIsFinished I_MasterDataChangeProcess MDChgProcessLastStepIsFinished Last Step Finished
MDChgProcessCurrentStepNumber I_MasterDataChangeProcess MDChgProcessCurrentStepNumber Step Number
MDChgProcessChkPointIsActive I_MasterDataChangeProcess MDChgProcessChkPointIsActive Check Point active
MDChgProcessCompletionIsReqd I_MasterDataChangeProcess MDChgProcessCompletionIsReqd Completion Requested
MDChgProcessWrkFlwDeltnIsRqd I_MasterDataChangeProcess MDChgProcessWrkFlwDeltnIsRqd Deletion Requested
MDChgProcessSrceDeletionIsRqd I_MasterDataChangeProcess MDChgProcessSrceDeletionIsRqd Source Deletion
MDChgProcessFilterChain I_MasterDataChangeProcess MDChgProcessFilterChain Filter Chain
MDChgProcessErrorsAreLogged I_MasterDataChangeProcess MDChgProcessErrorsAreLogged Log Error
MDChgProcessLastActKey I_MasterDataChangeProcess MDChgProcessLastActKey Action Key
MDChgProcessPredecessor I_MasterDataChangeProcess MDChgProcessPredecessor Previous Process
MDChgProcessFinalDateTime I_MasterDataChangeProcess MDChgProcessFinalDateTime Process Finalized
MDChgProcessNextStpAtDateTime I_MasterDataChangeProcess MDChgProcessNextStpAtDateTime Scheduled at
MDChgProcessDuplicateStrategy I_MasterDataChangeProcess MDChgProcessDuplicateStrategy Strategy
MDChgProcessIsReliable I_MasterDataChangeProcess MDChgProcessIsReliable Process Reliable
MDChgProcessIsErased I_MasterDataChangeProcess MDChgProcessIsErased Process Erased

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MDChgProcessActivatedProcess.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_MDChgProcessActivatedProcess AS
SELECT
  _act.bo_type AS MDChgProcessSrceObjectTypeCode,
  _act.process_id AS MasterDataChangeProcess,
  _process.MasterDataChangeProcessUUID AS MasterDataChangeProcessUUID,
  _process.MDChgProcessDescription AS MDChgProcessDescription,
  _process.MDChgProcessTypeID AS MDChgProcessTypeID,
  _process.MDChgProcessGoal AS MDChgProcessGoal,
  _process.MDChgProcessStatus AS MDChgProcessStatus,
  _process.MDChgProcessWorkflowTemplate AS MDChgProcessWorkflowTemplate,
  _process.MDChgProcessRequestor AS MDChgProcessRequestor,
  _process.MDChgProcessDelSrceDataIsRqd AS MDChgProcessDelSrceDataIsRqd,
  _process.MDChgProcessCreationDate AS MDChgProcessCreationDate,
  _process.MDChgProcessCreationTime AS MDChgProcessCreationTime,
  _process.MDChgProcessChangeDate AS MDChgProcessChangeDate,
  _process.MDChgProcessChangeTime AS MDChgProcessChangeTime,
  _process.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  _process.MDChgProcessFinishTime AS MDChgProcessFinishTime,
  _process.MDChgProcessUpdateToken AS MDChgProcessUpdateToken,
  _process.MDChgProcessIsStarted AS MDChgProcessIsStarted,
  _process.MDChgProcessIsInitialized AS MDChgProcessIsInitialized,
  _process.MDChgProcessIsFinalized AS MDChgProcessIsFinalized,
  _process.MDChgProcessLastStepIsFinished AS MDChgProcessLastStepIsFinished,
  _process.MDChgProcessCurrentStepNumber AS MDChgProcessCurrentStepNumber,
  _process.MDChgProcessChkPointIsActive AS MDChgProcessChkPointIsActive,
  _process.MDChgProcessCompletionIsReqd AS MDChgProcessCompletionIsReqd,
  _process.MDChgProcessWrkFlwDeltnIsRqd AS MDChgProcessWrkFlwDeltnIsRqd,
  _process.MDChgProcessSrceDeletionIsRqd AS MDChgProcessSrceDeletionIsRqd,
  _process.MDChgProcessFilterChain AS MDChgProcessFilterChain,
  _process.MDChgProcessErrorsAreLogged AS MDChgProcessErrorsAreLogged,
  _process.MDChgProcessLastActKey AS MDChgProcessLastActKey,
  _process.MDChgProcessPredecessor AS MDChgProcessPredecessor,
  _process.MDChgProcessFinalDateTime AS MDChgProcessFinalDateTime,
  _process.MDChgProcessNextStpAtDateTime AS MDChgProcessNextStpAtDateTime,
  _process.MDChgProcessDuplicateStrategy AS MDChgProcessDuplicateStrategy,
  _process.MDChgProcessIsReliable AS MDChgProcessIsReliable,
  _process.MDChgProcessIsErased AS MDChgProcessIsErased
FROM I_MasterDataChangeProcess AS _process
INNER JOIN mdc_act_acts AS _act ON /* join condition not captured in parsed metadata */
;

Learn More