SAP Table HRP1000
Infotype 1000 DB Table
HRP1000 (Infotype 1000 DB Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link HRP1000 to other SAP tables.
HRP1000 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
PLVAR
Plan Version
|
PLVAR | T778P |
CHAR
|
2 | 0 | |
|
OTYPE
Object Type
|
OTYPE | T778O |
CHAR
|
2 | 0 | |
|
OBJID
Object ID
|
HROBJID | PLOGI |
NUMC
|
8 | 0 | |
|
ISTAT
Planning Status
|
ISTAT_D | T778S |
CHAR
|
1 | 0 | |
|
BEGDA
Start Date
|
BEGDATUM |
DATS
|
8 | 0 | ||
|
ENDDA
End Date
|
ENDDATUM |
DATS
|
8 | 0 | ||
|
LANGU
Language Key
|
LANGU | T002 |
LANG
|
1 | 0 | |
|
SEQNR
Number of Infotype Record with Same Key
|
SEQNR |
NUMC
|
3 | 0 | ||
|
OTJID
Concatenation of Object Type and Object ID
|
OTJID |
CHAR
|
10 | 0 | ||
|
INFTY
Infotype
|
INFOTYP | T778T |
CHAR
|
4 | 0 | |
|
AEDTM
Changed on
|
AEDTM |
DATS
|
8 | 0 | ||
|
UNAME
User Name
|
USRNAME |
CHAR
|
12 | 0 | ||
|
REASN
Reason
|
REASN |
CHAR
|
2 | 0 | ||
|
HISTO
Historical Record Flag
|
HISTO |
CHAR
|
1 | 0 | ||
|
ITXNR
Text Module for Infotype
|
ITXNR |
NUMC
|
8 | 0 | ||
|
SHORT
Object Abbreviation
|
SHORT_D |
CHAR
|
12 | 0 | ||
|
STEXT
Object Name
|
STEXT |
CHAR
|
40 | 0 | ||
|
GDATE
Delimitation date
|
GDATE |
DATS
|
8 | 0 | ||
|
MC_SHORT
Object Abbreviation
|
HR_MCSHORT |
CHAR
|
12 | 0 | ||
|
MC_STEXT
Name
|
HR_MCSTEXT |
CHAR
|
40 | 0 | ||
|
MC_SEARK
Search Term
|
HR_MCSEARK |
CHAR
|
52 | 0 |
HRP1000 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| HRP1000 | INFTY | HRP1000 | MANDT |
T778T
Infotypes
|
MANDT |
| HRP1000 | INFTY | HRP1000 | INFTY |
T778T
Infotypes
|
INFTY |
| HRP1000 | ISTAT | HRP1000 | ISTAT |
T778S
Planning Status
|
ISTAT |
| HRP1000 | ISTAT | HRP1000 | MANDT |
T778S
Planning Status
|
MANDT |
| HRP1000 | LANGU | HRP1000 | LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| HRP1000 | MANDT | HRP1000 | MANDT |
T000
Clients
|
MANDT |
| HRP1000 | OBJID | HRP1000 | MANDT |
PLOGI
Table Index HRP*
|
MANDT |
| HRP1000 | OBJID | HRP1000 | PLVAR |
PLOGI
Table Index HRP*
|
PLVAR |
| HRP1000 | OBJID | HRP1000 | OTYPE |
PLOGI
Table Index HRP*
|
OTYPE |
| HRP1000 | OBJID | HRP1000 | OBJID |
PLOGI
Table Index HRP*
|
OBJID |
| HRP1000 | OTYPE | HRP1000 | MANDT |
T778O
Object Types
|
MANDT |
| HRP1000 | OTYPE | HRP1000 | OTYPE |
T778O
Object Types
|
OTYPE |
| HRP1000 | PLVAR | HRP1000 | MANDT |
T778P
Plan Versions
|
MANDT |
| HRP1000 | PLVAR | HRP1000 | PLVAR |
T778P
Plan Versions
|
PLVAR |