P_O_PERSWRKAGRMTTOPARTNER

CDS View

P_O_PERSWRKAGRMTTOPARTNER is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkAssignment view_entity inner BASIC Work Assignments
N_PersonWorkAgreement_1 view inner Auxillary view 
@AbapCatalog.sqlViewName: 'POPERSWRKAGRMTPT'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Internal for HCM,N_PERSONWORKAGREEMENT_1'

@VDM.viewType: #BASIC
define view P_O_PersWrkAgrmtToPartner
  as select from hrp1001 as RelationP_CP
    inner join   hrp1001 as RelationCP_BP on  RelationCP_BP.objid = RelationP_CP.sobid
                                          and RelationCP_BP.rsign = 'B'
                                          and RelationCP_BP.relat = '207'
                                          and RelationCP_BP.endda = '99991231'
                                          and RelationCP_BP.plvar = RelationP_CP.plvar
    inner join   t77s0   as systemtable   on  grpid = 'PLOGI'
                                          and semid = 'PLOGI'
                                          and gsval = RelationCP_BP.plvar
{
  RelationP_CP.objid  as PersonWorkAgreement, //P

  RelationCP_BP.sobid as Person, //BP

  RelationP_CP.sobid  as HumRsceRelatedObjectId //CP.We donot have a defined GFN for this. Reusing name from I_HrRelation to be consistent

}
where
      RelationP_CP.otype = 'P'
  and RelationP_CP.sclas = 'CP'
  and RelationP_CP.rsign = 'A'
  and RelationP_CP.relat = '209'
  and RelationP_CP.endda = '99991231'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1001",
"T77S0"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More