I want reproduce following query:

SELECT

ABAN8 AS RPAN8;

ABALPH AS RPALPH;

right( trim( ABALKY ); 8 ) AS COLUMN0002;

RPMCU;

right( trim( RPMCU ); 3 ) AS COLUMN0006;

MCDL01;

sum ( CASE

WHEN RPDCT in ( 'RI'; 'RM'; 'U8' ) THEN RPAAP / 100

ELSE 0

END ) AS RPAAP;

sum ( CASE

WHEN RPDCT = 'IF' THEN RPAAP / 100

ELSE 0

END ) AS COLUMN0003;

sum( Case when RPDCT = 'YI' AND RPPYR = '33712631' Then RPAAP / 100 else 0 end ) AS COLUMN0000;

sum( Case when RPDCT = 'YI' AND RPPYR = '33712629' Then RPAAP / 100 else 0 end ) AS COLUMN0000_1;

sum( Case when RPDCT = 'YI' AND RPPYR = '33712628' Then RPAAP / 100 else 0 end ) AS COLUMN0001;

sum( Case when RPDCT = 'YI' AND RPPYR = '33712634' Then RPAAP / 100 else 0 end ) AS COLUMN0001_1;

sum( Case when RPDCT = 'RU' AND RPPYR = RPAN8 Then RPAAP / 100 else 0 end ) AS COLUMN0006_1;

sum( Case when RPDCT = 'AU' Then RPAAP / 100 else 0 end ) AS COLUMN0004;

sum( Case when RPDCT = 'CU' Then RPAAP / 100 else 0 end ) AS COLUMN0005

FROM

IASP01.PDDTA.F03B11 F03B11; 

IASP01.PDDTA.F0101 F0101; 

IASP01.PDDTA.F0006 F0006; 

IASP01.PDDTA.F0010 F0010

WHERE

F03B11.RPAN8 = F0101.ABAN8

AND F03B11.RPMCU = F0006.MCMCU

AND F03B11.RPCO = F0010.CCCO

AND ( ( ( ( RPKCO between '00121' and '00151'

OR RPKCO between '00900' and '00949'))

AND Year( date( CCDFYJ; CYYDDD ) ) = &COLUMN0007

AND CCARPN = &CCARPN1))

GROUP BY

ABAN8;

ABALPH;

right( trim( ABALKY ); 8 );

RPMCU;

right( trim( RPMCU ); 3 );

MCDL01

HAVING

sum ( CASE

WHEN RPDCT in ( 'RI'; 'RM'; 'U8' ) THEN RPAAP / 100

ELSE 0

END ) <> 0

OR sum ( CASE

WHEN RPDCT = 'IF' THEN RPAAP / 100

ELSE 0

END ) <> 0

OR sum( Case when RPDCT = 'YI' AND RPPYR = '33712631' Then RPAAP / 100 else 0 end ) <> 0

OR sum( Case when RPDCT = 'YI' AND RPPYR = '33712629' Then RPAAP / 100 else 0 end ) <> 0

OR sum( Case when RPDCT = 'YI' AND RPPYR = '33712628' Then RPAAP / 100 else 0 end ) <> 0

OR sum( Case when RPDCT = 'YI' AND RPPYR = '33712634' Then RPAAP / 100 else 0 end ) <> 0

OR sum( Case when RPDCT = 'AU' Then RPAAP / 100 else 0 end ) <> 0

OR sum( Case when RPDCT = 'CU' Then RPAAP / 100 else 0 end ) <> 0

OR sum( Case when RPDCT = 'RU' AND RPPYR = RPAN8 Then RPAAP / 100 else 0 end ) <> 0

instead to use a direct database request, i would use the normal procedure dragging and drop dimensions and measures.

I'm able to drag and drop fields in SELECT list. About the WHERE CLAUSE i can add a filter to the request.

About the GROUP BY clause i know that there's a field in Advanced tab where you can specify GROUP BY clause.

But about HAVING clause i don't know where specify it.

Thanks

Regards