HRP1001

Transparent Table Customizing Table
24 Fields 59 CDS Views

Infotype 1001 DB Table

HRP1001 is an SAP database table in S/4HANA. Infotype 1001 DB Table. It contains 24 fields. 59 CDS views read from this table.

CDS Views using this table (59)

ViewTypeJoinVDMDescription
FEE_CDS_ST view left_outer
hriq_cds_st_sc view from
hriq_cds_st_sc view left_outer
hriq_cds_st_sc view inner
I_CommissionObjectRelationship view_entity from BASIC Object Relationship
I_EmployeeOp view inner BASIC Employee CDS view for OP
I_EmployeePositionOP view from BASIC Employee Position for OnPremise
I_EmployeePositionOP view left_outer BASIC Employee Position for OnPremise
I_EmploymentManagerCl view from BASIC Employment Manager for Cloud
I_EmploymentManagerOP view from BASIC Employment Manager for OnPremise
I_EmploymentManagerOP view inner BASIC Employment Manager for OnPremise
I_EmplParentOrgManagerOP view from BASIC Employment Parent OrgUnit Manager for OnPremise
I_EmplReportingStructureOP view inner BASIC Employment Reporting Structure for OnPremise
I_EmplReportingStructureOP view from BASIC Employment Reporting Structure for OnPremise
I_FrcElmntToWrkCtrRelshpDEX view_entity from BASIC Defense FE Workcenter Rel Extractor
I_HCMEmployeeAddressBook view inner Employee Address Book
I_HCMObjectRelationship view_entity from BASIC HCM Object Relationship
I_HrRelation view from BASIC Read HRP1001 relation table
I_InsurClmOrgParent view from BASIC Basis View für Tabelle HRP1001
I_MfgHumRsceQualifnBP view from BASIC Basic View for HR Qualification and business partner
I_MfgQualificationGroup view from BASIC Display HR Qualification Group and its Catalog
I_PersWrkAgrmtToPartner view from BASIC Internal for HCM : Donot Use
I_PersWrkAgrmtToPartner view inner BASIC Internal for HCM : Donot Use
I_SalesGroupOrgUnit view inner BASIC Sales Group Organization Unit
I_SalesOfficeOrgUnit view inner BASIC Sales Office Organization Unit
P_DFS_ObjStructureRelationship view from BASIC
P_empfactsheet_minpernrop view from BASIC
P_EmployeePositionOP view from BASIC
P_EmploymentManagerOP view from BASIC
P_Employmentminpernrstop view from BASIC
P_Employmentminpernrstop_001 view from BASIC
P_EMPLREPORTINGSTRUCTUREOP view from BASIC
P_FrcElmntOrgStrucRelshp view from BASIC
P_MfgQualificationGroupList view from BASIC
P_O_PersWrkAgrmtToPartner view from BASIC
P_O_PersWrkAgrmtToPartner view inner BASIC
P_PDRELATION view from BASIC
P_PDRELATION_001 view from BASIC
P_PersWrkAgrmtMinForOPg view from BASIC
P_PersWrkAgrmtToPartner view inner BASIC
P_PersWrkAgrmtToPartner view from BASIC
P_PPM_User view inner BASIC
P_RespyMgmtFuncAndBPRelshp view from BASIC
P_RespyMgmtHdrAndFuncRelshp view from BASIC
P_RespyMgmtHdrSubTeamRelshp view from BASIC
P_RespyMgmtHdrSupTeamRelshp view from BASIC
P_RespyMgmtHdrTeamOwnrRelshp view from BASIC
P_RespyMgmtOrganizationUnit view from BASIC
P_RespyMgmtOrgUnitBPRelshp view inner BASIC
P_RespyMgmtOrgUnitRelshp view from BASIC
P_RespyMgmtTeamHierarchy view from BASIC
P_RespyMgmtTeamOrgUnitRelshp view from BASIC
PiqCds_AcademicEventPackage view left_outer Academic Event Package Relationship Data
PiqCds_StudentData view left_outer Student Data CDS VIew
PiqCdsHrp1001 view from View for Relationships
R_SrvcMgmtCntrlPersonBPRltn view_entity from BASIC Central Person and BP relation
R_SrvcMgmtPersnCntrlPersnRltn view_entity from BASIC Central Person and Person Relation
R_SrvcMgmtPersnQualifnRelation view_entity from BASIC Person and Qualification relation
R_SrvcMgmtQualifnQlfnGrpRltn view_entity from BASIC Qualification and Group Relation

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY otype OTYPE Object type
KEY objid HROBJID Object ID
KEY plvar PLVAR Plan version
KEY rsign RSIGN Relationship
KEY relat RELAT Relnship
KEY istat ISTAT_D Planning status
KEY priox PRIOX Priority
KEY begda BEGDATUM Start date
KEY endda ENDDATUM End Date
KEY varyf VARYF Variation field
KEY seqnr SEQNR IT record no.
infty INFOTYP Infotype
otjid OTJID Obj.type/obj.ID
subty SUBTYP Subtype
aedtm AEDTM Changed on
uname USRNAME User Name
reasn REASN Reason
histo HISTO Historical rec.
itxnr ITXNR Text Module
sclas SCLAS Rel.obj.type
sobid SOBID ID rel.object
prozt PROZT Percentage
adatanr HRADATANR ADATA number

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.

-- Infotype 1001 DB Table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRP1001 (
    MANDT,    -- Client [MANDT]
    OTYPE,    -- Object type [OTYPE]
    OBJID,    -- Object ID [HROBJID]
    PLVAR,    -- Plan version [PLVAR]
    RSIGN,    -- Relationship [RSIGN]
    RELAT,    -- Relnship [RELAT]
    ISTAT,    -- Planning status [ISTAT_D]
    PRIOX,    -- Priority [PRIOX]
    BEGDA,    -- Start date [BEGDATUM]
    ENDDA,    -- End Date [ENDDATUM]
    VARYF,    -- Variation field [VARYF]
    SEQNR,    -- IT record no. [SEQNR]
    INFTY,    -- Infotype [INFOTYP]
    OTJID,    -- Obj.type/obj.ID [OTJID]
    SUBTY,    -- Subtype [SUBTYP]
    AEDTM,    -- Changed on [AEDTM]
    UNAME,    -- User Name [USRNAME]
    REASN,    -- Reason [REASN]
    HISTO,    -- Historical rec. [HISTO]
    ITXNR,    -- Text Module [ITXNR]
    SCLAS,    -- Rel.obj.type [SCLAS]
    SOBID,    -- ID rel.object [SOBID]
    PROZT,    -- Percentage [PROZT]
    ADATANR,  -- ADATA number [HRADATANR]
    PRIMARY KEY (MANDT, OTYPE, OBJID, PLVAR, RSIGN, RELAT, ISTAT, PRIOX, BEGDA, ENDDA, VARYF, SEQNR)
);

Learn More