C_BPHierDescriptionProcessTP

DDL: C_BPHIERDESCRIPTIONPROCESSTP Type: view_entity Package: MDC_BP_HIER_GOV_BO
23 Fields 1 Data Sources 2 Associations 3 OData Services

Projection of BPH Description (Process)

C_BPHierDescriptionProcessTP is a CDS View that provides data about "Projection of BPH Description (Process)" in SAP S/4HANA. It reads from 1 data source (I_BPHierDescriptionProcessTP) and exposes 23 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_BPHierDescriptionProcessTP I_BPHierDescriptionProcessTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_BPHierDescProcessChanges _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 = '5669'

Annotations (3)

NameValueLevelField
EndUserText.label Projection of BPH 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 (23)

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
BPHierarchyDescription BPHierarchyDescription
BPHierDescriptionCreatedBy BPHierDescriptionCreatedBy
BPHierDescCreatedDateTime BPHierDescCreatedDateTime
BPHierDescriptionLastChangedBy BPHierDescriptionLastChangedBy
BPHierDescLastChgdDateTime BPHierDescLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcKPIUpdateStatus MDChgProcKPIUpdateStatus Row Type
MDChgProcessRecordObjectText _Hierarchy MDChgProcessRecordObjectText
BPHierarchyDisplayID _Hierarchy BPHierarchyDisplayID
sstring260
MDChgProcessValidationStatus _Hierarchy MDChgProcessValidationStatus
MDChgProcKPIRecordStatusText
MDChgProcKPIUpdateStatusText _KPIUpdateStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIRecordTypeText
MDChgProcKPIRecordType _RecordType MDChgProcKPIRecordType
_Changes _Changes
_RecordTarget _RecordTarget

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_BPHierDescriptionProcessTP.
-- 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_BPHierDescriptionProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  Language,
  BPHierarchyDescription,
  BPHierDescriptionCreatedBy,
  BPHierDescCreatedDateTime,
  BPHierDescriptionLastChangedBy,
  BPHierDescLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcKPIUpdateStatus,
  _Hierarchy.MDChgProcessRecordObjectText AS MDChgProcessRecordObjectText,
  _Hierarchy.BPHierarchyDisplayID AS BPHierarchyDisplayID,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  _Hierarchy.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _Hierarchy._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType
FROM I_BPHierDescriptionProcessTP
LEFT OUTER JOIN C_BPHierDescProcessChanges 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 = '5669'  -- association [0..1]
;

Learn More