I_MDCHANGEPROCESSSOURCE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
}