where used list

[dieterzenger]

Hello, is it possible to find out which structures / queries are restricted to a specific value (single value or hierarchy) of an infoobject.

e.g.

We restricted the item to a value, which was deleted after the query was built.

Thank you

Dieter

[Former Member]

Hello Dieter,

You might be able to do this using a combination of tables RSZRANGE, RSZELTXREF and RSZCOMPDIR.

1. RSZRANGE - restrict on HIENM (Hierarhcy name) and it gives you the list of objects that use the hierarchy. Then download only the values of field ELTUID.

2. RSZELTXREF - use the values from RSZRANGE to populate the field TELTUID. When you run it, it will give you a list of the locations of the object i.e. query or structure.

3. RSZELTXREF - re-enter the values you have just downloaded into the TLTUID field again. Run it. (This will then give you a list of the queries that are using structures. Add these to the list you got from Step 2.

4. RSZCOMPDIR - enter the values from Step 2 and 3 into the COMPUID field, run it and you will get a list of the queries using the hierarchy.

Hope it helps.

[former_member93896]

Dieter, Allan,

years ago I developed a program that you can use for characteristic values and key figures (not for hierarchy nodes but you can enhance the program to do it).

I can't do attachments here please send me an email at marc.bernard @ sap.com

Regards,

Marc

SAP NetWeaver RIG, US BI