I_HRRELATION

CDS View
2 Fields 12 CDS Views

Read HRP1001 relation table

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

CDS Views using this table (12)

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_PersWrkAgrmtMinForOPg view from COMPOSITE Person Work Agreement 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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Read HRP1001 relation table
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_HRRELATION (
    HUMRSCEOBJECTID,
    HUMRSCERELATEDOBJECTID,
    PRIMARY KEY (HUMRSCEOBJECTID, HUMRSCERELATEDOBJECTID)
);

Learn More