I_BPRelshpChangeProcessGov

DDL: I_BPRELSHPCHANGEPROCESSGOV Type: view_entity TRANSACTIONAL
17 Fields 2 Data Sources

Business Partner Relationship Change Process Governance

I_BPRelshpChangeProcessGov is a Transactional CDS View that provides data about "Business Partner Relationship Change Process Governance" in SAP S/4HANA. It reads from 2 data sources (I_BusPartRelationshipGov, I_MasterDataChangeProcess) and exposes 17 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BPRelshpCatIsInFwdDirection.

Data Sources (2)

SourceAliasJoin Type
I_BusPartRelationshipGov BPRelationship inner
I_MasterDataChangeProcess Process from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Partner Relationship Change Process Governance view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_BusPartRelationshipGov MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_BusPartRelationshipGov MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_BusPartRelationshipGov MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_BusPartRelationshipGov MDChgProcessSrceObject Source ID
KEY BPRelshpCatIsInFwdDirection I_BusPartRelationshipGov BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
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_BPRelshpChangeProcessGov.
-- 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_BPRelshpChangeProcessGov AS
SELECT
  BPRelationship.MasterDataChangeProcess AS MasterDataChangeProcess,
  BPRelationship.MDChgProcessStep AS MDChgProcessStep,
  BPRelationship.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  BPRelationship.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  BPRelationship.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  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 I_BusPartRelationshipGov AS BPRelationship ON /* join condition not captured in parsed metadata */
;

Learn More