SAPSQL_HAVING_AVG_TYPE is an ABAP runtime error which you may come across when using or developing within an SAP system. See below for the standard details explaining what it means and how you can avoid or fix this runtime error.
Short Dump Classification: A - ABAP Programming Error
You can view further information about a runtme error by using transaction code ST22 which will show you this and all runtime erros that have happen in your SAP system.
Also check out the Comments section below to view or add related contributions and example screen shots.
Please see search hints for more details about the possible cause of this runtime error and how it could be avoided.
Please see send to sap for more details about the possible cause of this runtime error and how it could be avoided.
The HAVING clause has an unexpected format.
Please see abap error for more details about the possible cause of this runtime error and how it could be avoided.
The running program attempted to execute an Open SQL statement that
contains a HAVING clause in which the types of the database fields
could only be determined as early as to runtim of the program. The
HAVING clause contains the aggregate function AVG( <runtime parameter>). The parameter
of the aggregate function "AVG" must have a numeric type (I, P, F, b
(INT1) or s (INT2)). In this particular case, the field <runtime parameter> has the
non-numeric type <runtime parameter>.
Please see abap error for more details about the possible cause of this runtime error and how it could be avoided.
SAPSQL_HAVING_AVG_TYPE - sapsql having avg type SAPSQL_GROUP_BY_LOB - sapsql group by lob SAPSQL_GROUP_BY_ILL_TABLE_TYPE - sapsql group by ill table type SAPSQL_FIELDNAME_UNKNOWN - sapsql fieldname unknown SAPSQL_FIELDNAME_TOO_LONG - sapsql fieldname too long SAPSQL_FIELDLIST_SUM_TYPE - sapsql fieldlist sum type