I_MDChgProcessSourceWorklistTP
MD Change Process Source Worklist
I_MDChgProcessSourceWorklistTP is a Transactional CDS View that provides data about "MD Change Process Source Worklist" in SAP S/4HANA. It reads from 1 data source (mdc_d_prcwlist) and exposes 11 fields with key field MDChgProcessSrceWlUUID. It has 3 associations to related views. It is exposed through 3 OData services (MASTERDATACHANGEPROCESSSD, MASTERDATACHANGEPROCESSSD, MASTERDATACHANGEPROCESSSD). Part of development package MDC_PROCESS_OBJECT.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| mdc_d_prcwlist | mdc_d_prcwlist | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_MDChangeProcessSourceTP | _Parent | _Parent.MDChgProcessSourceUUID = $projection.MDChgProcessSourceUUID |
| [1..1] | I_MasterDataChangeProcessTP | _Root | _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID |
| [0..*] | I_MDChgProcessWorklistQueryTP | _Query | _Query.MDChgProcessSrceWlUUID = $projection.MDChgProcessSrceWlUUID and _Query.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | MD Change Process Source Worklist | view | |
| AbapCatalog.sqlViewName | IMDCHGPROCWLTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ObjectModel.writeActivePersistence | TMDCHGPROCSRWL_W | 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 |
OData Services (3)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| MASTERDATACHANGEPROCESSSD | C_MASTERDATACHANGEPROCESS_V4 | V4 | C1 | C1 |
| MASTERDATACHANGEPROCESSSD | MASTERDATACHANGEPROCESSSB | V2 | C1 | NOT_RELEASED |
| MASTERDATACHANGEPROCESSSD | MDCHANGEPROCESSSB_2 | V2 | C1 | NOT_RELEASED |
Fields (11)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MDChgProcessSrceWlUUID | db_key | ||
| MasterDataChangeProcessUUID | root_key | |||
| MDChgProcessSourceUUID | parent_key | |||
| MasterDataChangeProcess | process_id | |||
| MDChgProcessSourceWorklist | worklist_guid | |||
| MDChgProcessWlPurpose | purpose | |||
| MDChgProcessWlObjectTypeCode | source_otc | |||
| MDChgProcessWlFilterChain | filter_chain | |||
| _Parent | _Parent | |||
| _Root | _Root | |||
| _Query | _Query |
@EndUserText.label: 'MD Change Process Source Worklist'
@AbapCatalog: {
sqlViewName: 'IMDCHGPROCWLTP',
compiler.compareFilter: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
writeActivePersistence: 'TMDCHGPROCSRWL_W',
createEnabled,
updateEnabled,
deleteEnabled,
usageType.dataClass: #TRANSACTIONAL,
usageType.serviceQuality: #B,
usageType.sizeCategory: #M,
alternativeKey: [{
id : 'MDCHGPROCESSSOURCEWORKLIST',
uniqueness : #UNIQUE_IF_NOT_INITIAL,
element : ['MASTERDATACHANGEPROCESS', 'MDCHGPROCESSSOURCEWORKLIST']
}]
}
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type:#SAP_INTERNAL_API
}
define view I_MDChgProcessSourceWorklistTP
as select from mdc_d_prcwlist
association [1..1] to I_MDChangeProcessSourceTP as _Parent on _Parent.MDChgProcessSourceUUID = $projection.MDChgProcessSourceUUID
association [1..1] to I_MasterDataChangeProcessTP as _Root on _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
association [0..*] to I_MDChgProcessWorklistQueryTP as _Query on _Query.MDChgProcessSrceWlUUID = $projection.MDChgProcessSrceWlUUID
and _Query.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
{
key db_key as MDChgProcessSrceWlUUID,
root_key as MasterDataChangeProcessUUID,
parent_key as MDChgProcessSourceUUID,
process_id as MasterDataChangeProcess,
worklist_guid as MDChgProcessSourceWorklist,
purpose as MDChgProcessWlPurpose,
source_otc as MDChgProcessWlObjectTypeCode,
filter_chain as MDChgProcessWlFilterChain,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
_Parent,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
_Root,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_Query
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA