Sunday, August 2, 2015

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.

Here is the output.




3 comments:

Phani said...

Hiii sir... Ur blog is excellent its very easy to understanding the concepts ... u described in a very easy manner I want to be a touch... can u share ur email or SAP SCN OR FB ID... I hav some doubts in abap plz help me out

Thanks,
Phani N

kavi kalyan said...

Best SAP Success Factor Training in Chennai

http://thecreatingexperts.com/sap-training-in-chennai/
http://thecreatingexperts.com/sap-successfactors-training-in-chennai/
http://thecreatingexperts.com/sap-mm-training-in-chennai/
http://thecreatingexperts.com/sap-fico-training-in-chennai/

Anonymous said...

Informative Blog...For a long time I was craving for a career growth in programming and then I came to know that THE CREATING EXPERTS is the one who provide training with hands on training and real time scenarios

http://thecreatingexperts.com/sap-abap-training-in-chennai/

contact 8122241286