I_MDChgProcessStepTP

DDL: I_MDCHGPROCESSSTEPTP SQL: IMDCHGPROCSTEPTP Type: view TRANSACTIONAL Package: MDC_PROCESS_OBJECT

Master Data Change Process Step

I_MDChgProcessStepTP is a Transactional 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 31 fields with key field MDChgProcessStepUUID. It has 2 associations to related views. Part of development package MDC_PROCESS_OBJECT.

Data Sources (1)

SourceAliasJoin Type
mdc_d_prcstep mdc_d_prcstep from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MasterDataChangeProcessTP _Root _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
[1..1] C_MDChgProcStepProgressRatio _StepProgress $projection.MDChgProcessStepUUID = _StepProgress.MDChgProcessStepUUID and $projection.MDChgProcessStep = _StepProgress.MDChgProcessStep

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCSTEPTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Data Change Process Step view
ObjectModel.writeActivePersistence TMDCHGPROCSTEP_W view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (31)

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
MDChgProcIsAdhocStep ad_hoc_step
MDChgProcStepIsRollbackAllowed
MDChgProcessStepActionControl action_ctrl
MDChgProcessStepAuthznGroup begru
MDChgProcessStepWrkflwDefID scp_workflow_definition_id
MDChgProcessStepWrkflwHandle scp_workflow_handle
MDChgProcessStepWrkflwSts scp_workflow_status
MDChgProcessStepWrkflwOvrlDcsn scp_workflow_decision
MDChgProcessStepLocalWorkflow local_workflow
MDChgProcStpLoclWorkflowStatus local_workflow_status
_Root _Root
_StepProgress _StepProgress
@AbapCatalog.sqlViewName: 'IMDCHGPROCSTEPTP'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Data Change Process Step'

@ObjectModel.writeActivePersistence: 'TMDCHGPROCSTEP_W'

@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled

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

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.alternativeKey: [{
        id : 'MDCHGPROCESSSTEP',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,
        element : ['MASTERDATACHANGEPROCESS', 'MDCHGPROCESSSTEP']
    }]

define view I_MDChgProcessStepTP
  as select from mdc_d_prcstep
  association [1..1] to I_MasterDataChangeProcessTP  as _Root         on  _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [1..1] to C_MDChgProcStepProgressRatio as _StepProgress on  $projection.MDChgProcessStepUUID = _StepProgress.MDChgProcessStepUUID
                                                                      and $projection.MDChgProcessStep     = _StepProgress.MDChgProcessStep
{
      // key

  key db_key                                 as MDChgProcessStepUUID,
      // data

      parent_key                             as MasterDataChangeProcessUUID,
      process_id                             as MasterDataChangeProcess,
      @ObjectModel.readOnly: true
      step_number                            as MDChgProcessStep,
      @ObjectModel.readOnly: true
      step_type                              as MDChgProcessStepType,
      //use p_mdchgprocstepdescr for language dependent description of Steps from Step Type !

      //Language independent description of Step

      description                            as MDChgProcessStepDescription,
      @ObjectModel.readOnly: true
      status                                 as MDChgProcessStepStatus,
      adapter                                as MDChgProcessStepAdapter,
      adapter_config_id                      as MDChgProcessStepAdapterConfign,
      check_point_active                     as MDChgProcessStepChkPointIsActv,
      @ObjectModel.readOnly: true
      original_step_no                       as MDChgProcessStepOriglNumber,
      @ObjectModel.readOnly: true
      original_step_seq_no                   as MDChgProcessStepOriglSqncNmbr,
      @ObjectModel.readOnly: true
      start_requested                        as MDChgProcessStepStartIsReqd,
      @ObjectModel.readOnly: true
      source_otc                             as MDChgProcessSrceObjectTypeCode,
      @ObjectModel.readOnly: true
      filter_chain                           as MDChgProcessStepFilterChain,
      @ObjectModel.readOnly: true
      started_at                             as MDChgProcessStepStartDateTime,
      @ObjectModel.readOnly: true
      finished_at                            as MDChgProcessStepFinishDateTime,
      process_config_uuid                    as MDChgProcessStepConfign,
      use_own_config                         as MDChgProcessStpOwnConfignIsRqd,
      ad_hoc_step                            as MDChgProcIsAdhocStep,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROCESS_STEP_CALC_EXIT'
      cast( 'X' as boole_d preserving type ) as MDChgProcStepIsRollbackAllowed,
      action_ctrl                            as MDChgProcessStepActionControl,
      begru                                  as MDChgProcessStepAuthznGroup,
      @ObjectModel.readOnly: true
      scp_workflow_definition_id             as MDChgProcessStepWrkflwDefID,
      scp_workflow_handle                    as MDChgProcessStepWrkflwHandle,
      scp_workflow_status                    as MDChgProcessStepWrkflwSts,
      scp_workflow_decision                  as MDChgProcessStepWrkflwOvrlDcsn,
      local_workflow                         as MDChgProcessStepLocalWorkflow,
      local_workflow_status                  as MDChgProcStpLoclWorkflowStatus,
      // associations

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _Root,
      _StepProgress
}