SAP ABAP Table RSOSOHIE (Directory for Master Data Hierarchies)

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	RSOSOHIE	Table Relationship Diagram
Short Description	Directory for Master Data Hierarchies

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OSOURCE	☑	ROOSOURCER	ROOSOURCED	CHAR	30	0	DataSource (OSOA/OSOD)	RSOLTPSOURCE
2	LOGSYS	☑	RSSLOGSYS	LOGSYS	CHAR	10	0	Source system	*
3	OBJVERS	☑	RSOBJVERS	RSOBJVERS	CHAR	1	0	Object version
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
14	OWNER	☐	RSOWNER	XUBNAME	CHAR	12	0	Owner (Person Responsible)	*
15	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
16	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
17	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
18	SOURCESYS_HIE	☐	RSAD_SOURCESYS_HIE	RS_BOOL	CHAR	1	0	Fill Source System ID with File
19	RESOLVE_NODES	☐	RSAD_RESOLVE_NODES		CHAR	1	0	Resolve Leaf Values and Node InfoObjects

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSOSOHIE	OSOURCE	RSOLTPSOURCE	OLTPSOURCE
2	RSOSOHIE	TSTPNM	USR02	BNAME	KEY	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in