I_MDChgProcessSourceWorklistTP

DDL: I_MDCHGPROCESSSOURCEWORKLISTTP Type: view TRANSACTIONAL Package: MDC_PROCESS_OBJECT

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)

SourceAliasJoin Type
mdc_d_prcwlist mdc_d_prcwlist from

Associations (3)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

ServiceBindingVersionContractRelease
MASTERDATACHANGEPROCESSSD C_MASTERDATACHANGEPROCESS_V4 V4 C1 C1
MASTERDATACHANGEPROCESSSD MASTERDATACHANGEPROCESSSB V2 C1 NOT_RELEASED
MASTERDATACHANGEPROCESSSD MDCHANGEPROCESSSB_2 V2 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
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
}