P_HrRelation

Read HRP1001 relation table and wfd_d_keymap table | view: PHRRELATN | Extraction: Not supported | Component: Business Logic in Workforce Domain
Column Name Description
PlanVersion FK Plan Version
ObjectType FK Object Type
HumRsceObjectId FK Object ID
HumRsceRelshpSpecification Relationship Specification Show values
HumRsceRelationship FK Relationship Between Objects
Column Name Description
Column Name Description
Column Name Description
StartDate Start Date
EndDate End Date
Column Name Description
HumRsceRelshpSpecification Relationship Specification Show values
Column Name Description Domain name
HumRsceRelatedObjectId ID of Related Object CHAR45
Master Data Relations Join Conditions
Object ID
  • Client
  • Object ID
  • Object Type
  • Plan Version
  • P_HRRELATION.MANDT == PLOGI.MANDT
  • P_HRRELATION.HUMRSCEOBJECTID == PLOGI.OBJID
  • P_HRRELATION.OBJECTTYPE == PLOGI.OTYPE
  • P_HRRELATION.PLANVERSION == PLOGI.PLVAR
Relationship Between Objects
  • Client
  • Relationship Between Objects
  • P_HRRELATION.MANDT == T778V.MANDT
  • P_HRRELATION.HUMRSCERELATIONSHIP == T778V.RELAT
Object Type
  • Client
  • Object Type
  • P_HRRELATION.MANDT == T778O.MANDT
  • P_HRRELATION.OBJECTTYPE == T778O.OTYPE
Plan Version
  • Client
  • Plan Version
  • P_HRRELATION.MANDT == T778P.MANDT
  • P_HRRELATION.PLANVERSION == T778P.PLVAR
Type of Related Object
  • Client
  • Type of Related Object
  • P_HRRELATION.MANDT == T778O.MANDT
  • P_HRRELATION.RELATEDOBJECTTYPE == T778O.OTYPE
Planning Status
  • Client
  • Planning Status
  • P_HRRELATION.MANDT == T778S.MANDT
  • P_HRRELATION.STATUS == T778S.ISTAT