C_BPHierNodeDescriptionProcTP

DDL: C_BPHIERNODEDESCRIPTIONPROCTP Type: view_entity Package: MDC_BP_HIER_GOV_BO
28 Fields 1 Data Sources 2 Associations 3 OData Services

Projection of Node Description (Process)

C_BPHierNodeDescriptionProcTP is a CDS View that provides data about "Projection of Node Description (Process)" in SAP S/4HANA. It reads from 1 data source (I_BPHierNodeDescriptionProcTP) and exposes 28 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, Language. 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_BPHierNodeDescriptionProcTP I_BPHierNodeDescriptionProcTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_BPHierNodeDescProcessChanges _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..1] I_MDChangeProcessRecordTarget _RecordTarget $projection.MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject and _RecordTarget.MDChgProcessSrceObjectTypeCode = '5855'

Annotations (3)

NameValueLevelField
EndUserText.label Projection of Node Description (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 (28)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY Language Language Report Text Language
BPHierarchyNodeDescription BPHierarchyNodeDescription
BPHierNodeDescriptionCreatedBy BPHierNodeDescriptionCreatedBy
BPHierNodeDescCreatedDateTime BPHierNodeDescCreatedDateTime
BPHierNodeDescLastChangedBy BPHierNodeDescLastChangedBy
BPHierNodeDescLastChgdDateTime BPHierNodeDescLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcessRecordObjectText _HierarchyNode MDChgProcessRecordObjectText
sstring260
MDChgProcHierRecordObjText _HierarchyNode MDChgProcHierRecordObjText
MDChgProcKPIUpdateStatus MDChgProcKPIUpdateStatus Row Type
BusinessPartnerHierarchyUUID _HierarchyNode BusinessPartnerHierarchyUUID
BPHierarchyNodeDisplayID _HierarchyNode BPHierarchyNodeDisplayID
MDChgProcSrceSystemHierarchy
MDChgProcSrceObjBPHierarchy _HierarchyNode MDChgProcSrceObjBPHierarchy
MDChgProcessValidationStatus _HierarchyNode MDChgProcessValidationStatus
MDChgProcKPIRecordStatusText
MDChgProcKPIUpdateStatusText _KPIUpdateStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIRecordTypeText
MDChgProcKPIRecordType _RecordType MDChgProcKPIRecordType
_Changes _Changes
_RecordTarget _RecordTarget
_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_BPHierNodeDescriptionProcTP.
-- 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_BPHierNodeDescriptionProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  Language,
  BPHierarchyNodeDescription,
  BPHierNodeDescriptionCreatedBy,
  BPHierNodeDescCreatedDateTime,
  BPHierNodeDescLastChangedBy,
  BPHierNodeDescLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  _HierarchyNode.MDChgProcessRecordObjectText AS MDChgProcessRecordObjectText,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  _HierarchyNode.MDChgProcHierRecordObjText AS MDChgProcHierRecordObjText,
  MDChgProcKPIUpdateStatus,
  _HierarchyNode.BusinessPartnerHierarchyUUID AS BusinessPartnerHierarchyUUID,
  _HierarchyNode.BPHierarchyNodeDisplayID AS BPHierarchyNodeDisplayID,
  _HierarchyNode._Hierarchy.MDChgProcessSrceSystem AS MDChgProcSrceSystemHierarchy,
  _HierarchyNode.MDChgProcSrceObjBPHierarchy AS MDChgProcSrceObjBPHierarchy,
  _HierarchyNode.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _HierarchyNode._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType
FROM I_BPHierNodeDescriptionProcTP
LEFT OUTER JOIN C_BPHierNodeDescProcessChanges 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 I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '5855'  -- association [0..1]
;

Learn More