I_MDChgProcessWorklistTP

DDL: I_MDCHGPROCESSWORKLISTTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 2 Associations

Master Data Change Process Worklist - TP

I_MDChgProcessWorklistTP is a Transactional CDS View that provides data about "Master Data Change Process Worklist - TP" in SAP S/4HANA. It reads from 1 data source (I_Mdchgprocessworklist) and exposes 15 fields with key field MasterDataChgProcessWorklist. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Mdchgprocessworklist I_Mdchgprocessworklist from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MDChgProcessSearchTP _Search $projection.MDChgProcessWlSavedSearch = _Search.MasterDataChgProcessSearch
[0..*] I_MDChgProcessWorklistFeedTP _WorklistFeed

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Master Data Change Process Worklist - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChgProcessWorklist MasterDataChgProcessWorklist Worklist GUID
MDChgProcessWlType MDChgProcessWlType Worklist Type
MDChgProcessWlDescription MDChgProcessWlDescription Well Code Des.
MDChgProcessWlObjectTypeCode MDChgProcessWlObjectTypeCode SOT Name
MDChgProcessWlSourceSystem MDChgProcessWlSourceSystem Source System
MDChgProcessWlSourceFilter MDChgProcessWlSourceFilter Source Filtering
MDChgProcessWlSourceStatus MDChgProcessWlSourceStatus Status
MDChgProcessWlOwnSystem MDChgProcessWlOwnSystem Own System
MDChgProcessWlSavedSearch MDChgProcessWlSavedSearch GUID
MDChgProcessWlCreatedByUser MDChgProcessWlCreatedByUser Version Created By
MDChgProcessWlCreatedDateTime MDChgProcessWlCreatedDateTime Uploaded On
MDChgProcessWlChangedByUser MDChgProcessWlChangedByUser User Name
MDChgProcessWlChangedDateTime MDChgProcessWlChangedDateTime Timestamp
_WorklistFeed _WorklistFeed
_Search _Search

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MDChgProcessWorklistTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_MDChgProcessWorklistTP AS
SELECT
  MasterDataChgProcessWorklist,
  MDChgProcessWlType,
  MDChgProcessWlDescription,
  MDChgProcessWlObjectTypeCode,
  MDChgProcessWlSourceSystem,
  MDChgProcessWlSourceFilter,
  MDChgProcessWlSourceStatus,
  MDChgProcessWlOwnSystem,
  MDChgProcessWlSavedSearch,
  MDChgProcessWlCreatedByUser,
  MDChgProcessWlCreatedDateTime,
  MDChgProcessWlChangedByUser,
  MDChgProcessWlChangedDateTime
FROM I_Mdchgprocessworklist
LEFT OUTER JOIN I_MDChgProcessSearchTP AS _Search ON MDChgProcessWlSavedSearch = _Search.MasterDataChgProcessSearch  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcessWorklistFeedTP AS _WorklistFeed ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More