SAP ABAP Data Element FTI_CONDENSE (Summarize Results (for Query))
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FIN-FSCM-TRM-TM-IS (Application Component) Information System
     FTI (Package) Application development R/3 Treasury information system
Basic Data
Data Element FTI_CONDENSE
Short Description Summarize Results (for Query)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type XFELD    
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 FTI_CONDENSE_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 SummResult 
Medium 20 Summarize Results 
Long 40 Summarize Results 
Heading 40 Summarize Results 
Documentation

For drilldowns: The data is summarized before the currency translation using all characteristics that do not appear in the drilldown reporting definition. This can improve performance, since only the summarized data has to be translated. Otherwise setting this flag has no other effect.

For queries: The data is summarized for display with SAP Query, using the same schema that is used for summarizing drilldown data for display. This means that the data is summarized using characteristics that do not occur in the query definition. Generally, setting this indicator means that considerably fewer records are displayed than if the indicator were not set. If you have set the indicator, the same number of records should be displayed as for a drilldown report defined in the same way.

  • Exception: Aggregating functions (such as Average Is Calculated, No Aggregation) cannot always be displayed correctly with SAP Query. To avoid displaying incorrect results the system does not summarize using the required characteristics if in doubt (if the indicator is set). The log will then indicate that you should include these characteristics in the query definition. In such a case, add to the SAP Query those characteristics for which the key figure does not aggregate trivially. This ensures that these characteristics are not used to summarize (incorrectly).
  • Refer to the Display Report Type transaction for an overview of key figures with complex aggregation behavior.

Example for a query with/without summarization:

Without summarization:

ValAr CoCd ID PosCrcy SAcct DueDate BookV PC A DBookV PC BookV PC E

001 0001 1         EUR 0815 00.00.0000 0.00     0,00     81,46

001 0001 1         EUR 0815 08/06/2002 0.00 32,328.13-     0,00

001 0001 1         EUR 0815 01.03.02 0.00 6,152.91-     0,00

001 0001 1         EUR 0815 01.03.02 0.00     0,00     0,00

001 0001 1         EUR 0815 01.03.02 0.00 38,562.50     0,00

001 0001 1         EUR 1     00.00.0000 0,00     0,00     10,75

001 0001 1         EUR 1     06.08.2002 0,00 4.267,32-         0,00

001 0001 1         EUR 1     01.03.2002 0,00 1.526,66         0,00

001 0001 1         EUR 1     20.02.2002 0,00 1.089,00         0,00

001 0001 1         EUR 1     20.02.2002 0,00 1.662,41         0,00

001 0001 1         EUR KM01 00/00/0000 0.00     0,00     49.526,71

001 0001 1         EUR KM01 08/06/2002 0.00     0,00     0,00

001 0001 1         EUR KM01 08/06/2002 0.00 49,526.71     0,00

001 0001 1         EUR STS_1 00/00/0000 0.00     0,00     32,58

001 0001 1         EUR STS_1 00/00/0000 10,000.00 0.00     0,00

001 0001 1         EUR STS_1 08/06/2002 0.00 12,931.26-     0,00

001 0001 1         EUR STS_1 01.03.02 0.00 4,626.25     0,00

001 0001 1         EUR STS_1 20.02.02 0.00 1,662.41-     0,00

Total                 10.000,00 39.651,50 49.651,50

With summarization:

ValAr CoCd ID PosCrcy SAcct DueDate BookV PC A DBookV PC BookV PC E

001 0001 1         EUR 0815 00/00/0000 0.00 8    1,46     81,46

001 0001 1         EUR 1     00.00.0000 0,00     10,75     10,75

001 0001 1         EUR KM01 00/00/0000 0.00 49,526.71     49.526,71

001 0001 1         EUR STS_1 00/00/0000 10,000.00 9,967.42-     32,58

Total                 10.000,00 39.651,50 49.651,50

History
Last changed by/on SAP  20030326 
SAP Release Created in 200