Ansicht
Dokumentation
rsdb/prefer_union_all - set if UNION ALL shall be used for FOR ALL ENTRIES
ROGBILLS - Synchronize billing plans RFUMSV00 - Advance Return for Tax on Sales/PurchasesThis documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter : rsdb/prefer_union_all |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: set if UNION ALL shall be used for FOR ALL ENTRI |
------------------------------------------------------------------------
------------------------------------------------------------------------
| 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. |
| A linkage of entire statements is generated from conditions in the |
| WHERE clause, with a UNION or an OR linkage, depending on whether |
| this parameter is set to "1" or "0". Each of the linked part |
| statements/part conditions represents an entry of the input |
| table [itab]. |
| |
| Example: The Open SQL statement |
| |
| SELECT ... FOR ALL ENTRIES IN itab WHERE f = itab-f. |
| |
| is mapped to SQL that conforms to the standard, depending on the |
| parameter rsdb/prefer_union_all: |
| |
| rsdb/prefer_union_all = 0 (and rsdb/prefer_in_itab = 0) |
| ==> |
| SELECT ... WHERE f = itab[1]-f |
| OR f = itab[2]-f |
| ... |
| OR f = itab[N]-f |
| |
| rsdb/prefer_union_all = 1 |
| ==> |
| SELECT ... WHERE f = itab[1]-f |
| UNION ALL SELECT ... WHERE f = itab[2]-f |
| ... |
| UNION ALL SELECT ... WHERE f = itab[N]-f |
| |
| N is the number of rows in itab and itab[i]-f is the value of the |
| field f in the i-th table row. |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| 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: 0 |
| MaxDB: 1 |
| MS SQL Server: 1 |
| Oracle: 0 |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Other Parameters Affected or Dependent: |
| rsdb/prefer_in_itab_opt |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : set if UNION ALL shall be used for FOR ALL ENTRIES
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : B
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers : X
------------------------------------------------------------------------
ROGBILLS - Synchronize billing plans General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 8083 Date: 20240425 Time: 191448 sap01-206 ( 5 ms )
