Hierarchy

⤷

⤷

Basic Data
Data Element | /BCV/QRM_JOIN_MAX_EXEC_SSC |
Short Description | Maximum Number of Executions of Secondary Search Connector |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | INT4 | |
Data Type | INT4 | 4-byte integer, integer number with sign |
Length | 10 | |
Decimal Places | 0 | |
Output Length | 10 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | MaxExec |
Medium | 15 | Max. Exec. |
Long | 20 | Max. Exec. SConn. |
Heading | 10 | MaxExec |
Documentation
Definition
Use
In this field, you can specify the maximum number of times the system calls the secondary search connector of a query join. The number of calls needed depends on the following factors:
- the selection modes of the input fields of the secondary search connectors that are used in the join criteria
- the number of different values the primary search connector returns for these fields during the execution of a query
The systems calls the secondary search connector exactly one time if the following applies:
- the selection modes of the input fields are either Multiple Values or Select Option
- it is guaranteed that the primary search connector always returns exactly one value for each input field of the secondary search connector
In all other cases, the system has to call the secondary search connector multiple times to retrieve all necessary result data. This may result in extended runtimes.
If the system determines that the number of necessary calls exceeds the maximum number you specified, it aborts query execution with an error message. If you do not specify a maximum number, the system assumes a default value of 10.
Dependencies
By setting the Delayed Selection indicator you can activate a functionality that tries to reduce the number of calls of the secondary search connector.
Example
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 702 |