Infotype 1000 DB Table — the organizational-management object master: every object (org unit, position, job, cost center, task, etc., typed via OTYPE/OBJID under plan version PLVAR) with its short and long text (SHORT/STEXT), search-helper fields, planning status, and validity interval. This is one of the three organizational management tables alongside HRP1001 (relationships between objects — the important one, since SAP expresses org structure as relationships rather than a hierarchy column) and HRP1002 (object descriptions/texts); HRP1000 is the object registry that HRP1001's relationship rows and HRP1002's text rows both point back to via OTYPE/OBJID/PLVAR. This table is personal data when the object type is a person-holding object (e.g. position occupancy is resolved via HRP1001 relationships back to a PERNR) — any mirrored copy must be handled under consent-scoped access controls.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| CNS_VRS key | consilium versio | Plan Version | PLVAR | CHAR 2 | T778P |
| OBI_GEN key | obiectum genus | Object Type | OTYPE | CHAR 2 | T778O |
| OBI key | obiectum | Object ID | HROBJID | NUMC 8 | PLOGI |
| CNS_STA key | consilium status | Planning Status | ISTAT_D | CHAR 1 | T778S |
| INI_DIE_OBI key | initium dies obiectum | Start Date — validity interval start for this object record | BEGDATUM | DATS 8 | — |
| FIN_DIE_OBI key | finis dies obiectum | End Date — validity interval end for this object record | ENDDATUM | DATS 8 | — |
| LNG_CLV key | lingua clavis | Language Key | LANGU | LANG 1 | T002 |
| NUM_GIN_TBL key | numerus genus informationis tabula | Number of Infotype Record with Same Key | SEQNR | NUMC 3 | — |
| OBI_GEN2 | obiectum genus | Concatenation of Object Type and Object ID | OTJID | CHAR 10 | — |
| GIN | genus informationis | Infotype | INFOTYP | CHAR 4 | T778T |
| MUT | mutatus | Changed On | AEDTM | DATS 8 | — |
| USR_NOM | usor nomen | User Name | USRNAME | CHAR 12 | — |
| CSA | causa | Reason | REASN | CHAR 2 | — |
| TBL_SGN | tabula signum | Historical Record Flag | HISTO | CHAR 1 | — |
| TXT_GIN | textus genus informationis | Text Module for Infotype | ITXNR | NUMC 8 | — |
| OBI2 | obiectum | Object Abbreviation | SHORT_D | CHAR 12 | — |
| OBI_NOM | obiectum nomen | Object Name | STEXT | CHAR 40 | — |
| DIE | dies | Delimitation Date | GDATE | DATS 8 | — |
| OBI_AXQ | obiectum auxilium quaerendi | Object Abbreviation (Search Help) | HR_MCSHORT | CHAR 12 | — |
| NOM_AXQ | nomen auxilium quaerendi | Name (Search Help) | HR_MCSTEXT | CHAR 40 | — |
| MC_SEARK | Search Term | HR_MCSEARK | CHAR 52 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
PLVAR | T778P | PLVAR |
OTYPE | T778O | OTYPE |
OBJID | PLOGI | OBJID |
ISTAT | T778S | ISTAT |
LANGU | T002 | SPRAS |
INFTY | T778T | INFTY |