I_MDChgProcessStep

DDL: I_MDCHGPROCESSSTEP SQL: IMDCHGPROCSTEP Type: view BASIC

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)

SourceAliasJoin Type
mdc_d_prcstep mdc_d_prcstep from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MasterDataChangeProcess _MasterDataChangeProcess _MasterDataChangeProcess.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/