Skip to Content
author's profile photo Former Member
0
Former Member

Hierarchy Tables

Posted on Nov 13, 2004 at 05:40 AM 389 Views

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2004 at 05:05 AM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 12, 2004 at 12:13 PM

      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

  • author's profile photo Andreas Keppler
    Andreas Keppler
    Posted on Dec 15, 2004 at 11:38 AM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.