Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
FI-SL-IS (Application Component) Information System⤷
GRWT (Package) Report Painter / Report Writer
Basic Data
| Data Element | GEN_SQL |
| Short Description | Type of selection |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | GEN_SQL | |
| 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 | Selection |
| Medium | 15 | Selection |
| Long | 20 | Type of selection |
| Heading | 1 | S |
Documentation
Definition
Using this function, you can control the range of the volumen of data transferred between the database and the application program. At this time, three different types of selection are supported.
Selection without projection
All of the characteristics and key figures in the database table are transferred. The selected records are not summarized by the database.
Selection with projection
Only those characteristics and key figures in the database that are necessary for the report are transferred to the application program. The selected records are not summarized by the database. Generally, this option significantly reduces the volume of data transferred between the database and the application program.
Selection with projection and aggregation
Only those characteristics and key figures in the database that are necessary for the report are transferred to the application program. The selected records are also aggregated via the unnecessary characteristics. This option, as compared with using projection only, results in an additional reduction of the volume of data transferred. However, this option does increase the burden on the database server.
To ensure that the projection also outputs accurate results for reports which use virtual charactersitics (control table T804C) or virtual key figures (control table T804B), under certain circumstances you may have to make entries in control table T804H. You can gather further information on this subject from an OSS note.
History
| Last changed by/on | SAP | 20010607 |
| SAP Release Created in |
