SAP table HRP1001 (Infotype 1001 DB Table)

SAP table HRP1001 has 12 primary key fields being MANDT,OTYPE,OBJID,PLVAR,RSIGN,RELAT,ISTAT,PRIOX,BEGDA,ENDDA,VARYF,SEQNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OTYPE Object Type CHAR 2 0 T778O OTYPE
OBJID Object ID NUMC 8 0 PLOGI HROBJID
PLVAR Plan Version CHAR 2 0 T778P PLVAR
RSIGN Relationship Specification CHAR 1 0 RSIGN
A bottom up
B top down
RELAT Relationship Between Objects CHAR 3 0 T778V RELAT
ISTAT Planning Status CHAR 1 0 T778S ISTAT_D
PRIOX Priority CHAR 2 0 PRIOX
BEGDA Start Date DATS 8 0 BEGDATUM
ENDDA End Date DATS 8 0 ENDDATUM
VARYF Variation Field for File PLOG CHAR 10 0 VARYF
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
INFTY Infotype CHAR 4 0 T778T INFOTYP
OTJID Concatenation of Object Type and Object ID CHAR 10 0 OTJID
SUBTY Subtype CHAR 4 0 T778U SUBTYP
AEDTM Changed on DATS 8 0 AEDTM
UNAME User Name CHAR 12 0 USRNAME
REASN Reason CHAR 2 0 REASN
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXNR Text Module for Infotype NUMC 8 0 ITXNR
SCLAS Type of Related Object CHAR 2 0 T778O SCLAS
SOBID ID of Related Object CHAR 45 0 SOBID
PROZT Weighting Percentage DEC 5 2 PROZT
ADATANR ADATA Number CHAR 32 0 HRIADATANR HRADATANR

HRP1001 foreign key relationships

Table Field Check Table Check Field
0 HRP1001 ADATANR HRIADATANR Additional Data Numbers MANDT
1 HRP1001 INFTY T778T Infotypes MANDT
1 HRP1001 INFTY T778T Infotypes INFTY
0 HRP1001 ISTAT T778S Planning Status MANDT
1 HRP1001 MANDT T000 Clients MANDT
0 HRP1001 OBJID PLOGI Table Index HRP* MANDT
0 HRP1001 OBJID PLOGI Table Index HRP* PLVAR
0 HRP1001 OBJID PLOGI Table Index HRP* OTYPE
0 HRP1001 OBJID PLOGI Table Index HRP* OBJID
1 HRP1001 OTYPE T778O Object Types MANDT
1 HRP1001 OTYPE T778O Object Types OTYPE
0 HRP1001 PLVAR T778P Plan Versions MANDT
1 HRP1001 RELAT T778V Relationships MANDT
0 HRP1001 SCLAS T778O Object Types MANDT
0 HRP1001 SCLAS T778O Object Types OTYPE
1 HRP1001 SUBTY T778U Subtypes MANDT
1 HRP1001 SUBTY T778U Subtypes INFTY
1 HRP1001 SUBTY T778U Subtypes SUBTY