P_RespyMgmtOrgUnitBPRelshp

DDL: P_RESPYMGMTORGUNITBPRELSHP SQL: PRSMORGUNITBPREL Type: view BASIC Package: CA_RSM_TEAMS_DDIC

basic View to get Org Unit and BP Relationship

P_RespyMgmtOrgUnitBPRelshp is a Basic CDS View that provides data about "basic View to get Org Unit and BP Relationship" in SAP S/4HANA. It reads from 6 data sources and exposes 2 fields with key fields OrgUnit, BusinessPartner. Part of development package CA_RSM_TEAMS_DDIC.

6 data source(s) 2 fields

Data Sources (6)

SourceAliasJoin Type
I_BusinessUserBasic BusinessUser inner
hrp1001 CentralPersonBPRelation inner
hrp1000 OrgUnit from
hrp1001 OrgUnitPositionRelation inner
hrp1001 PersonCentralPersonRelation inner
hrp1001 PositionPersonRelation inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRSMORGUNITBPREL view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY OrgUnit hrp1000 objid
KEY BusinessPartner I_BusinessUserBasic BusinessPartner 
@AbapCatalog.sqlViewName: 'PRSMORGUNITBPREL'
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey: true
define view P_RespyMgmtOrgUnitBPRelshp as select from hrp1000 as OrgUnit
    inner join   hrp1001 as OrgUnitPositionRelation     on  OrgUnitPositionRelation.plvar    = '01'
                                                        and OrgUnitPositionRelation.otype    = 'O'
                                                        and OrgUnitPositionRelation.relat    = '003'
                                                        and OrgUnitPositionRelation.sclas    = 'S'
                                                        and OrgUnitPositionRelation.istat    = '1'
                                                        and OrgUnitPositionRelation.objid    = OrgUnit.objid
                                                        and (
                                                           OrgUnitPositionRelation.begda     <= $session.system_date
                                                           and OrgUnitPositionRelation.endda > $session.system_date
                                                         )
    inner join   hrp1001 as PositionPersonRelation      on  PositionPersonRelation.plvar    = '01'
                                                        and PositionPersonRelation.otype    = 'S'
                                                        and PositionPersonRelation.sclas    = 'P'
                                                        and PositionPersonRelation.objid    = OrgUnitPositionRelation.sobid
                                                        and PositionPersonRelation.istat    = '1'
                                                        and (
                                                           PositionPersonRelation.begda     <= $session.system_date
                                                           and PositionPersonRelation.endda > $session.system_date
                                                         )
    inner join   hrp1001 as PersonCentralPersonRelation on  PersonCentralPersonRelation.plvar    = '01'
                                                        and PersonCentralPersonRelation.otype    = 'P'
                                                        and PersonCentralPersonRelation.sclas    = 'CP'
                                                        and PersonCentralPersonRelation.objid    = PositionPersonRelation.sobid
                                                        and PersonCentralPersonRelation.istat    = '1'
                                                        and (
                                                           PersonCentralPersonRelation.begda     <= $session.system_date
                                                           and PersonCentralPersonRelation.endda > $session.system_date
                                                         )
    inner join   hrp1001 as CentralPersonBPRelation     on  CentralPersonBPRelation.plvar    = '01'
                                                        and CentralPersonBPRelation.otype    = 'CP'
                                                        and CentralPersonBPRelation.sclas    = 'BP'
                                                        and CentralPersonBPRelation.objid    = PersonCentralPersonRelation.sobid
                                                        and CentralPersonBPRelation.istat    = '1'
                                                        and (
                                                           CentralPersonBPRelation.begda     <= $session.system_date
                                                           and CentralPersonBPRelation.endda > $session.system_date
                                                         )
    inner join I_BusinessUserBasic as BusinessUser on BusinessUser.BusinessPartner = CentralPersonBPRelation.sobid
                                                 
{
  key OrgUnit.objid as OrgUnit,
//  key CentralPersonBPRelation.sobid

  key BusinessUser.BusinessPartner
}
where
        OrgUnit.plvar = '01'
  and   OrgUnit.otype = 'O'
  and   OrgUnit.istat = '1'
  and(
        OrgUnit.begda <= $session.system_date
    and OrgUnit.endda > $session.system_date
  ) ;

Learn More