SAP ABAP Data Element RKEBW_NO_GROUP_BY (CO-PA Connection to SAP BW: Select w/o GROUP BY with FULL)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-PA (Application Component) Profitability Analysis
     ⤷ KERS (Package) Interface between CO-PA and BW

Basic Data

Data Element	RKEBW_NO_GROUP_BY
Short Description	CO-PA Connection to SAP BW: Select w/o GROUP BY with FULL

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	FLAG
Data Type	CHAR	Character String
Length	1
Decimal Places	0
Output Length	1
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	NoGROUP_BY
Medium	15	No GROUP_BY
Long	20	No GROUP_BY
Heading	20	No GROUP_BY

Documentation

Definition

When this field is selected, the data for a full update request is selected without the "GROUP BY" qualifier.

Use

In the case of full updates in the standard system, database problems can occur.
Before the first data package is returned, the process in OLTP remains inactive for a long time.
To give the database greater influence over access optimization, the standard system selects from Profitability Analysis data with the "GROUP BY" qualifier during full updates. During the selection, the database can in some cases revert to the temporary tablespace. If the temporary tablespace is too small, the selection may terminate.

Use of the "GROUP BY" qualifier is generally more economical from the performance point of view, because this means less data needs to be transferred to the application server. Nevertheless, the effect described above can severely hamper the extraction.

If this field is selected, the data is accessed using "NESTED LOOP", and the temporary tablespace is not used.

Dependencies

Example

History

Last changed by/on	SAP	20130529
SAP Release Created in	605