SAP ABAP Table RSSH_S_HIEPROPS (Hierarchy properties)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DBA (Application Component) Data Basis
     ⤷ RSSH (Package) BW: Hierarchy Processing - General

Basic Data

Table Category	INTTAB	Structure
Structure	RSSH_S_HIEPROPS	Table Relationship Diagram
Short Description	Hierarchy properties

Delivery and Maintenance

Pool/cluster
Delivery Class
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	IOBJNM	☐	RSIOBJNM	RSIOBJNM	CHAR	30	0	InfoObject
2	HIEVERSFLG	☐	RSHIEVERFL	XFELD	CHAR	1	0	Hierarchies can have several versions
3	TIMEDEPHIENMFLG	☐	RSDHIENMTFL	XFELD	CHAR	1	0	Entire hierarchy is time-dependent
4	TIMEDEPSTRUCFLG	☐	RSHIENDTFL	XFELD	CHAR	1	0	Hierarchy structure is time-dependent
5	INTERVALLFLG	☐	RSHIEINTFL	XFELD	CHAR	1	0	Intervals permitted in hierarchy
6	HIESIGNCH	☐	RSSHSIGNCH	RSSHSIGNCH	CHAR	1	0	Reverse Sign for Hierarchy Nodes
7	HIETAB	☐	RSHIETAB	AS4TAB	CHAR	30	0	Hierarchy table (of a characteristic)	*
8	HIEINTTAB	☐	RSHINTAB	AS4TAB	CHAR	30	0	Hierarchy interval table (of a characteristic)	*
9	T_METAATTR	☐	RSD_T_IOBJ_HIE		TTYP	0	0
10	TH_HIECHA	☐	RSSH_TH_HIECHA		TTYP	0	0
11	S_VIOBJ	☐	RSD_S_VIOBJ		STRU	0	0
12	.INCLUDE	☐				0	0	Generated Table for View
13	IOBJNM	☐	RSDIOBJNM	RSIOBJNM	CHAR	30	0	InfoObject
14	OBJVERS	☐	RSOBJVERS	RSOBJVERS	CHAR	1	0	Object version
15	IOBJTP	☐	RSIOBJTP	RSIOBJTP	CHAR	3	0	Type of an InfoObject
16	OBJSTAT	☐	RSOBJSTAT	RSOBJSTAT	CHAR	3	0	Object Status
17	PROTECFL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
18	PRIVATEFL	☐	RSPRIVATEFL	XFELD	CHAR	1	0	InfoObject is Private
19	ACTIVFL	☐	RSACTIVFL	XFELD	CHAR	1	0	Active and revised version do not agree
20	FIELDNM	☐	RSDIOBJFIELDNM	FDNAME	CHAR	30	0	Field Name InfoObject In Structures (Not in database table)
21	CONTREL	☐	RSCONTREL	CHAR6	CHAR	6	0	Content release
22	CONTTIMESTMP	☐	RSCONTTIMESTMP	TZNTSTMPS	DEC	15	0	Content time stamp: Last modification to the object by SAP
23	ATRONLYFL	☐	RSATRONLYFL	XFELD	CHAR	1	0	InfoObject is Exclusively an Attribute (Not Used in ICs)
24	BCTCOMP	☐	RSDBCTCOMP		CHAR	10	0	Obsolete - do not translate
25	OWNER	☐	RSOWNER	XUBNAME	CHAR	12	0	Owner (Person Responsible)
26	BWAPPL	☐	RSBWAPPL		CHAR	10	0	BW Application (Namespace)
27	BDSFL	☐	RSDDOCFL	XFELD	CHAR	1	0	Characteristic is allowed as attribute of documents
28	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by
29	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	ORIGIN	☐	RSDORIGIN	RSDORIGIN	CHAR	1	0	Origin of Object
31	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key
32	TXTSH	☐	RSTXTSH	TEXT20	CHAR	20	0	Short description
33	TXTLG	☐	RSTXTLG	TEXT60	CHAR	60	0	Long description
34	.INCLUDE	☐				0	0	Properties of a characteristic
35	CHABASNM	☐	RSDCHABASNM	RSCHABASNM	CHAR	30	0	Reference InfoObject
36	BCHREFFL	☐	RSBCHREFFL	XFELD	CHAR	1	0	Characteristic references another basic characteristic(flag)
37	CHATP	☐	RSCHATP	RSCHATP	CHAR	3	0	Characteristc Type Based on Master Data Access
38	CMPSTA	☐	RSCMPSTA	RSCMPSTA	CHAR	1	0	Compound status
39	CMPOFFSET	☐	INT4	INT4	INT4	10	0	Natural number
40	CHACONST	☐	RSCHACONST	RSCHAVL	SSTR	1333	0	Characteristic Constant
41	AUTHRELFL	☐	RSDAUTHRELFL	XFELD	CHAR	1	0	Characteristic is relevant for authorization check
42	AUTHFIELD	☐	RSDAUTHFIELD	RSFIELD	CHAR	10	0	Authorization Field for Reporting Authorizations
43	ODSFL	☐	RSDODSFL	XFELD	CHAR	1	0	InfoObject is an ODS InfoObject (Flag)
44	.INCLUDE	☐				0	0	BEx attributes characteristic
45	CHAPRSNT	☐	RSCHAPRSNT	RSCHAPRSNT	CHAR	1	0	Display for Characteristics and Units
46	CHANAV	☐	RSCHANAV	RSCHANAV	CHAR	1	0	Navigation Indicator for Characteristics and Units
47	CHASEL	☐	RSCHASEL	RSCHASEL	CHAR	1	0	Selection restriction for characteristics
48	TXTDEF	☐	RSTXTDEF	RSTXTDEF	CHAR	1	0	Business Explorer Description
49	F4PRSNT	☐	RSF4PRSNT	RSF4PRSNT	CHAR	1	0	Representation of Filter Values During Query Execution
50	.INCLUDE	☐				0	0	BEX-MAP Basic Characteristic Properties
51	GISTP	☐	RSGISTP	RSGISTP	NUMC	1	0	Geographical type for a characteristic
52	GISATTRINM	☐	RSGISATTRINM	FDNAME	CHAR	30	0	Geographical attribute
53	INFOAREA	☐	RSINFOAREA	RSINFOAREA	CHAR	30	0	InfoArea
54	APPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
55	BOR_OBJTYP	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type
56	MDRCLNM	☐	RSMDCLNM	SEOCLSNAME	CHAR	30	0	Name of Master Data Read Class
57	MDRCLPA	☐	RSMDRCLPA	CHAR100	CHAR	100	0	Parameters for Master Data Read Class
58	NOVALFL	☐	RSNOVALFL	X	CHAR	1	0	Characteristic does not have a check table
59	HIGH_CARDINALITY	☐	RSDHIGH_CARD_CHA	RSDHIGH_CARD_CHA	NUMC	1	0	Characteristic with high cardinality (more than 2 mio recs.)
60	RDAFL	☐	RSDRDAFL	XFELD	CHAR	1	0	Permitted for RDA Process
61	F4DEFAULT	☐	RSF4DEFAULT	RSF4DEFAULT	CHAR	1	0	Selection of Filter Values for Query Definition
62	F4QUERYEXEC	☐	RSF4QUERYEXEC	RSF4QUERYEXEC	CHAR	1	0	Selection of Filter Values for Query Execution
63	ATTRIBFL	☐	RSATTRIBFL	XFELD	CHAR	1	0	Attributes (flag) exist for the characteristic
64	TIMDEPFL	☐	RSTIMDEPFL	XFELD	CHAR	1	0	Flag: Master data is time-dependent
65	KEYSORTEXT	☐	RSDKEYSOREXT	XFELD	CHAR	1	0	The key is sorted according to the external format (flag)
66	MASTAUTHFL	☐	RSDMASTAUTHFL	XFELD	CHAR	1	0	Maintenance of master data is relevant for authorization
67	EXPDSOURCEFL	☐	RSEXPDSOURCEFL	XFELD	CHAR	1	0	The characteristic is used as export data source
68	CHECKODS	☐	RSDCHECKODS	RSDODSOBJECT	CHAR	30	0	DataStore Object for Checking Characteristic Values
69	TXTTABFL	☐	RSDTXTTABFL	RSDCNVFL	CHAR	1	0	Text Table Exists
70	TXTTIMFL	☐	RSDTXTTIMFL	RSDCNVFL	CHAR	1	0	Texts are time-dep.
71	NOLANGU	☐	RSNOLANGU	XFELD	CHAR	1	0	Master data texts are language independent (flag)
72	TXTSHFL	☐	RSTXTSHFL	XFELD	CHAR	1	0	Short text exists (flag)
73	TXTMDFL	☐	RSTXTMDFL	XFELD	CHAR	1	0	Medium length text exists (flag)
74	TXTLGFL	☐	RSTXTLGFL	XFELD	CHAR	1	0	Long text exists (flag)
75	TXTXLFL	☐	RSTXTXLFL	XFELD	CHAR	1	0	The long text is extra long (String)
76	IOBJROUT	☐	RSIOBJROUT	RSUNIIDX	CHAR	25	0	Global transfer routine for InfoObjects
77	DBROUTID	☐	RSDBROUTID	RSUNIIDC25	CHAR	25	0	ID for database routines for basic char.
78	NUMBRANR	☐	RSNUMBRANR	CHAR7	CHAR	7	0	Number of the number range object of a characteristic
79	CNVSTATE	☐	RSDCNVSTATE	CHAR002	CHAR	2	0	See docu for conversion status
80	TREXFL	☐	RSTREXFL	XFELD	CHAR	1	0	Characteristic Uses TREX Search
81	SIDCONVERT	☐	RSDSIDCONVERT	RSDSIDCONVERT	CHAR	1	0	Conversion type for SID
82	SIDMONFL	☐	RSDSIDMONFL	RS_BOOL	CHAR	1	0	Flag indicating whether SID retains the order
83	.INCLUDE	☐				0	0	Hierarchy information on basic characteristics
84	HIETABFL	☐	RSHIETABFL	XFELD	CHAR	1	0	Characteristic with hierarchies
85	HIEVERFL	☐	RSHIEVERFL	XFELD	CHAR	1	0	Hierarchies can have several versions
86	HIENMTFL	☐	RSDHIENMTFL	XFELD	CHAR	1	0	Entire hierarchy is time-dependent
87	HIENDTFL	☐	RSHIENDTFL	XFELD	CHAR	1	0	Hierarchy structure is time-dependent
88	HIEINTFL	☐	RSHIEINTFL	XFELD	CHAR	1	0	Intervals permitted in hierarchy
89	HIESIGNCH	☐	RSSHSIGNCH	RSSHSIGNCH	CHAR	1	0	Reverse Sign for Hierarchy Nodes
90	HIETJOINFL	☐	RSHIETJOINFL	XFELD	CHAR	1	0	Use Temporal Hierarchy Join
91	HIETP	☐	RSHIETP	RSHIETP	CHAR	3	0	Type of Characteristic Related to Hierarchy
92	HIECLNM	☐	RSHIECLNM	SEOCLSNAME	CHAR	30	0	Name of Remote Hierarchy
93	HIECLPA	☐	RSHIECLPA	CHAR100	CHAR	100	0	Parameters for Remote Hierarchy Class
94	IOBJSIZCAT	☐	RSIOBJSIZCAT	TABKAT	CHAR	2	0	BW: Size category for InfoObject tables (master data/hier.)
95	IOBJDATCLS	☐	RSIOBJDATCLS	TABART	CHAR	5	0	BW: Data class for InfoObject tables(master data/ hierarch.)
96	UOMCONV	☐	RSUOMCONV	RSIOBJNM	CHAR	30	0	Base Unit of Measure
97	UOMCONVODS	☐	RSUOMCONVODS	RSDODSOBJECT	CHAR	30	0	Quantity ODS: Units of Measure for InfoObject
98	IOBJ_HANAMODEL	☐	RSMHANAMODEL	RSMHANAMODEL	CHAR	1	0	External SAP HANA view for BW object
99	SUPPORTS_XXL_ATTRIBUTES	☐	RSDSUPPXXLATTR	RSDSUPPXXLATTR	CHAR	1	0	Characteristic Supports XXL Attributes
100	MIME_TYPE	☐	SDOK_CNTTY	SDOK_CNTTY	CHAR	100	0	MIME Content Type
101	.INCLUDE	☐				0	0	InfoCube: BW Statistics
102	BWSTATISTICS	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
103	BWSTATWHM	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
104	.INCLUDE	☐				0	0	InfoCube: Default Query Properties
105	QPROPVERS	☐	RSQPROPVERS	RSQPROPVERS	NUMC	2	0	Conversion Version Query Properties
106	READMODE	☐	RSRREADMODE	RSRREADMODE	CHAR	1	0	Read Mode
107	CACHEMODE	☐	RSRCACHEMODE	RSRCACHEMODE	CHAR	1	0	Cache Mode
108	CACHEDELAY	☐	RSRCACHEDELAY		INT4	10	0	Cache Validity Period in Seconds
109	NLREADMODE	☐	RSD_NLREADMODE	RSD_NLREADMODE	CHAR	1	0	Read Modus for Near-Line Storage
110	NOPARALLELQDEF	☐	RRSNOPARALLEL	RS_BOOL	CHAR	1	0	no parallel processing
111	KIDSEL	☐	RRKIDSEL	RS_BOOL	CHAR	1	0	Use Selection of Structure Elements
112	CACHEUSEREXIT	☐	RSRNOCACHEFL	RSBOOL	CHAR	1	0	Indicator: Do not Use Cache for this Report
113	NOHPA	☐	RRSNOHPA	RS_BOOL	CHAR	1	0	Obsolete Field (Do Not Use BWA Index)
114	TREXOPS	☐	RSRTREXOPS	RSRTREXOPS	CHAR	1	0	Operations in SAP HANA/BWA
115	MATERIALIZEQUERYLAYER	☐	RSRMATERIALIZEQUERYLAYER	RS_BOOL	CHAR	1	0	Materialize Intermediate Query Result
116	PACKFLQDEF	☐	RSDHIGHPRECFL	RS_BOOL	CHAR	1	0	Process key figure with high precision
117	HANAMODELFL	☐	RSMHANAMODEL	RSMHANAMODEL	CHAR	1	0	External SAP HANA view for BW object
118	SUPP_QUERY_W_DUPL_KYF	☐	SUPPORTS_KEYFIGURE_DUPLICATES	RS_BOOL	CHAR	1	0	Supp. queries w/ dupl. KYF which cont. diff. aggregations
119	CACHEUSAGEMODE	☐	RSRCACHEUSAGEMODE	RSRCACHEUSAGEMODE	CHAR	1	0	Cache Usage Mode
120	DATA_INTEGRITY_SCENARIO	☐	RSR_DATA_INTEGRITY_SCENARIO	RSR_DATA_INTEGRITY_SCENARIO	CHAR	1	0	Data Integrity Profile
121	.INCLUDE	☐				0	0	Characteristic as UUID
122	IS_UUID	☐	RSDUUIDFL	RS_BOOL	CHAR	1	0	Characteristic Is UUID
123	UUID_EXT	☐	RSDUUIDEXT	FDNAME	CHAR	30	0	External Key of UUID
124	.INCLUDE	☐				0	0	Filter Properties of a Characteristic
125	FILTER_MODE	☐	RSDFILTERMODE	RSDFILTERMODE	CHAR	1	0	Use of a Characteristic in Filter and / or Result Set
126	EQ_FILTER_ONLY	☐	RSDEQFILTERONLY	RS_BOOL	CHAR	1	0	Characteristic Only Supports Equal Filter
127	.INCLUDE	☐				0	0	DDIC Properties of a (Basic) Characteristic
128	DATATP	☐	DATATYPE_D	DATATYPE	CHAR	4	0	Data Type in ABAP Dictionary
129	INTLEN	☐	RSDINTLEN	DDLENG	NUMC	6	0	Internal Length of InfoObjects in BW - see Docu
130	OUTPUTLEN	☐	OUTPUTLEN	DDLENG	NUMC	6	0	Output Length
131	CONVEXIT	☐	CONVEXIT	CONVEXIT	CHAR	5	0	Conversion Routine
132	FVALEX	☐	RSFVALEX	XFELD	CHAR	1	0	Domain fixed values exist (flag)
133	LOWERCASE	☐	LOWERCASE	AS4FLAG	CHAR	1	0	Lowercase letters allowed/not allowed
134	.INCLUDE	☐				0	0	DDIC Interface: Properties of a key figure
135	KYFTP	☐	RSKYFTP	RSKYFTP	CHAR	3	0	Key figure type
136	NCUMFL	☐	RSNCUMFL	RSNCUMFL	CHAR	1	0	Non-cumulative value (flag)
137	FIXCUKY	☐	RSFIXCUKY	WAERS	CUKY	5	0	Fixed currency
138	FIXUNIT	☐	RSFIXUNIT	MEINS	UNIT	3	0	Fixed Unit of Measure
139	AGGRGEN	☐	RSDAGGRGEN	RSDAGGRGEN	CHAR	3	0	Usual Aggregation
140	AGGREXC	☐	RSDAGGREXC	RSDAGGREXC	CHAR	3	0	Exception Aggregation
141	AGGRCHA	☐	RSAGGRCHA	RSIOBJNM	CHAR	30	0	Reference characteristic for exception aggregation
142	.INCLUDE	☐				0	0	Reporting attributes key figure
143	KYFDECIM	☐	RSKYFDECIM	RSKYFDECIM	CHAR	1	0	Decimal places (of a key figure)
144	KYFPRSNT	☐	RSKYFPRSNT	RSKYFPRSNT	CHAR	1	0	Display (of a key figure)
145	KYFNAV	☐	RSKYFNAV	RSKYFNAV	CHAR	1	0	Navigation indicator for key figures
146	UNINM	☐	RSUNINM	RSIOBJNM	CHAR	30	0	Unit InfoObject (currency/unit)
147	DOMANM	☐	DOMNAME	DOMNAME	CHAR	30	0	Domain name
148	PACKFL	☐	RSDHIGHPRECFL	RS_BOOL	CHAR	1	0	Process key figure with high precision
149	KYFSEMANTIC	☐	RSDKYFSEMANTIC	RSDKYFSEMANTIC	CHAR	1	0	Semantic of a Key Figure
150	STOCK_COVER_CALCTYPE	☐	RSDSTOCK_COVER_CALCTYPE	RSDSTOCK_COVER_CALCTYPE	CHAR	1	0	Type of Stock used by Stock Coverage Calculation
151	STOCK_COVER_PERIODS	☐	RSDSTOCK_COVER_PERIODS	RSDSTOCK_COVER_PERIODS	INT4	10	0	Number of Stock Cover Periods to be calculated
152	ICEFL	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
153	CHKTAB	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name
154	UNITP	☐	RSUNITP	RSUNITP	CHAR	3	0	Unit type
155	MARK	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
156	BCT_DEVCLASS	☐	DEVCLASS	DEVCLASS	CHAR	30	0	Package
157	.INCLUDE	☐				0	0	OBN Metadata of InfoObject
158	OBN_SYS_ALIAS	☐	RSDSYSALIAS	LOGSYS	CHAR	10	0	System Alias for OBN
159	T_NAIP	☐	RSD_T_NAIP		TTYP	0	0
160	T_ICE	☐	RSD_T_ICE		TTYP	0	0
161	T_HIECHA	☐	RSD_T_HIECHA		TTYP	0	0
162	T_AGGR	☐	RSD_T_AGGR		TTYP	0	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	30A