Skip to Content

where used list

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2004 at 02:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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