I_MDChgProcModifdObjects

DDL: I_MDCHGPROCMODIFDOBJECTS SQL: IMDCHGPROCMOBJS Type: view BASIC

MD Change Process Modified Objects

I_MDChgProcModifdObjects is a Basic CDS View that provides data about "MD Change Process Modified Objects" in SAP S/4HANA. It reads from 1 data source (mdc_modified) and exposes 7 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceObject, MDChgProcessSrceSystem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mdc_modified modified from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
[1..1] I_MDChgProcessStepEnhcd _MDChgProcessStepEnhcd _MDChgProcessStepEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _MDChgProcessStepEnhcd.MDChgProcessStep = $projection.MDChgProcessStep

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCMOBJS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
ObjectModel.representativeKey MDChgProcessSrceObject view
EndUserText.label MD Change Process Modified Objects view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess mdc_modified process_id
KEY MDChgProcessStep mdc_modified process_step_no
KEY MDChgProcessSrceObject mdc_modified source_id
KEY MDChgProcessSrceSystem mdc_modified source_system
MDChgProcModifdObjectsCount
_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd
_MDChgProcessStepEnhcd _MDChgProcessStepEnhcd
@AbapCatalog.sqlViewName: 'IMDCHGPROCMOBJS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #M, serviceQuality: #C }
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MDChgProcessSrceObject'
@EndUserText.label: 'MD Change Process Modified Objects'
define view I_MDChgProcModifdObjects
  as select from mdc_modified  as modified
    join         mdc_d_prcroot as root on modified.process_id = root.id
  association [1..1] to I_MasterDataChangeProcessEnhcd as _MasterDataChangeProcessEnhcd on  _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
  association [1..1] to I_MDChgProcessStepEnhcd        as _MDChgProcessStepEnhcd        on  _MDChgProcessStepEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
                                                                                        and _MDChgProcessStepEnhcd.MDChgProcessStep        = $projection.MDChgProcessStep
{
      //mdc_modified

  key modified.process_id      as MasterDataChangeProcess,
  key modified.process_step_no as MDChgProcessStep,
  key modified.source_id       as MDChgProcessSrceObject,
  key modified.source_system   as MDChgProcessSrceSystem,

      cast (1 as abap.int4 )   as MDChgProcModifdObjectsCount,


      // I_MDChgProcModifdSrceObjects

      _MasterDataChangeProcessEnhcd,
      _MDChgProcessStepEnhcd
}