Hierarchy
⤷ CA-EPT-BCV (Application Component) Business Context Viewer
⤷ /BCV/QRM (Package) BCV Query Management Layer
Basic Data
Data Element | /BCV/QRM_GROUP_IND |
Short Description | Field in Group |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | BOOLE | |
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 | In Group |
Medium | 15 | Fld. in Group |
Long | 20 | Field in Group |
Heading | 1 | G |
Documentation
Definition
Use
By selecting this checkbox, you specify that the system uses the query result field to group the result data.
Grouping is the process of concentrating all records of the result data that belong to the same group into one record (that replaces the original records). Groups are defined by one or more result fields, that is, all records with the same values of these fields belong to the same group. Potential grouping fields are those used to classify objects of the underlying data provider, such as material, customer, vendor or delivery date.
You can use grouping if the result data of the search connector is too detailed for the intended purpose.
Dependencies
For result fields that are not part of the group definition but might have different values within the same group, you must specify how the system determines their value in the grouped record. You can do so by choosing Aggregation in the Filled By (Value Source of Query Result Field) field and by specifying an appropriate aggregation function in the Aggr.Func. (Aggregation Function) field. Otherwise, the system chooses one of the values in the group randomly.
Example
Assume that a query contains the result fields MATERIAL, DATE, and QUANTITY (representing sales orders). For QUANTITY, you have selected the Sum of Values aggregation function. The result data retrieved from the search connector looks as follows:
MATERIAL DATE QUANTITY
PROD01 01.06.2008 100
PROD01 01.06.2008 50
PROD01 03.06.2008 70
PROD02 01.06.2008 200
PROD03 01.06.2008 60
If you are interested in overall quantities per material (regardless of the date), you can specify a group definition that only contains MATERIAL. In this case, the grouped result data looks as follows:
MATERIAL (DATE) QUANTITY
PROD01 (03.06.2008) 220
PROD02 (01.06.2008) 200
PROD03 (01.06.2008) 60
Since DATE is not part of the group and no aggregation function is specified, it contains the date of any of the original records. You can exclude DATE from the list of result fields to hide it.
If you are interested in overall quantities per day (regardless of the material), you can specify a group definition that only contains DATE. In this case, the grouped result data looks as follows:
(MATERIAL) DATE QUANTITY
(PROD03) 01.06.2008 410
(PROD01) 03.06.2008 70
Since MATERIAL is not part of the group and no aggregation function is specified, it contains the material of any of the original records. You can exclude MATERIAL from the list of result fields to hide it.
If you are interested in quantities per material and day, you can specify a group definition that contains both MATERIAL and DATE. In this case, the grouped result data looks as follows:
MATERIAL DATE QUANTITY
PROD01 01.06.2008 150
PROD01 03.06.2008 70
PROD02 01.06.2008 200
PROD03 01.06.2008 60
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 701 |