Skip to Content
author's profile photo Dieter Zenger
0
Dieter Zenger

where used list

Posted on Jul 14, 2004 at 06:59 AM 31 Views

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

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

    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 a comment
    10|10000 characters needed characters exceeded

    • Marc Bernard
      Jul 15, 2004 at 01:07 AM

      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

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.