I_MDCHANGEPROCESSSOURCE

CDS View

Master Data Change Process Source

I_MDCHANGEPROCESSSOURCE is a CDS View in S/4HANA. Master Data Change Process Source. It contains 2 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_BPHierarchySourceProcess view_entity from BP Hierarchy Source in Process Status
I_BPHierNodeSourceProcess view_entity from Src of BP Hierarchy Node in Prc Status
I_BusinessPartnerSourceProcess view from BASIC Core View: Business Partner Source In Process Status
I_BusPartRelshpSourceProcess view from TRANSACTIONAL Core BP Relationship Source In Process Status
I_MDChangeProcessSourceEnhcd view from COMPOSITE Master Data Change Process Source
I_MDImportSourceSystemVH view_entity union COMPOSITE Master data import source systems
P_MDChgProcNewSourcePackage view from COMPOSITE Master Data Consolidation: Source Package in state New

Fields (2)

KeyField CDS FieldsUsed in Views
KEY MDChgProcessSrceFilter MDChgProcessSrceFilter 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
@AbapCatalog.sqlViewName: 'IMDCHGPROCSRCE'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Data Change Process Source'
@VDM.viewType: #BASIC
@Analytics.dataCategory:#FACT

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

@ObjectModel.alternativeKey: [{
        id : 'MDCHGPROCESSSOURCE',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,  
        element : ['MASTERDATACHANGEPROCESS', 'MDCHGPROCESSSRCESYSTEM', 'MDCHGPROCESSSRCESTATUS', 'MDCHGPROCESSSRCEFILTER' ]
    }]

define view I_MDChangeProcessSource
  as select from mdc_d_prcsrc

  //association

  association [0..*] to I_MDChgProcessSourceWorklist as _MDChgProcessSourceWorklist on _MDChgProcessSourceWorklist.MDChgProcessSourceUUID = $projection.MDChgProcessSourceUUID
  association [1..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on _MasterDataChangeProcess.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
{
      // keys

  key db_key         as MDChgProcessSourceUUID,
      // data

      parent_key     as MasterDataChangeProcessUUID,
      process_id     as MasterDataChangeProcess,
      source_system  as MDChgProcessSrceSystem,
      status         as MDChgProcessSrceStatus,
      filter         as MDChgProcessSrceFilter,
      source_records as MDChgProcessNmbrOfSrceRecords,
      source_otc     as MDChgProcessSrceObjectTypeCode,
      filter_chain   as MDChgProcessSrceFilterChain,
      
      // associations

      _MasterDataChangeProcess,
      _MDChgProcessSourceWorklist
      
}