I_MDChgProcessStepTP

DDL: I_MDCHGPROCESSSTEPTP SQL: IMDCHGPROCSTEPTP Type: view TRANSACTIONAL

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 30 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_MasterDataChangeProcessTP _Root _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID

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 (30)

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
@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
  
{
      // 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
}