I_BPSystemReplicationStatus

DDL: I_BPSYSTEMREPLICATIONSTATUS Type: view_entity COMPOSITE

Status of BP Replication to a single system

I_BPSystemReplicationStatus is a Composite CDS View that provides data about "Status of BP Replication to a single system" in SAP S/4HANA. It reads from 2 data sources (I_BPLatestReplication, mdg_bus_sys_tech) and exposes 4 fields with key fields BusinessPartner, BusinessSystemName.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_BPLatestReplication _BPLatestReplication inner
mdg_bus_sys_tech bus_sys inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Status of BP Replication to a single system view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY BusinessSystemName mdg_bus_sys_tech business_system
BPReplicationDateTime drfd_obj_rep_sta last_replication
BPReplicationStatus drfd_obj_rep_sta repstatus 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Status of BP Replication to a single system'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #MASTER
}
@VDM.viewType: #COMPOSITE
define view entity I_BPSystemReplicationStatus 
as select distinct from drfd_obj_rep_sta
    inner join   mdg_bus_sys_tech as bus_sys on bus_sys.bus_sys_id = drfd_obj_rep_sta.bus_sys_id
    inner join I_BPLatestReplication as _BPLatestReplication on _BPLatestReplication.DRFObjectID        = drfd_obj_rep_sta.object_id
                                                      and _BPLatestReplication.DRFBusinessObjectType  = drfd_obj_rep_sta.business_object
                                                      and _BPLatestReplication.DRFBusinessSystemID       = drfd_obj_rep_sta.bus_sys_id
                                                      and _BPLatestReplication.DRFLatestReplicationDateTime = drfd_obj_rep_sta.last_replication
{
  key cast( substring(drfd_obj_rep_sta.object_id, 55, 10) as bu_partner preserving type) as BusinessPartner,
  key bus_sys.business_system                                                            as BusinessSystemName,
  drfd_obj_rep_sta.last_replication as BPReplicationDateTime,
  drfd_obj_rep_sta.repstatus as BPReplicationStatus
}
where
  drfd_obj_rep_sta.business_object = '986'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPLATESTREPLICATION",
"DRFD_OBJ_REP_STA",
"MDG_BUS_SYS_TECH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More