Value Help for Queries with Hierarchies

Value Help for Hierarchy Nodes

When you call value help, the History, Browse History, and Search tab pages are displayed in the Value Help for Hierarchy Nodes dialog window:

• History

  You can reuse a node selection. The system displays the last 20 hierarchy nodes you selected (user-specific). The first node is automatically selected. You have the following options:

  • You go to the Browse Hierarchy tab page by choosing Show Selected Nodes in Hierarchy. The hierarchy node you selected is displayed in the subtree.

  • You go to the Search tab page by choosing Search in Selected Subtree.

    If the node you selected is a leaf, which means there is no successor node, the predecessor node automatically becomes the subtree.

• Browse Hierarchy

  You can browse a hierarchy node in a subtree.

  By choosing Expand and Collapse, you can expand and collapse the hierarchy or subtree.

  You go to the Search tab page by choosing Search in Selected Subtree.

• Search

  You can search for a node by the key, description, and attribute. In the Search in Description field, you can search by key or description as long as a key or description has been defined for the display in the characteristics of the InfoObject (transaction RSD1 on the Business Explorer tab page).

  You can use search patterns by entering only part of the character string that is being searched for. The system displays all the hierarchy nodes that contain this character string. The search is based on the external display of the value.

  The search is intended for large hierarchies.

  • You can limit the search to a subtree of the hierarchy by selecting the appropriate subtree in the Restrict to Subtree field.

  • You go to the Browse Hierarchy tab page by choosing Show Selected Nodes in Hierarchy. The hierarchy node you selected is displayed in the subtree.

In addition, the following information and functions are provided:

• Details button

  If you choose Details, you navigate to the master data of the InfoObject. The attributes, texts, and direct path are displayed in the hierarchy.

• Hierarchy field

  If the hierarchy name was defined in the query as a variable and the variable name is initial, then the field is not ready for input.

• Version field

  Hierarchies can be modeled as version-dependent. This field is displayed only if the hierarchy is version-dependent.

  If the version was defined as a variable in the query and the name of the variable was not filled, then the field is ready for input and it is filled with a default value.

  The system behaves as follows:

  • If the hierarchy is version-dependent, then the value help for hierarchy names is also version-dependent.

  • If the hierarchy version is defined as a variable in the query, then the system can only determine the name of the hierarchy if the variable values are entered in the search.

Time Dependency of Hierarchies

Hierarchies can be modeled time-dependently, in which case they are valid for a specific interval or period. The value help for hierarchies (and also hierarchy names) is dependent on the key date and the end of the validity period.

Hierarchy names are only considered if the key date is within the validity period of the hierarchy. The two dates can be defined as automatic values in the query (system date) or as variables.

• If key date and end of validity period are defined as variables in the query, they are displayed in the search.

• If no values were specified in the variable, the system date is used to determine valid hierarchies.

Search in Hierarchies

If the variables for hierarchy version, hierarchy name, key date, and validity date are filled in the search, the system can easily determine hierarchies. Otherwise the search uses the standard values. You can change these values.

When you select a hierarchy node in the value help, the selected variables are also automatically used in the search.

All the characteristic values that are not used in the hierarchy are displayed under the REST_H node.

Value Help for Hierarchy Names

If the hierarchy name is defined as a variable in the query, then it appears in the search as a search criterion.

For hierarchy versions, key date, and validity period, the system behaves the same way as the value help for the hierarchy.