BICS_PROV_HIERARCHY SAP (Hierarchy Information (Catalog, Meta data and state)) Structure details

Dictionary Type: Structure
Description: Hierarchy Information (Catalog, Meta data and state)




ABAP Code to SELECT data from BICS_PROV_HIERARCHY
Related tables to BICS_PROV_HIERARCHY
Access table BICS_PROV_HIERARCHY




Structure field list including key, data, relationships and ABAP select examples

BICS_PROV_HIERARCHY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Hierarchy Information (Catalog, Meta data and state)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BICS_PROV_HIERARCHY TYPE BICS_PROV_HIERARCHY.

The BICS_PROV_HIERARCHY table consists of various fields, each holding specific information or linking keys about Hierarchy Information (Catalog, Meta data and state) data available in SAP. These include CATALOG_ENTRY (), NAME (Object Name), TEXT (Charact. text), VERSION (Version).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP BICS_PROV_HIERARCHY structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CHAR_IDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
CATALOG_ENTRY 0
NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
VERSIONVersion RSBOLAP_VERSIONCHAR3RSVERSION
DATE_FROMDate RSBOLAP_DATEDATS8DATUM
DATE_TODate RSBOLAP_DATEDATS8DATUM
SUPPORTS_NONE_UNIQUE_LEAVESBoolean RS_BOOLCHAR1RS_BOOL
DEFAULT_DRILL_LEVELLevel Number in a Hierarchy BICS_PROV_HIERARCHY_LEVEL_NUMINT25
DEFAULT_ALEAFNODSPDo Not Display Leaves for Inner-Nodes in the Query RSSHCRLEAFDSPCHAR1RSSHCRLEAFDSP
DEFAULT_NODE_ALIGNMENTAlignment of Objects (top/left, bottom/right, default) RSBOLAP_ALIGNMENTCHAR1RSBOLAP_ALIGNMENT
ALEAFNODCHDisplay for Generated Leaves Cannot Be Changed RSSHCLDSPCHCHAR1RSSHCLDSPCH
SUPPORTS_AD_HOC_MEMBER_ACCESSBoolean RS_BOOLCHAR1RS_BOOL
META 0
IDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
SVERVersion in Inclusion Table Key RSRSVERCHAR1CHAR1
NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
VERSIONVersion RSBOLAP_VERSIONCHAR3RSVERSION
DUEDATEDate RSBOLAP_DATEDATS8DATUM
HIEIDInternal hierarchy ID (unique ID) RSHIEIDCHAR25SYSUUID_25
START_DRILL_LEVELLevel Number in a Hierarchy BICS_PROV_HIERARCHY_LEVEL_NUMINT25
RESTTOPSIDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
ROOT_SIDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
NOREST_NODESSuppression of unassigned nodes RSHIERNORESTCHAR1RSBOOL
NOREST_FILTERSIDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
MAX_LEVELLevel Number in a Hierarchy BICS_PROV_HIERARCHY_LEVEL_NUMINT25
NODE_ALIGNMENTAlignment of Objects (top/left, bottom/right, default) RSBOLAP_ALIGNMENTCHAR1RSBOLAP_ALIGNMENT
NODE_VISIBILITYVisibility of Hierarchy Nodes RSBOLAP_NODE_VISIBILITYCHAR1RSBOLAP_VISIBILITY
ALEAFNODSPDo Not Display Leaves for Inner-Nodes in the Query RSSHCRLEAFDSPCHAR1RSSHCRLEAFDSP
ALEAFNODCHDisplay for Generated Leaves Cannot Be Changed RSSHCLDSPCHCHAR1RSSHCLDSPCH
LEVEL_TEXT 0
NODE_TYPES 0
STATE 0
IDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
ACTIVEBoolean RS_BOOLCHAR1RS_BOOL
START_DRILL_LEVELLevel Number in a Hierarchy BICS_PROV_HIERARCHY_LEVEL_NUMINT25
NODE_ALIGNMENTAlignment of Objects (top/left, bottom/right, default) RSBOLAP_ALIGNMENTCHAR1RSBOLAP_ALIGNMENT
NODE_VISIBILITYVisibility of Hierarchy Nodes RSBOLAP_NODE_VISIBILITYCHAR1RSBOLAP_VISIBILITY
MEMBER_ACCESS_MODERead Mode(F4) for Master Data Read Services RSMD_RS_READ_MODECHAR1RSMD_RS_READ_MODE
MEMBER_ACCESS_MODES 0
ALEAFNODSPDo Not Display Leaves for Inner-Nodes in the Query RSSHCRLEAFDSPCHAR1RSSHCRLEAFDSP
RESULT_SET_SORTING 0
TYPESort Type RSBOLAP_SORTING_TYPECHAR1RROSART
DIRECTIONSort Direction RSBOLAP_SORTING_DIRECTIONCHAR1RROSDIR
ATTRIBUTE_IDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
DATA_CELL_IDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
PREDEFINED_MEMBERS_ORDER 0
MEMBER_ACCESS_SORTING 0
TYPESort Type RSBOLAP_SORTING_TYPECHAR1RROSART
DIRECTIONSort Direction RSBOLAP_SORTING_DIRECTIONCHAR1RROSDIR
ATTRIBUTE_IDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
DATA_CELL_IDObject ID RSBOLAP_OBJECT_IDINT410RSBOLAP_OBJECT_ID
PREDEFINED_MEMBERS_ORDER 0
NODE_TYPES 0

Key field Non-key field



How do I retrieve data from SAP structure BICS_PROV_HIERARCHY using ABAP code?

As BICS_PROV_HIERARCHY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BICS_PROV_HIERARCHY as there is no data to select.

How to access SAP table BICS_PROV_HIERARCHY

Within an ECC or HANA version of SAP you can also view further information about BICS_PROV_HIERARCHY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!