SAP ABAP Table RSOSOHIESH (Shadow Table: Hierarchy Information in BW)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DST (Application Component) Data Staging
     ⤷ RSAR (Package) Data import from source system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	RSOSOHIESH	Table Relationship Diagram
Short Description	Shadow Table: Hierarchy Information in BW

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OLTPSOURCE	☑	RSOLTPSOURCER	RSOLTPSOURCE	CHAR	30	0	DataSource
2	SRC3DTYP	☑	RSSRC3DTYP	RSSRC3DTYP	CHAR	3	0	Type of Source System (Logical Unit / Product)	*
3	SRC3DREL	☑	RSSRC3DREL	RSSRC3DREL	CHAR	3	0	Release of a Non-SAP Source System	*
4	HIENM	☑	RSHIECHAR	CHAR30	CHAR	30	0	Customer-Defined Hierarchy Name
5	HIEVERS	☑	RSVERSION	RSVERSION	CHAR	3	0	Hierarchy version
6	HIEDATETO	☑	RSDATETO	DATUM	DATS	8	0	Valid-to date
7	HIECLASS	☑	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
8	HIEDATEFROM	☑	RSDATEFROM	DATUM	DATS	8	0	Valid-From Date
9	BWOSOURCE	☐	RSOSOURCE	RSOSOURCE	CHAR	30	0	InfoSource (master data, text and hierarchies)
10	HIEID	☐	RSHIEID	SYSUUID_25	CHAR	25	0	Internal hierarchy ID (unique ID)
11	FLSORTED	☐	RSFLSORTED	X	CHAR	1	0	Hierarchy transfer with sorted node(s)
12	FLINTRVL	☐	RSFLINTRVL	X	CHAR	1	0	Hierarchy transfer with intervals
13	FLTIMDEP	☐	RSFLTIMDEP	X	CHAR	1	0	Transfer of time-dependent hierarchies

History

Last changed by/on	SAP	20130604
SAP Release Created in