P_PDOBJECTRELATION

CDS View

P_PDOBJECTRELATION is a CDS View in S/4HANA. 6 CDS views read from this table.

Used by 6 CDS view(s)

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_EmploymentManagerCl view inner BASIC Employment Manager for Cloud
P_EmployeeCl view inner BASIC
P_EmployeePositionOP view left_outer BASIC
P_EmployeeStatus view from BASIC
P_Employment_All_Internal view inner BASIC
P_EmploymentCl view inner BASIC 
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PDOBJECTRELATION'

define view P_PDOBJECTRELATION
  with parameters
    P_ObjectType            : abap.char( 2 ),
    P_RelationShipDirection : abap.char( 1 ),
    P_RelationShip          : abap.char( 3 ),
    P_RelatedObjectType     : abap.char( 2 )

  as select from P_PDRELATION as relation
  //    inner join   t77s0        as systemtable on  grpid = 'PLOGI'

  //                                             and semid = 'PLOGI'

  //                                             and gsval = relation.PlanVersion

  //                 inner join P_PDOBJECT as object  on

  //                 relation.PlanVersion       =  object.PlanVersion  and

  //                 relation.ObjectType        =  object.ObjectType   and

  //                 relation.ObjectID          =  object.ObjectID     and

  //                 relation.RelationStatus    =  object.ObjectStatus


{


  key relation.PlanVersion       as PlanVersion,
  key relation.ObjectType        as ObjectType,
  key relation.ObjectID          as ObjectID,

      relation.RelationStatus,

      relation.StartDate         as StartDate,
      relation.EndDate           as EndDate,
      relation.StartDate         as RelationStartDate,
      relation.EndDate           as RelationEndDate,
      relation.RelatedObjectType,
      relation.RelatedObjectID   as RelatedObjectID



}
where
      relation.ObjectType            = $parameters.P_ObjectType
  and relation.RelationShipDirection = $parameters.P_RelationShipDirection
  and relation.ReleationShip         = $parameters.P_RelationShip
  and relation.RelatedObjectType     = $parameters.P_RelatedObjectType        
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PDRELATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More