C_BPHierarchyNodeProcessTP

DDL: C_BPHIERARCHYNODEPROCESSTP Type: view_entity Package: MDC_BP_HIER_GOV_BO
37 Fields 1 Data Sources 2 Associations 3 OData Services

Projection of BPH Node (Process)

C_BPHierarchyNodeProcessTP is a CDS View that provides data about "Projection of BPH Node (Process)" in SAP S/4HANA. It reads from 1 data source (I_BPHierarchyNodeProcessTP) and exposes 37 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 2 associations to related views. It is exposed through 3 OData services (C_MDCHGPRCBPHDETAILSTP_SRV, C_MDCHGPRCBPHDETAILSTP_SRV, C_MDCHGPRCBPHDETAILSTP_SRV). Part of development package MDC_BP_HIER_GOV_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPHierarchyNodeProcessTP I_BPHierarchyNodeProcessTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_BPHierNodeProcessChanges _Changes $projection.MasterDataChangeProcess = _Changes.MasterDataChangeProcess and $projection.MDChgProcessStep = _Changes.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject and _Changes.MDChgProcessSourceModified = 'X'
[0..*] C_BPHierNodeProcChangesUnion _ChangesUnion $projection.MasterDataChangeProcess = _ChangesUnion.MasterDataChangeProcess and $projection.MDChgProcessStep = _ChangesUnion.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _ChangesUnion.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _ChangesUnion.MDChgProcessSrceObject and $projection.IsChanged = _ChangesUnion.MDChgProcessSourceModified

Annotations (3)

NameValueLevelField
EndUserText.label Projection of BPH Node (Process) view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view

OData Services (3)

ServiceBindingVersionContractRelease
C_MDCHGPRCBPHDETAILSTP_SRV C_MDCHGPRCBPHDETAILSTP_SRV V2 C1 NOT_RELEASED
C_MDCHGPRCBPHDETAILSTP_SRV C_MDCHGPRCBPHDETAILSTP_V2 V2 C1 NOT_RELEASED
C_MDCHGPRCBPHDETAILSTP_SRV C_MDCHGPRCBPHDETAILSTP_V4 V4 C1 NOT_RELEASED

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
BPHierarchyNodeUUID BPHierarchyNodeUUID
MDChgProcSrceObjBPHierarchy MDChgProcSrceObjBPHierarchy
BusinessPartnerHierarchyUUID BusinessPartnerHierarchyUUID
MDChgProcessSrceBusPart MDChgProcessSrceBusPart
BusinessPartnerUUID BusinessPartnerUUID UUID
BPHierarchyNodeDisplayID BPHierarchyNodeDisplayID
MDChgProcessRecordObjectText MDChgProcessRecordObjectText
sstring260
int8
IsChanged IsChanged Fixed Asset Posting: Change Indicator for Posting
MDChgProcHierRecordObjText MDChgProcHierRecordObjText
BusinessPartnerName BusinessPartnerName Extracted Customer Name
BPHierarchyNodeCreatedBy BPHierarchyNodeCreatedBy
BPHierarchyNodeCreatedDateTime BPHierarchyNodeCreatedDateTime
BPHierarchyNodeLastChangedBy BPHierarchyNodeLastChangedBy
BPHierNodeLastChangedDateTime BPHierNodeLastChangedDateTime
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChangeProcessSourceSystemOwn MDChangeProcessSourceSystemOwn
MDChgProcessValidationStatus MDChgProcessValidationStatus
MDChgProcKPIUpdateStatus MDChgProcKPIUpdateStatus Row Type
_RecordMessages _RecordMessages
_RecordTarget _RecordTarget
MDChgProcSrceSystemHierarchy _Hierarchy MDChgProcessSrceSystem Source System
MDChgProcKPIRecordStatusText _KPIRecordStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIUpdateStatusText _KPIUpdateStatusText MDChangeProcKPIValueKeyDesc
MDChgProcessHierarchyLastStep MDChgProcessHierarchyLastStep
MDChgProcKPIRecordTypeText
MDChgProcKPIRecordType _RecordType MDChgProcKPIRecordType
_Hierarchy _Hierarchy
_Changes _Changes
_ChangesUnion _ChangesUnion
_RecordType _RecordType

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 C_BPHierarchyNodeProcessTP.
-- 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 C_BPHierarchyNodeProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPHierarchyNodeUUID,
  MDChgProcSrceObjBPHierarchy,
  BusinessPartnerHierarchyUUID,
  MDChgProcessSrceBusPart,
  BusinessPartnerUUID,
  BPHierarchyNodeDisplayID,
  MDChgProcessRecordObjectText,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  virtual MDChgProcessNumberOfMessages : abap.int8 AS int8,
  IsChanged,
  MDChgProcHierRecordObjText,
  BusinessPartnerName,
  BPHierarchyNodeCreatedBy,
  BPHierarchyNodeCreatedDateTime,
  BPHierarchyNodeLastChangedBy,
  BPHierNodeLastChangedDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChangeProcessSourceSystemOwn,
  MDChgProcessValidationStatus,
  MDChgProcKPIUpdateStatus,
  _Hierarchy.MDChgProcessSrceSystem AS MDChgProcSrceSystemHierarchy,
  _KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcessHierarchyLastStep,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType
FROM I_BPHierarchyNodeProcessTP
LEFT OUTER JOIN C_BPHierNodeProcessChanges AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN C_BPHierNodeProcChangesUnion AS _ChangesUnion ON MasterDataChangeProcess = _ChangesUnion.MasterDataChangeProcess AND MDChgProcessStep = _ChangesUnion.MDChgProcessStep AND MDChgProcessSrceSystem = _ChangesUnion.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ChangesUnion.MDChgProcessSrceObject AND IsChanged = _ChangesUnion.MDChgProcessSourceModified  -- association [0..*]
;

Learn More