I_BPHierarchyNodeProcess

DDL: I_BPHIERARCHYNODEPROCESS Type: view_entity Package: MDC_BP_HIER_GOV_BO

BP Hierarchy Node (Process)

I_BPHierarchyNodeProcess is a CDS View that provides data about "BP Hierarchy Node (Process)" in SAP S/4HANA. It reads from 1 data source (bph_node_prc) and exposes 20 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 1 association to related views. Part of development package MDC_BP_HIER_GOV_BO.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
bph_node_prc bph_node_prc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MDChgProcOwnBusinessSystem _OwnSystem _OwnSystem.MDChgProcessSrceSystem like '%'

Annotations (2)

NameValueLevelField
EndUserText.label BP Hierarchy Node (Process) view
AccessControl.authorizationCheck #CHECK view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess process_id
KEY MDChgProcessStep process_step_no
KEY MDChgProcessSrceSystem source_system
KEY MDChgProcessSrceObject source_id
BPHierarchyNodeUUID hierarchy_node_uuid
MDChgProcSrceObjBPHierarchy source_hierarchy
BusinessPartnerHierarchyUUID hierarchy_uuid
MDChgProcessSrceBusPart source_partner
BusinessPartnerUUID business_partner_uuid
BPHierarchyNodeDisplayID hierarchy_node_display_id
BPHierarchyNodeCreatedBy created_by
BPHierarchyNodeCreatedDateTime created_at
BPHierarchyNodeLastChangedBy last_changed_by
BPHierNodeLastChangedDateTime last_changed_at
MDChgProcessSourceModified source_modified
MDChgProcessSourceModifBinary source_modification_blip
MDChgProcessValidationStatus validation_status
MDChangeProcessSourceSystemOwn _OwnSystem MDChgProcessSrceSystem
MDChgProcessHierarchyLastStep _BPHierGovernanceLastStep MDChgProcessHierarchyLastStep
_Hierarchy _Hierarchy 
@EndUserText.label: 'BP Hierarchy Node (Process)'
@AccessControl.authorizationCheck: #CHECK

define view entity I_BPHierarchyNodeProcess
  as select from bph_node_prc
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association        to I_BPHierarchyProcessTP       as _Hierarchy                on  $projection.MasterDataChangeProcess          = _Hierarchy.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessHierarchyLastStep    = _Hierarchy.MDChgProcessStep
                                                                                  and (
                                                                                     $projection.MDChgProcessSrceSystem            = _Hierarchy.MDChgProcessSrceSystem
                                                                                     or $projection.MDChangeProcessSourceSystemOwn = _Hierarchy.MDChgProcessSrceSystem // Needed for Record Identifier in Mass Edit

                                                                                   )
                                                                                  and $projection.BusinessPartnerHierarchyUUID     = _Hierarchy.BusinessPartnerHierarchyUUID

  association [0..1] to I_MDChgProcOwnBusinessSystem as _OwnSystem                on  _OwnSystem.MDChgProcessSrceSystem like '%'
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association        to I_BPHierarchyProcessLastStep            as _BPHierGovernanceLastStep  on  $projection.MasterDataChangeProcess        = _BPHierGovernanceLastStep.MasterDataChangeProcess
//                                                                                 and (

//                                                                                     $projection.MDChgProcessSrceSystem            = _Hierarchy.MDChgProcessSrceSystem

//                                                                                     or $projection.MDChangeProcessSourceSystemOwn = _Hierarchy.MDChgProcessSrceSystem // Needed for Record Identifier in Mass Edit

//                                                                                   )

                                                                                  and $projection.BusinessPartnerHierarchyUUID   = _BPHierGovernanceLastStep.BusinessPartnerHierarchyUUID



 
{
  key process_id                        as MasterDataChangeProcess,
  key process_step_no                   as MDChgProcessStep,
  key source_system                     as MDChgProcessSrceSystem,
  key source_id                         as MDChgProcessSrceObject,

      hierarchy_node_uuid               as BPHierarchyNodeUUID,
      source_hierarchy                  as MDChgProcSrceObjBPHierarchy, 
      hierarchy_uuid                    as BusinessPartnerHierarchyUUID,
      source_partner                    as MDChgProcessSrceBusPart,
      business_partner_uuid             as BusinessPartnerUUID,
      hierarchy_node_display_id         as BPHierarchyNodeDisplayID,

      created_by                        as BPHierarchyNodeCreatedBy,
      created_at                        as BPHierarchyNodeCreatedDateTime,
      last_changed_by                   as BPHierarchyNodeLastChangedBy,
      last_changed_at                   as BPHierNodeLastChangedDateTime,

      //      source_recency            as SourceRecency,

      source_modified                   as MDChgProcessSourceModified,
      source_modification_blip          as MDChgProcessSourceModifBinary,
      //      source_index              as SourceIndex,

      //      source_filter             as SourceFilter,

      validation_status                 as MDChgProcessValidationStatus,
      _OwnSystem.MDChgProcessSrceSystem as MDChangeProcessSourceSystemOwn,
      
      _BPHierGovernanceLastStep.MDChgProcessHierarchyLastStep  as MDChgProcessHierarchyLastStep,

      _Hierarchy
}

Learn More