rsdb/prefer_in_itab_opt SAP Parameter attribute - set if IN (...) shall be used for FOR ALL ENTRIES (if possible).

rsdb/prefer_in_itab_opt is a SAP Parameter attribute which is used to control set if IN (...) shall be used for FOR ALL ENTRIES (if possible). information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

rsdb/prefer_in_itab_opt profile paramerter attributes

Parameter Name: rsdb/prefer_in_itab_opt
Description: set if IN (...) shall be used for FOR ALL ENTRIES (if possible).
Default Value: -1
Parameter Type ( See IF_PARAMETER_TYPES): Integer(INT)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-DBI
System-Wide parameter: Yes
Dynamic Parameter: Yes
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

This parameter is only intended for internal use and must not be changed without explicit instruction from SAP. An internal table [itab] with entry data is always returned to an ABAP SELECT query with the addition FOR ALL ENTRIES. If this parameter is set to "1" then a statement refers to a statement with an IN clause where only one field in the WHERE clause depends on the internal table that was copied. However this is only possible if the field reference and WHERE condition are sufficiently simple. In effect, the field reference must deal with a non-negated EQ condition.
Example If the parameter rsdb/prefer_in_itab_opt is set to "1", then the open SQL statement SELECT ... FOR ALL ENTRIES IN itab WHERE f = itab-f. maps the following SQL statement SELECT ... WHERE f IN (itab[1]-f, itab[2]-f, ..., itab[N]-f)

See SAP Parameter Documentation for full SAP documentation for this profile parameter.