!--a11y-->
Where-Used List for Substances in Formulas and
Recipes 
You can use this function for substances to determine the formulas or recipes that contain the substances. You have the following options:
· From the hit list, you can determine the formulas or recipes that contain one or more substances in the hit list.
· When editing a substance, you can determine the formulas that contain the substance using special value assignment types in the property tree for the substance.
You set up where-used lists as user exits of the category SUB_USAGE in Customizing for the SAP component Environment, Health and Safety (EH&S) under Manage User Exits. Check whether the following user exits are set up for the described where-used lists:
Where-Used List |
User Exit |
Function Module |
Search for recipes from the hit list |
RECIPE04 |
RCP733_SUB_USAGE_VIA_RCP |
Search for formulas from the hit list and from the property tree |
RECIPE06 |
RCP736_SUB_USAGE_VIA_FRM |
For the user exits, the specification category SUBSTANCE must be specified and the function module C100_QUERY_USAGE_GET must be specified as the second function module.
For the search for formulas using value assignment types in the property tree for a substance, the following settings must also exist:
· Check whether the following value assignment types are set up in EH&S Customizing under Specify Value Assignment Types and whether the described function module is specified in the Screen function field:
Value Assignment Type |
Screen Function |
Substance Is Input of Formula |
RCP736_ENTRY_FROM_SUB_INP |
Substance Is Output of Formula |
RCP736_ENTRY_FROM_SUB_OUP |
· In EH&S Customizing under Set Up Property Trees, check whether the value assignment types are inserted in the property tree that you use for substances.
· In Customizing for Recipe Management under Set Up Workbench, check whether the following entries exist:
¡ The object type SUB_WHUS exists and is set as being able to be started. For this, the call type Global Class and the provider CL_RCP_SRC_WHERE_USED_FOLDER are specified.
¡ For the service group of the recipe workbench, the following entries exist under Assignments and are set as active:
§ The FAVORITES entry for the favorites folder
§ The entry SUB_WHUS for the where-used list folders under the favorites folder, that is for the folders under which the formulas found are displayed for a substance
Make sure that the sequence number of the entry SUB_WHUS is higher than that of the entry FAVORITES.
· In Customizing for Recipe Management under Specify Layouts, check whether the layout FRM_HIER2 exists for the service group for the recipe workbench and that its layout definition includes an entry with the parent object type SUB_WHUS and child object type FRM.
You require this setting only if you also want to use the Formula Hierarchy structure layout for formulas under the where-used list folder.
To determine from the hit list the formulas or recipes that contain one or more substances in the hit list, proceed as follows:
...
1. Load the substances.
2. Select the substances in the hit list.
3.
Choose
with the quick info text Where-Used List.
4.
Choose
or
with
the quick info text Enter Parameters next to the
required where-used list. In the standard system, the where-used lists Recipes of the Substances... and Formulas of the Substances... are available. Note that the
result of the where-used list can contain specifications of only one
specification category. This means you can enter parameters for only one of
the above-mentioned where-used lists. If necessary, delete any parameters you
entered previously by choosing
Search
Criteria.
5. Enter the required parameters and confirm your entries.
The hit list appears, containing the formulas or recipes the system determined.
When editing a substance, to determine the formulas that contain the substance, proceed as follows:
...
1. Load the substance and select it in the hit list by double-clicking it.
2. In the property tree for the substance, double-click the value assignment type for the where-used list. In the standard system, the value assignment types Substance Is Input of Formula and Substance Is Output of Formula are available.
The system
transfers the formulas it determined to the navigation area under
Favorites and places the formulas in folders with the titles
Substance <Substance Key> Is Output of
Formula and Substance <Substance Key> Is
Input of Formula. The system displays the data for the first formula
found in the application area.

Regardless of your workbench settings, when you exit the recipe workbench, the system removes from your favorites the formulas that were transferred there via the where-used list.
