Infotype 1001 DB Table — the organizational-management relationships table, and the important one of the three OM tables (alongside HRP1000 object master and HRP1002 object descriptions), because SAP expresses org structure as directed relationship edges between objects rather than as a hierarchy column: a source object (OTYPE/OBJID/PLVAR) is linked to a related object (SCLAS/SOBID) via a typed relationship (RELAT, with direction sign RSIGN) — e.g. an org unit 'reports to' another org unit, a position 'belongs to' an org unit, or a person 'holds' a position — under a validity interval. Reconstructing the org chart or resolving who holds a given position requires walking this relationship table, not reading a parent-column. This table is personal data when a relationship links to a person-holding object (e.g. a position-holder relationship terminating in a PERNR-linked object) — 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 |
| OBI_GEN_FNS key | obiectum genus fons | Object Type — type of the source object in the relationship | OTYPE | CHAR 2 | T778O |
| OBI_FNS_RLT key | obiectum fons relatio | Object ID — ID of the source object in the relationship | HROBJID | NUMC 8 | PLOGI |
| CNS_VRS key | consilium versio | Plan Version | PLVAR | CHAR 2 | T778P |
| RLT_DRC_GEN key | relatio directio genus | Relationship Specification — direction sign (e.g. A for 'to', B for 'from') for the relationship type | RSIGN | CHAR 1 | — |
| RLT_GEN_COD key | relatio genus codex | Relationship Between Objects — the relationship type code (e.g. reports-to, belongs-to, holds) | RELAT | CHAR 3 | T778V |
| CNS_STA key | consilium status | Planning Status | ISTAT_D | CHAR 1 | T778S |
| PRI key | prioritas | Priority | PRIOX | CHAR 2 | — |
| INI_DIE_RLT key | initium dies relatio | Start Date — validity interval start for this relationship | BEGDATUM | DATS 8 | — |
| FIN_DIE_RLT key | finis dies relatio | End Date — validity interval end for this relationship | ENDDATUM | DATS 8 | — |
| CMP key | campus | Variation Field for File PLOG | VARYF | CHAR 10 | — |
| NUM_GIN_TBL key | numerus genus informationis tabula | Number of Infotype Record with Same Key | SEQNR | NUMC 3 | — |
| GIN | genus informationis | Infotype | INFOTYP | CHAR 4 | T778T |
| OBI_GEN | obiectum genus | Concatenation of Object Type and Object ID | OTJID | CHAR 10 | — |
| SBG | subgenus | Subtype | SUBTYP | CHAR 4 | T778U |
| 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 | — |
| GEN_OBI_MTA | genus obiectum meta | Type of Related Object — object type of the target object in the relationship | SCLAS | CHAR 2 | T778O |
| OBI_MTA_RLT | obiectum meta relatio | ID of Related Object — object ID of the target object in the relationship (e.g. the PERNR-linked object ID for a holder relationship) | SOBID | CHAR 45 | — |
| PROZT | Weighting Percentage | PROZT | DEC 5,2 | — | |
| NUM | numerus | ADATA Number | HRADATANR | CHAR 32 | HRIADATANR |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
OTYPE | T778O | OTYPE |
OBJID | PLOGI | OBJID |
PLVAR | T778P | PLVAR |
RELAT | T778V | RELAT |
ISTAT | T778S | ISTAT |
INFTY | T778T | INFTY |
SUBTY | T778U | SUBTY |
SCLAS | T778O | OTYPE |
ADATANR | HRIADATANR | ADATANR |