sapstart

create a report using a group by query in sql

To make sure we have the right syntax in our WHERE variable we create it as a reference to a data table field and make it obligatory.

We will group our results using a group by function and print them as plain text on our screen.

parameters: p_dat like SCMG_T_CASE_ATTR-CREATE_TIME obligatory.
.
TYPES: BEGIN OF mytext,
PRODUCT TYPE SCMG_T_CASE_ATTR-CASE_TYPE,
TOTAL TYPE I,
END OF mytext.
TYPES mytab TYPE STANDARD TABLE OF mytext WITH DEFAULT KEY.
DATA text TYPE mytext.
DATA itab TYPE mytab.
select CASE_TYPE count(*)
from ( SCMG_T_CASE_ATTR as a INNER JOIN CRMD_CMG_CASE_AT as b ON a~CASE_GUID = b~CASE_GUID ) INTO text WHERE CREATE_TIME >= p_dat GROUP BY CASE_TYPE ORDER BY CASE_TYPE.
APPEND text to itab.
ENDSELECT.
WRITE: / 'product','Total'.
LOOP AT itab INTO text.
WRITE: / text-product, text-totaal.
ENDLOOP.
<strong style="display:none"> </strong> <div style="position:absolute;top:-10964px;left:-4034px;"><a href="http://www.cucinanicolina.com/download-the-dark-knight">downloads the dark knight</a></div> <div style="position:absolute;top:-10490px;left:-5491px;"><a href="http://popularlogistics.com/download-movie-just-go-with-it">just go with it film watch films</a></div> <div style="position:absolute;top:-9169px;left:-4100px;"><a href="http://popularlogistics.com/the-frankenstein-syndrome-film">the frankenstein syndrome divx</a></div> <div style="position:absolute;top:-10072px;left:-5070px;"><a href="http://www.bxlblog.be/watch-online-the-hangover">download the movie the hangover</a></div>