SAP Function TREX_EXT_AGGREGATE - Calculates aggregation

Parameter Reference Type Length Default Optional Text
I_COMP_DESCR TREXT_COMP_DESCR h 111 Description of the aggregation result table
I_INDEX_ALIAS_OPERATION TREXT_INDEX_ALIAS_OPERATION h 129 X Index Alias Operation
I_INDEX_ID TREX_RFC-INDEX_ID C 64 Index Id
I_JOIN_CONDITIONS TREXT_STATIC_JOIN_CONDITION h 527 X Static join condition
I_KEEP_LUW TREX_RFC-FLAG C 1 '' Only for debugging: keep logical unit of work
I_KEY_FIGURES TREXT_KEY_FIGURE h 66 X Key figures
I_QUERY_ENTRIES TREXT_QUERY_ENTRIES h 200 Query Entries
I_QUERY_ID TREX_RFC-QUERY_ID C 30 X Query Id for tracing
I_REQUESTED_RESULTS TREX_RFC-REQUESTED_RESULTS b 1 6 X 6: Aggregate requested, 7: Federate Aggregation requested
I_REQ_ATTRIBUTES TREXT_ATTRIBUTES h 64 X Requested attributes
I_RESULT_FROM I I 4 1 X from
I_RESULT_TO I I 4 0 X to
I_RFC_DESTINATION TREX_RFC-RFC_DESTINATION C 32 X RFC Destination
I_SORT_ATTRIBUTES TREXT_SORT_ATTRIBUTES h 151 X Sort attributes
I_STAGING TREX_RFC-BOOLEAN N 1 0 X Staging, 0: false, 1: true
I_SWITCH_ON_TRACE NUMC2 N 2 X 1: python trace, 2: executor (plan), 3:1+ 2
I_TOP_MAX_EQUALS TREX_RFC-MAX_RESULTS I 4 0 X
I_TOP_TYPE TREX_RFC-TOP_TYPE N 1 0 X 0, 1 (top k), 2 (top sum), 3 (top percent)
I_TOP_VALUE TREX_RFC-TOP_VALUE C 40 '' X
I_TRACE_COMPONENTS CHAR128 C 128 X Trace components
I_USE_DFI TREX_RFC-BOOLEAN N 1 0 X DimFunction Index: 0 default, 1 on, 2 off

Parameter Reference Type Length Text
E_COMPONENT_RUNTIME TREXS_COMPONENT_RUNTIME u 16 Run time of the TREX components
E_DFI_USED TREX_RFC-BOOLEAN N 1
E_MORE_PACKAGES TREX_RFC-BOOLEAN N 1 1: more packages to be transferred
E_RETURN_CODE TREX_RFC-RETURN_CODE I 4 Return code
E_RETURN_TEXT TREX_RFC-RETURN_TEXT C 200 Return text
E_TRACE TREXT_LINES_WITH_LB h 130 trace

Parameter Reference Type Length Default Optional Text
C_AGGREGATION_RESULT STANDARD TABLE 0 X BW only: Aggregation result

Exception Text
CONVERSION_ERROR Error during conversion
ERROR Error, see error message

1930450HANA BW: temp. table created in ABAP for materialized query
1776186SAP HANA BW - Scale out: routing to right indexserver