Aggregates (Levels)

[Former Member]

Hi, Somebody know if exist a Table where I can get the level of an aggregate?

I have many Cubes with many aggregates (e.g. Aggregate 100100 Parent / 100101 Child / 100102 Grandson, etc..)

I need to separate all aggregates Parents, and childs.

**I know I can get this in RSA1 IN "Aggregates Tree" icon; but I need get its level for all Aggregatescubes.

Tanks so much

P.S. I triend in SE16 Table: RSDDAGGRDIR, but I not view a field with agregate tree level.

[Former Member · Accepted solution]

Hi

Check table RSDDSTATAGGRDEF field AGGRST(Aggregation level of characteristics in aggregates)

Is this what you are looking for?

Regards

Manga(Assign points if it helps)

[Former Member · Accepted solution]

Thanks Manga,

I need to know the the same information I get in RSA1 / Aggregate Maitenance / Aggregate Tree "icon":

e.g. This leves in the tree:

100001 (Level 1)

100506 (Level 2)

100989 (Level 3)

Thansk

[Former Member · Accepted solution]

Most aggregate data can be found in the RSDDSGGR* tables.

I think what you're looking for is in the RSDDAGGRDIR table in a field called PARENTUID. It is the internal ID rather than the recognizable aggr number.

[former_member184494 · Accepted solution]

Befoe viewing the field , you will have to havethe conversion switched on so that you see the values instead of the GUIDs...

Arun

[Former Member · Accepted solution]

Thanks so much,

It is exactly what I looking for

Regards