Ansicht
Dokumentation
rsdb/prefer_in_itab_opt - set if IN (...) shall be used for FOR ALL ENTRIES (if possible).
Fill RESBD Structure from EBP Component Structure SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter : rsdb/prefer_in_itab_opt |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Set if IN (...) shall be used for FOR ALL ENTRIES |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
| This parameter is for internal use only and must never be |
| changed without the prior consent of SAP. |
| |
| An internal table [itab] with input data is always transferred in |
| case of an ABAP SELECT request with the addition FOR ALL ENTRIES. |
| If this parameter is set to "1", a statement for which only one |
| field in the WHERE clause is dependent on the transferred internal |
| table is mapped to a statement with an IN clause. This is only |
| possible, however, if the field reference and the WHERE condition |
| are sufficiently simple: essentially, the field reference must be 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. |
| |
| is mapped to the following SQL statement |
| |
| SELECT ... WHERE f IN (itab[1]-f, itab[2]-f, ..., itab[N]-f) |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Application area: Database |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit : 1 / 0 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: |
| The default value is database-dependent. For technical reasons, it |
| is unfortunately necessary to enter a common, artificial value (-1). |
| The original default values for each database system are listed
| below. Caution: Since these values can be changed by kernel patches, |
| it is important that you obtain the current default values from SAP |
| Note 48230. |
| |
| DB2/390: 1 |
| DB2 UDB: 1 |
| Informix: 1 |
| iSeries: 1 |
| MaxDB: 1 |
| MS SQL Server: 1 |
| Oracle: 1 |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Are other parameters affected or dependent : No |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : set if IN (...) shall be used for FOR ALL ENTRIES (if possible).
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : B
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers : X
------------------------------------------------------------------------
RFUMSV00 - Advance Return for Tax on Sales/Purchases BAL_S_LOG - Application Log: Log header data
This documentation is copyright by SAP AG.
Length: 7005 Date: 20240426 Time: 104258 sap01-206 ( 6 ms )
