Hierarchy Tables

[#1]

Hi I'm learning SAP BW and I have a question re External Hierarchy Tables.

/BIC/HIO_SREP1 - Hierarchy Table

/BIC/KIO_SREP1 - Hierarchy SID Table

/BIC/IIO_SREP1 - SID Hierarchy Structure

/BIC/JIO_SREP1 - Hierarchy Interval Tables

Re: The above 4 tables.

1. What is the purpose of each table.

2. What are the relationships between the tables?

3. How does each table interface with the infocube and how?

Looking to be able to draw a model on how these tables work together.

Hope this isn't too vague. Been trying to figure it out for a while but dont have enough BW experience to solve this brain teaser.

[Former Member]

Hi Stephen,

just check the respective fields of the tables via the TCODE SE11. It is pretty explanatory.

If you have any specific question regarding any of the fields, please post again.

Cheers

Andreas

[Former Member]

Hi,

Hierarchy tables are used to store flexible external hierarchies as opposed to internal hierarchies.

/BIC/HIO_SREP1 - version and time dependency for whole hierarchy

/BIC/KIO_SREP1 - SID for version and time dependency for whole hierarchy

/BIC/IIO_SREP1 - time dependency for hierarchy structures

/BIC/JIO_SREP1 - User of interval instead of single values to assign range of values to a specific hierarchy node

Hope this helps

arun

[Former Member]

Hi, Could you go into more detail into the I an K tables?

Please give me a beginners guide to what they actually do???

Hi.

Anybody have a full understanding of the use of the I and K hierarchy tables?

Please explain how they interact with the H and L tables ( I have understanding of these) and how they interact with the assigned info-object.

If you are feeling really explanatory please also explain the use of the following fields.

Hierarchy 'I' table

HIESID

SVER

PRED

SUCC

LISTNO

FACTOR

TLEVEL

NTYPEID

Hierarchy 'K' table

HIESID

NIOBJNM

NODENAME

LINKNO

SID

OSID

Id hope the question would be of use to a lot of people wondering exactly how the hierarchy tables work.

Back to top