I_HRRELATION

CDS View

Read HRP1001 relation table

I_HRRELATION is a CDS View in S/4HANA. Read HRP1001 relation table. It contains 2 fields. 11 CDS views read from this table.

Used by 11 CDS view(s) 2 fields

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_MaintWrkCtrAssignedPersonVH view from CONSUMPTION Value Help for Maint. Work Center Person
C_MaintWrkCtrAssignedPersonVH view inner CONSUMPTION Value Help for Maint. Work Center Person
C_PersnWrkAgrmtDetForOPg view inner CONSUMPTION Person Work Agreement Details for Object Page
C_PersnWrkAgrmtTagForOPg view left_outer CONSUMPTION Person Work Agreement Tag Details for Object Page
I_PersWrkAgrmtPosToMgrPosition view left_outer COMPOSITE Relation between position and manager position
I_WorkforcePerson view inner COMPOSITE Workforce Person Details
I_WorkforcePersonSkillTags view inner COMPOSITE Workforce Person Skill Tags
P_O_EmploymentMgrForKeyDate view left_outer COMPOSITE
P_O_PersonWorkAgreement view from COMPOSITE
P_O_PersonWorkAgreement view inner COMPOSITE
P_WorkforcePersonImageURL view inner BASIC

Fields (2)

KeyField CDS FieldsUsed in Views
KEY HumRsceObjectId PersonnelNumber,PersonWorkAgreement 2
KEY HumRsceRelatedObjectId Person,PersonWorkAgreement 4 
@AbapCatalog.sqlViewName: 'IHRRELATN'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Read HRP1001 relation table'
//internal

define view I_HrRelation
//  as select from P_HrRelation as relation

  as select from WFD_TF_HrRelation(p_client:$session.client) as relation

{
  key PlanVersion,
  key ObjectType,
  key HumRsceObjectId,
  key HumRsceRelshpSpecification,
  key HumRsceRelationship,
      Status,
      StartDate,
      EndDate,
      RelatedObjectType,
      HumRsceRelatedObjectId


}


//define view I_HrRelation

//  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  HumRsceObjectId,

//  key relation.rsign     as  HumRsceRelshpSpecification,

//  key relation.relat     as  HumRsceRelationship,

//      relation.istat     as  Status,

//      relation.begda     as  StartDate,

//      relation.endda     as  EndDate,

//      relation.sclas     as  RelatedObjectType,

//      relation.sobid     as  HumRsceRelatedObjectId

//

//

//}

/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More