I_MDCHGPROCESSSOURCEWORKLISTTP

CDS View

MD Change Process Source Worklist

I_MDCHGPROCESSSOURCEWORKLISTTP is a CDS View in S/4HANA. MD Change Process Source Worklist. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDChgProcessWorklistQueryTP view inner TRANSACTIONAL Process Master Data Change Process Query

Fields (2)

KeyField CDS FieldsUsed in Views
MDChgProcessSourceWorklist MasterDataChgProcessWorklist 1
MDChgProcessWlObjectTypeCode MDChgProcessSrceObjectTypeCode 1 
@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