I_BPHierNodeChangeProcessGov

DDL: I_BPHIERNODECHANGEPROCESSGOV Type: view_entity
16 Fields 2 Data Sources

Change Process (Gov) of BP Hierarchy

I_BPHierNodeChangeProcessGov is a CDS View that provides data about "Change Process (Gov) of BP Hierarchy" in SAP S/4HANA. It reads from 2 data sources (bph_node_prc, I_MasterDataChangeProcess) and exposes 16 fields with key fields MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject.

Data Sources (2)

SourceAliasJoin Type
bph_node_prc BPHierNodeProcess inner
I_MasterDataChangeProcess Process from

Annotations (2)

NameValueLevelField
EndUserText.label Change Process (Gov) of BP Hierarchy view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess bph_node_prc process_id Process Instance ID
KEY MDChgProcessSrceSystem bph_node_prc source_system Source System
KEY MDChgProcessSrceObject bph_node_prc source_id UUID
MDChgProcessStep bph_node_prc process_step_no Step Number
MasterDataChangeProcessUUID I_MasterDataChangeProcess MasterDataChangeProcessUUID NodeID
MDChgProcessDescription I_MasterDataChangeProcess MDChgProcessDescription Process Description
MDChgProcessTypeID I_MasterDataChangeProcess MDChgProcessTypeID Process Template
MDChgProcessGoal I_MasterDataChangeProcess MDChgProcessGoal Process Goal
MDChgProcessStatus I_MasterDataChangeProcess MDChgProcessStatus Process Status
MDChgProcessSrceObjectTypeCode I_MasterDataChangeProcess MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessRequestor I_MasterDataChangeProcess MDChgProcessRequestor Process Requestor
MDChgProcessIsStarted I_MasterDataChangeProcess MDChgProcessIsStarted Process Started
MDChgProcessIsFinalized I_MasterDataChangeProcess MDChgProcessIsFinalized Finalized
MDChgProcessLastStepIsFinished I_MasterDataChangeProcess MDChgProcessLastStepIsFinished Last Step Finished
MDChgProcessCurrentStepNumber I_MasterDataChangeProcess MDChgProcessCurrentStepNumber Step Number
MDChgProcessIsErased I_MasterDataChangeProcess MDChgProcessIsErased Process Erased

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_BPHierNodeChangeProcessGov.
-- 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_BPHierNodeChangeProcessGov AS
SELECT
  BPHierNodeProcess.process_id AS MasterDataChangeProcess,
  BPHierNodeProcess.source_system AS MDChgProcessSrceSystem,
  BPHierNodeProcess.source_id AS MDChgProcessSrceObject,
  BPHierNodeProcess.process_step_no AS MDChgProcessStep,
  Process.MasterDataChangeProcessUUID AS MasterDataChangeProcessUUID,
  Process.MDChgProcessDescription AS MDChgProcessDescription,
  Process.MDChgProcessTypeID AS MDChgProcessTypeID,
  Process.MDChgProcessGoal AS MDChgProcessGoal,
  Process.MDChgProcessStatus AS MDChgProcessStatus,
  Process.MDChgProcessSrceObjectTypeCode AS MDChgProcessSrceObjectTypeCode,
  Process.MDChgProcessRequestor AS MDChgProcessRequestor,
  Process.MDChgProcessIsStarted AS MDChgProcessIsStarted,
  Process.MDChgProcessIsFinalized AS MDChgProcessIsFinalized,
  Process.MDChgProcessLastStepIsFinished AS MDChgProcessLastStepIsFinished,
  Process.MDChgProcessCurrentStepNumber AS MDChgProcessCurrentStepNumber,
  Process.MDChgProcessIsErased AS MDChgProcessIsErased
FROM I_MasterDataChangeProcess AS Process
INNER JOIN bph_node_prc AS BPHierNodeProcess ON /* join condition not captured in parsed metadata */
;

Learn More