I_MasterDataChangeProcessVH

DDL: I_MASTERDATACHANGEPROCESSVH SQL: IMDCHGPROCESSVH Type: view BASIC
14 Fields 1 Data Sources 1 Associations

Master Data Change Process Value Help

I_MasterDataChangeProcessVH is a Basic CDS View that provides data about "Master Data Change Process Value Help" in SAP S/4HANA. It reads from 1 data source (I_MasterDataChangeProcess) and exposes 14 fields with key field MasterDataChangeProcessUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcess I_MasterDataChangeProcess from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MasterDataChangeProcessUser _User $projection.MDChgProcessRequestor = _User.MDChgProcessRequestor and $projection.MDChgProcessSrceObjectTypeCode = _User.MDChgProcessSrceObjectTypeCode and $projection.MDChgProcessGoal = _User.MDChgProcessGoal

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCESSVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Data Change Process Value Help view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
Consumption.ranked true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID NodeID
MasterDataChangeProcess MasterDataChangeProcess Process ID
MDChgProcessDescription MDChgProcessDescription Process Description
MDChgProcessTypeID MDChgProcessTypeID Process Template
MDChgProcessGoal MDChgProcessGoal Process Goal
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessRequestor MDChgProcessRequestor Process Requestor
FullName _User CreatedByUserName Person Resp.
MDChgProcessCreationDate MDChgProcessCreationDate Time Stamp
MDChgProcessIsStarted MDChgProcessIsStarted Process Started
MDChgProcessIsFinalized MDChgProcessIsFinalized Finalized
MDChgProcessFilterChain MDChgProcessFilterChain Filter Chain
MDChgProcessIsErased MDChgProcessIsErased Process Erased
_User _User

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_MasterDataChangeProcessVH.
-- 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.
-- SQL view name: IMDCHGPROCESSVH

CREATE VIEW I_MasterDataChangeProcessVH AS
SELECT
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessDescription,
  MDChgProcessTypeID,
  MDChgProcessGoal,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessRequestor,
  _User.CreatedByUserName AS FullName,
  MDChgProcessCreationDate,
  MDChgProcessIsStarted,
  MDChgProcessIsFinalized,
  MDChgProcessFilterChain,
  MDChgProcessIsErased
FROM I_MasterDataChangeProcess
LEFT OUTER JOIN I_MasterDataChangeProcessUser AS _User ON MDChgProcessRequestor = _User.MDChgProcessRequestor AND MDChgProcessSrceObjectTypeCode = _User.MDChgProcessSrceObjectTypeCode AND MDChgProcessGoal = _User.MDChgProcessGoal  -- association [0..1]
;

Learn More