I_MDChgProcessSearchTP

DDL: I_MDCHGPROCESSSEARCHTP Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources 2 Associations

Master Data Change Process Search - TP

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

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcessSearch I_MDChgProcessSearch from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MDChgProcessSearchQueryTP _SearchQuery
[0..*] I_MDChgProcSrchWlAssgmtTP _WorklistAssignment

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Master Data Change Process Search - 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 (11)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChgProcessSearch MasterDataChgProcessSearch GUID
MDChgProcessSrchDescription MDChgProcessSrchDescription Well Code Des.
MDChgProcessSrchObjectTypeCode MDChgProcessSrchObjectTypeCode SOT Name
MDChgProcessSrchCreateUser MDChgProcessSrchCreateUser Version Created By
MDChgProcessSrchCreateDateTime MDChgProcessSrchCreateDateTime Uploaded On
MDChgProcessSrchChangeUser MDChgProcessSrchChangeUser User Name
MDChgProcessSrchChangeDateTime MDChgProcessSrchChangeDateTime Timestamp
MDChgProcessSrchPromoter MDChgProcessSrchPromoter Promoter ID
MDChgProcessSrchPromotion MDChgProcessSrchPromotion Promotion ID
_SearchQuery _SearchQuery
_WorklistAssignment _WorklistAssignment

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_MDChgProcessSearchTP.
-- 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_MDChgProcessSearchTP AS
SELECT
  MasterDataChgProcessSearch,
  MDChgProcessSrchDescription,
  MDChgProcessSrchObjectTypeCode,
  MDChgProcessSrchCreateUser,
  MDChgProcessSrchCreateDateTime,
  MDChgProcessSrchChangeUser,
  MDChgProcessSrchChangeDateTime,
  MDChgProcessSrchPromoter,
  MDChgProcessSrchPromotion
FROM I_MDChgProcessSearch
LEFT OUTER JOIN I_MDChgProcessSearchQueryTP AS _SearchQuery ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcSrchWlAssgmtTP AS _WorklistAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More