C_BPHierarchyProcessTP

DDL: C_BPHIERARCHYPROCESSTP Type: view_entity
28 Fields 1 Data Sources 2 Associations

Projection of BP Hierarchy (Process)

C_BPHierarchyProcessTP is a CDS View that provides data about "Projection of BP Hierarchy (Process)" in SAP S/4HANA. It reads from 1 data source (I_BPHierarchyProcessTP) and exposes 28 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPHierarchyProcessTP I_BPHierarchyProcessTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_BPHierarchyProcessChanges _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_BPHierProcessChangesUnion _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 BP Hierarchy (Process) view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view

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
BusinessPartnerHierarchyUUID BusinessPartnerHierarchyUUID
BPHierarchyDisplayID BPHierarchyDisplayID
BPHierarchyDataType BPHierarchyDataType
BPHierarchyCreatedBy BPHierarchyCreatedBy
BPHierarchyCreatedDateTime BPHierarchyCreatedDateTime
BPHierarchyLastChangedBy BPHierarchyLastChangedBy
BPHierarchyLastChangedDateTime BPHierarchyLastChangedDateTime
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
IsChanged IsChanged Fixed Asset Posting: Change Indicator for Posting
MDChgProcessRecordObjectText MDChgProcessRecordObjectText
sstring260
int8
MDChgProcessValidationStatus MDChgProcessValidationStatus
MDChgProcKPIUpdateStatus MDChgProcKPIUpdateStatus Row Type
_RecordMessages _RecordMessages
MDChgProcKPIRecordStatusText _KPIRecordStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIUpdateStatusText _KPIUpdateStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIRecordTypeText
MDChgProcKPIRecordType _RecordType MDChgProcKPIRecordType
_Changes _Changes
_ChangesUnion _ChangesUnion
_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_BPHierarchyProcessTP.
-- 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_BPHierarchyProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BusinessPartnerHierarchyUUID,
  BPHierarchyDisplayID,
  BPHierarchyDataType,
  BPHierarchyCreatedBy,
  BPHierarchyCreatedDateTime,
  BPHierarchyLastChangedBy,
  BPHierarchyLastChangedDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  IsChanged,
  MDChgProcessRecordObjectText,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  virtual MDChgProcessNumberOfMessages : abap.int8 AS int8,
  MDChgProcessValidationStatus,
  MDChgProcKPIUpdateStatus,
  _KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType
FROM I_BPHierarchyProcessTP
LEFT OUTER JOIN C_BPHierarchyProcessChanges 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_BPHierProcessChangesUnion 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