I_MDChgProcessStep
Master Data Change Process Step
I_MDChgProcessStep is a Basic CDS View that provides data about "Master Data Change Process Step" in SAP S/4HANA. It reads from 1 data source (mdc_d_prcstep) and exposes 24 fields with key field MDChgProcessStepUUID. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| mdc_d_prcstep | mdc_d_prcstep | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_MasterDataChangeProcess | _MasterDataChangeProcess | _MasterDataChangeProcess.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IMDCHGPROCSTEP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Master Data Change Process Step | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.representativeKey | MDChgProcessStepUUID | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.serviceQuality | #B | view |
Fields (24)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MDChgProcessStepUUID | db_key | ||
| MasterDataChangeProcessUUID | parent_key | |||
| MasterDataChangeProcess | process_id | |||
| MDChgProcessStep | step_number | |||
| MDChgProcessStepType | step_type | |||
| MDChgProcessStepDescription | description | |||
| MDChgProcessStepStatus | status | |||
| MDChgProcessStepAdapter | adapter | |||
| MDChgProcessStepAdapterConfign | adapter_config_id | |||
| MDChgProcessStepChkPointIsActv | check_point_active | |||
| MDChgProcessStepOriglNumber | original_step_no | |||
| MDChgProcessStepOriglSqncNmbr | original_step_seq_no | |||
| MDChgProcessStepStartIsReqd | start_requested | |||
| MDChgProcessSrceObjectTypeCode | source_otc | |||
| MDChgProcessStepFilterChain | filter_chain | |||
| MDChgProcessStepStartDateTime | started_at | |||
| MDChgProcessStepFinishDateTime | finished_at | |||
| MDChgProcessStepConfign | process_config_uuid | |||
| MDChgProcessStpOwnConfignIsRqd | use_own_config | |||
| MDChgProcessStepWrkflwDefID | scp_workflow_definition_id | |||
| MDChgProcessStepWrkflwHandle | scp_workflow_handle | |||
| MDChgProcessStepWrkflwSts | scp_workflow_status | |||
| MDChgProcessStepWrkflwOvrlDcsn | scp_workflow_decision | |||
| _MasterDataChangeProcess | _MasterDataChangeProcess |
@AbapCatalog.sqlViewName: 'IMDCHGPROCSTEP'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Data Change Process Step'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MDChgProcessStepUUID'
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #M, serviceQuality: #B }
@ObjectModel.alternativeKey: [{ id : 'MDCHGPROCESSSTEP', uniqueness : #UNIQUE_IF_NOT_INITIAL, element : ['MASTERDATACHANGEPROCESS', 'MDCHGPROCESSSTEP'] }]
define view I_MDChgProcessStep
as select from mdc_d_prcstep
association [1..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on _MasterDataChangeProcess.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
{
// key
key db_key as MDChgProcessStepUUID,
// data
parent_key as MasterDataChangeProcessUUID,
process_id as MasterDataChangeProcess,
step_number as MDChgProcessStep,
step_type as MDChgProcessStepType,
@Semantics.text: true
description as MDChgProcessStepDescription,
status as MDChgProcessStepStatus,
adapter as MDChgProcessStepAdapter,
adapter_config_id as MDChgProcessStepAdapterConfign,
check_point_active as MDChgProcessStepChkPointIsActv,
original_step_no as MDChgProcessStepOriglNumber,
original_step_seq_no as MDChgProcessStepOriglSqncNmbr,
start_requested as MDChgProcessStepStartIsReqd,
source_otc as MDChgProcessSrceObjectTypeCode,
filter_chain as MDChgProcessStepFilterChain,
started_at as MDChgProcessStepStartDateTime,
finished_at as MDChgProcessStepFinishDateTime,
process_config_uuid as MDChgProcessStepConfign,
use_own_config as MDChgProcessStpOwnConfignIsRqd,
@ObjectModel.readOnly: true
scp_workflow_definition_id as MDChgProcessStepWrkflwDefID,
scp_workflow_handle as MDChgProcessStepWrkflwHandle,
scp_workflow_status as MDChgProcessStepWrkflwSts,
scp_workflow_decision as MDChgProcessStepWrkflwOvrlDcsn,
// associations
_MasterDataChangeProcess
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MDC_D_PRCSTEP"
],
"ASSOCIATED":
[
"I_MASTERDATACHANGEPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA