You use this function to search for specifications. Starting from the initial screen of the search for specifications, you have the following options:
You use the research functions to define search criteria for the specifications to be selected.
You start to search for specifications by executing a query.
The search result is displayed as a hit list, from which you can fine-tune the search result as well save the set of hits. You can also display the search history from the hit list.
All search criteria that you enter in the initial screen are linked with AND. This includes searching with
Identifiers (such as the trade name, the number, and the structure formulas)
To improve performance, the system only searches the specification long texts if you enter additional search criteria to reduce the number of specifications that are searched. If you do not enter additional search criteria or the search criteria that you have entered do not reduce the number of specifications that are searched, the system searches on the first 132 characters of the identifier.
Regulatory lists
Material and material short text
With multiple selection, you can enter multiple single values or upload a text file with material numbers in the search function.
From-Date and To-Date
The system determines specifications that fulfill the selection conditions on at least one day within the given time period. The days can be different for different selection conditions. In this case, the key date is the day for which you want the data.
Note
If you also want to display data that was valid on an earlier data, you need to enter the earlier date instead of the suggested date as the key date.
Status
The system determines the specifications whose data has a specific Status.
Use
The system determines the specifications whose header data, identifiers, or value assessments contain the entered ratings and validity areas. However, searching by Usage
affects the search result only if you determine the hits with header data, identifiers, or value assessments. That is, if you have entered an authorization group (for the header data), an identifier, or an assessment as an additional criterion.
Example
For specifications in the substance
specification category, you determine a hit with an assessment if you have entered Substance with Property
, Substance Contains Component
, or Substance with Phrases Assigned
as search criteria in the search functions.
When you search by Usage
, a stringent check takes places. The ratings and validity areas of the data records must be the same as those that you entered as the search criteria or include these. If a data record does not have a usage, the system interprets it as follows in the search:
If a specification does not have a usage in the header data or identifier, then it is valid everywhere without restrictions.
If an assessment does not have a usage, it is not valid anywhere.
The search for specifications in the specification categories Substance
and Agent
is connected to the SAP search engine, TREX. This means you can execute a full text search. You can search the short and long texts of all languages or in numerous attributes of the specification at the same time. You can find the full text search in the input help of the Specification
field on the screen for the specification search. For more information about the full text search, see the field helps for the fields in the full text search.
In Customizing for Basic Data and Tools
, you can adapt the views for the specification search according to your requirements under Adapt Initial Screens
. Under Specify Environment Parameters
, in the environment parameter QRY_CHECK_FUNC, you can specify a function module that checks the search criteria in the specification search. By doing so, you can ensure that zeros are always added to fill specification keys that are entered.
Using environment parameter SP_CONVEXIT_SPEC1_ACTIVATE, you can control the use of leading zeros in numeric specification keys. This means that you do not need to enter any leading zeros or placeholders for the numeric specification key when using the specification search. These are entered automatically by the system.
The standard delivery supplies search functions that you can check in Customizing for Basic Data and Tools
under Manage User Exits
. If you want to define your own search function, display the documentation for the corresponding reference function module. Write the new function module analogous to the reference module and its interface.
The following enhanced search functions are available in the standard delivery for the specification category Substance
.
Search function |
Result |
|
The system determines specifications that fulfill the search criteria in the header data. These include:
|
|
The system determines specifications that have specific value assessment types for specific characteristic values. You define the value assessment types in the You use the You can set up the search as exclusive or inclusive for non-phrase-enabled characteristics. To do so, call the input help for the characteristic. A dialog box, from which you can select the |
|
The system determines specifications that fulfill the search criteria: This includes information about reference size, specification key, component type, and concentration. You can also specify the value assessment type that the relevant component contains. You can decide whether the specified component exists
|
|
The system determines specifications that have a specific reference. |
|
The system determines specifications that have been assessed with a specific phrase. |
|
The system determines the specifications contained in inheritance relationships (see Inheritance) and which fulfill specific search criteria. Based on the search criteria, you can search for the following specifications:
|
|
The system determines specifications that had a specific document assigned to them from |
|
If you have installed the Open Content Connector (OCC), the system determines specifications for which updated data has been made available with a content provider. This data needs to be located in a *.TXT file, which contains the associated CAS number and last update date for each updated substance. The file must be stored as a *.TXT file in the company network. Prerequisite:These substances have at least one entry in the table EHS: OCC: Table for saving import information and the |
The following constraints are valid for the search specifications:
Search terms in language-dependent search fields are not converted with EH&S Native Language Support. You can enter only search terms in languages that can be represented with the active Code Page of the application server.
The search result always contains only specifications of the specification category with which you initially entered. That is, the specification category that you selected in the Specification Workbench and that is displayed on your initial screen.