SAP ABAP Table RSOSOHIETSH (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	RSOSOHIETSH	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	LANGU	☑	SPRAS	SPRAS	LANG	1	0	Language Key	*
2	OLTPSOURCE	☑	RSOLTPSOURCER	RSOLTPSOURCE	CHAR	30	0	DataSource	RSOSOHIESH
3	SRC3DTYP	☑	RSSRC3DTYP	RSSRC3DTYP	CHAR	3	0	Type of Source System (Logical Unit / Product)	*
4	SRC3DREL	☑	RSSRC3DREL	RSSRC3DREL	CHAR	3	0	Release of a Non-SAP Source System	*
5	HIENM	☑	RSHIECHAR	CHAR30	CHAR	30	0	Customer-Defined Hierarchy Name
6	HIEVERS	☑	RSVERSION	RSVERSION	CHAR	3	0	Hierarchy version
7	HIEDATETO	☑	RSDATETO	DATUM	DATS	8	0	Valid-to date
8	HIECLASS	☑	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
9	HIEDATEFROM	☑	RSDATEFROM	DATUM	DATS	8	0	Valid-From Date
10	BWOSOURCE	☐	RSOSOURCE	RSOSOURCE	CHAR	30	0	InfoSource (master data, text and hierarchies)
11	HIEID	☐	RSHIEID	SYSUUID_25	CHAR	25	0	Internal hierarchy ID (unique ID)
12	TXTSH	☐	RSTXTSH	TEXT20	CHAR	20	0	Short description
13	TXTMD	☐	RSTXTMD	TEXT40	CHAR	40	0	Medium description
14	TXTLG	☐	RSTXTLG	TEXT60	CHAR	60	0	Long description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSOSOHIETSH	OLTPSOURCE	RSOSOHIESH	OLTPSOURCE	TEXT	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in