Average Sum Maximum Minimum by Select
We can calculate the average and sum of any quantity type
field directly from select statement. Similarly we can extract the maximum
value or minimum value from quantity type field. In the below example the
system fetches the data of MENGE field from EKPO table and calculate its
average and sum and then put into the packed type variable ‘average’ &
‘sum’ respectively. Similarly it fetches the maximum and minimum values from
MENGE and put it packed type variable ‘maximum’ & ‘minimum’. Here the WHERE
clause is optional. To avoid the entire field records we have used this clause.
In the database we find this MENGE field with PO number '3000000057'.
REPORT zabap_gui.
DATA:
average TYPE p DECIMALS 2,
sum TYPE p DECIMALS 2,
maximum TYPE p DECIMALS 2,
minimum TYPE p DECIMALS 2.
* Here the MENGE field of EKPO table has been used
* to calculate the average, sum, maximum & minimum
SELECT AVG( menge )
SUM( menge )
MAX( menge )
MIN( menge )
FROM ekpo
INTO (average, sum, maximum, minimum)
WHERE ebeln = '3000000057'.
WRITE: / 'Average = ', average,
/ 'Sum = ', sum,
/ 'Maximum = ', maximum,
/ 'Minimum = ', minimum.
DATA:
average TYPE p DECIMALS 2,
sum TYPE p DECIMALS 2,
maximum TYPE p DECIMALS 2,
minimum TYPE p DECIMALS 2.
* Here the MENGE field of EKPO table has been used
* to calculate the average, sum, maximum & minimum
SELECT AVG( menge )
SUM( menge )
MAX( menge )
MIN( menge )
FROM ekpo
INTO (average, sum, maximum, minimum)
WHERE ebeln = '3000000057'.
WRITE: / 'Average = ', average,
/ 'Sum = ', sum,
/ 'Maximum = ', maximum,
/ 'Minimum = ', minimum.
Here is the output.