SAP Table RSSOSHIER
DataSource/InfoSource Hierarchy
RSSOSHIER (DataSource/InfoSource Hierarchy) 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 RSSOSHIER to other SAP tables.
RSSOSHIER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LANGU | Language Key | SPRAS | LANG | 1 | 0 | |||||||||||||||
| 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 | |||||||||||||||
| TXTSH | Short description | RSTXTSH | CHAR | 20 | 0 | |||||||||||||||
| TXTMD | Medium description | RSTXTMD | CHAR | 40 | 0 | |||||||||||||||
| TXTLG | Long description | RSTXTLG | CHAR | 60 | 0 | |||||||||||||||
RSSOSHIER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| RSSOSHIER | OSOURCE | RSSOSHIER | OSOURCE | RSOLTPSOURCE | Replicate Table for OLTP Sources in BW | OLTPSOURCE |
| RSSOSHIER | OSOURCE | RSSOSHIER | LOGSYS | RSOLTPSOURCE | Replicate Table for OLTP Sources in BW | LOGSYS |
| RSSOSHIER | OSOURCE | RSSOSHIER | OBJVERS | RSOLTPSOURCE | Replicate Table for OLTP Sources in BW | OBJVERS |
| RSSOSHIER | TSTPNM | * | USR02 | Logon Data (Kernel-Side Use) | MANDT | |
| RSSOSHIER | TSTPNM | RSSOSHIER | TSTPNM | USR02 | Logon Data (Kernel-Side Use) | BNAME |
