Ansicht
Dokumentation

/IBX/AGGREGATION - Define Aggregation

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

In this Customizing activity, you define the aggregation configurations.

The settings are subdivided into the following sections:

·,,General Settings

·,,Granularity Characteristics

·,,Key Figures

·,,Lexicographical Characteristics

·,,Identification Characteristics

.

Note: A configuration represents all the settings in their entirety. It leads to exactly one aggregation result based on a particular data source. For every other data source or variant of the rules (granularity, grouping, key figure calculation, and so on), you create a new configuration or copy an existing configuration and change the copy accordingly.

If you want to use the user-defined processing and calculation functions, you need to carry out the Customizing activity Define Processing/Calculation Function for Aggregation.

General Settings

Here you need to:

1. Assign the name for a configuration when you create a new set of rules

2. Specify the implementation name of the database access program

3. Enter the name of the structure (in the Data Dictionary) in which the data records to be aggregated are to be transferred from and to their data source.

In the general settings, you can also:

4. Activate or deactivate the (return) transfer to the database of data records that are not to be aggregated

5. Activate or deactivate logging

6. Specify a structure (name in the Data Dictionary) for the identifying characteristics. By specifying a structure, you may make it easier for the database program to interpret the assignment table transferred by the aggregation (which original data record came up in which aggregation record). If you enter a structure name here, you do not need to edit the Identification Characteristics section.

Granularity Characteristics

For conversion and grouping, you must perform the following for each granularity characteristic

·,,Either specify a function

·,,Or use the lower-level setting options

To define a characteristic as being of a purely differentiating nature, assign the function GRAN_DIFF to the characteristic. Example: The table of data to be aggregated contains the characteristic "Debit/Credit Indicator" and in the aggregation, debit and credit balances must not be offset against each other. In this case, the function GRAN_DIFF can be used to transfer the delivered characteristic value to the aggregation record unchanged.

Granularity characteristics--> Result values

If you configure the conversion and grouping of a granularity characteristic in the Customizing activity, you first create a group number for each result value. You can freely assign the group numbers; note that at runtime, the delivered characteristic value is compared against the conditions created for this (see below) in the sequence of the group numbers.

Granularity characteristics--> Result values --> Conditions

For each result value, you enter one or more conditions for the values delivered in the non-aggregated data record. You can freely assign the condition numbers. The sequence is not relevant here, because the entered conditions are applied simultaneously, not sequentially.

Note

To exclude a particular characteristic value from the aggregation, you create this value as a result value and exactly one condition line.

Key Figures

In the table, enter all key figures for which a value is to be calculated in the aggregation record, and assign the required calculation function.

Key figures --> Additional parameters

If you have assigned a calculation function with additional parameters to a key figure, you must define here how these parameters are supplied. Only import parameters are possible as additional parameters. You can ignore the following parameters:

·,,IM_SINGLE_VALUE

·,,IM_INITIAL_TRANSFER_FLG

·,,CH_AGGREGATED_VALUE

Lexicographical Characteristics

See Key Figures section

Identification Characteristics

You only perform this part of the Customizing activity if you have not already assigned a characteristic structure in the general settings.

Create an entry for every characteristic that is needed to create a unique identification of the original data records and the aggregated data records. You use the sequential number (column POS) to determine the position of the characteristic value in the generically created key (= identifier).

PERFORM Short Reference   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.

Length: 4986 Date: 20240427 Time: 071709     sap01-206 ( 102 ms )