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"> <div style="display:none"><a href="http://svetka.clan.su/news/2010-01-04-25">порно ролики бесплатно без регистрации света букина порно</a></div> </strong>