P_PDRELATION

CDS View

P_PDRELATION is a CDS View in S/4HANA. It contains 8 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 8 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_EmployeePositionOP view inner BASIC Employee Position for OnPremise
P_EmployeePositionOP view inner BASIC
P_EmploymentManagerOP view inner BASIC
P_EmploymentOp view inner BASIC
P_EmploymentOp_001 view inner BASIC
P_EMPLREPORTINGSTRUCTUREOP view inner BASIC
P_O_EmployeeOp view inner BASIC
P_O_EmploymentManager view left_outer BASIC
P_PDOBJECTRELATION view from BASIC

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ObjectID EmploymentInternalID,ObjectID,PersonnelNumber 6
KEY ObjectType ObjectType 1
KEY PlanVersion PlanVersion 1
EndDate EndDate,RelationEndDate 1
RelatedObjectID RelatedObjectID 1
RelatedObjectType RelatedObjectType 1
RelationStatus RelationStatus 1
StartDate RelationStartDate,StartDate 1 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PPDRELATION'
@VDM.viewType: #BASIC
define view P_PDRELATION
  as select from hrp1001 as relation
    inner join   t77s0   as systemtable on  grpid = 'PLOGI'
                                        and semid = 'PLOGI'
                                        and gsval = relation.plvar
{
  key relation.plvar as PlanVersion,
  key relation.otype as ObjectType,
  key relation.objid as ObjectID,
  key relation.rsign as RelationShipDirection,
  key relation.relat as ReleationShip,

      relation.istat as RelationStatus,



      relation.begda as StartDate,
      relation.endda as EndDate,

      relation.sclas as RelatedObjectType,
      relation.sobid as RelatedObjectID
}
where
  endda = '99991231'

//  as select from P_PDRELATION_001

//{

//  key PlanVersion,

//  key ObjectType,

//  key ObjectID,

//  key RelationShipDirection,

//  key ReleationShip,

//

//      RelationStatus,

//      StartDate,

//      EndDate,

//

//      RelatedObjectType,

//      RelatedObjectID

//}



// as select from hrp1001 as relation

//inner join t77s0 as systemtable on grpid = 'PLOGI' and semid = 'PLOGI' and gsval = relation.plvar

//{

//    key relation.plvar  as PlanVersion,

//    key relation.otype  as ObjectType,

//    key relation.objid  as ObjectID,

//    key relation.rsign  as RelationShipDirection,

//    key relation.relat  as ReleationShip,

//

//    relation.istat     as RelationStatus,

//

//

//

//    relation.begda     as StartDate,

//    relation.endda     as EndDate,

//

//    relation.sclas     as RelatedObjectType,

//    relation.sobid     as RelatedObjectID

//  }

//    where endda = '99991231'

//

Learn More