SAP Table RSOSOHIE
Directory for Master Data Hierarchies
RSOSOHIE (Directory for Master Data Hierarchies) 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 RSOSOHIE to other SAP tables.
RSOSOHIE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OSOURCE | DataSource (OSOA/OSOD) | ROOSOURCER | RSOLTPSOURCE | CHAR | 30 | 0 | ||||||||||||||
| LOGSYS | Source system | RSSLOGSYS | CHAR | 10 | 0 | |||||||||||||||
| OBJVERS | Object version | RSOBJVERS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| HIENM | Customer-Defined Hierarchy Name | RSHIECHAR | CHAR | 30 | 0 | |||||||||||||||
| HIEVERS | Hierarchy version | RSVERSION | CHAR | 3 | 0 | |||||||||||||||
| HIEDATETO | Valid-to date | RSDATETO | DATS | 8 | 0 | |||||||||||||||
| HIECLASS | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | 0 | |||||||||||||||
| HIEDATEFROM | Valid-From Date | RSDATEFROM | DATS | 8 | 0 | |||||||||||||||
| BWOSOURCE | InfoSource (master data, text and hierarchies) | RSOSOURCE | CHAR | 30 | 0 | |||||||||||||||
| HIEID | Internal hierarchy ID (unique ID) | RSHIEID | CHAR | 25 | 0 | |||||||||||||||
| FLSORTED | Hierarchy transfer with sorted node(s) | RSFLSORTED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| FLINTRVL | Hierarchy transfer with intervals | RSFLINTRVL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| FLTIMDEP | Transfer of time-dependent hierarchies | RSFLTIMDEP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| OWNER | Owner (Person Responsible) | RSOWNER | CHAR | 12 | 0 | |||||||||||||||
| TSTPNM | Last changed by | RSTSTPNM | USR02 | CHAR | 12 | 0 | ||||||||||||||
| TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 15 | 0 | |||||||||||||||
| SOURCESYS_HIE | Fill Source System ID with File | RSAD_SOURCESYS_HIE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| RESOLVE_NODES | Resolve Leaf Values and Node InfoObjects | RSAD_RESOLVE_NODES | CHAR | 1 | 0 | |||||||||||||||
RSOSOHIE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| RSOSOHIE | OSOURCE | RSOSOHIE | OSOURCE | RSOLTPSOURCE | Replicate Table for OLTP Sources in BW | OLTPSOURCE |
| RSOSOHIE | OSOURCE | RSOSOHIE | LOGSYS | RSOLTPSOURCE | Replicate Table for OLTP Sources in BW | LOGSYS |
| RSOSOHIE | OSOURCE | RSOSOHIE | OBJVERS | RSOLTPSOURCE | Replicate Table for OLTP Sources in BW | OBJVERS |
| RSOSOHIE | TSTPNM | * | USR02 | Logon Data (Kernel-Side Use) | MANDT | |
| RSOSOHIE | TSTPNM | RSOSOHIE | TSTPNM | USR02 | Logon Data (Kernel-Side Use) | BNAME |
