create a report using a group by query in sql
ABAP May 9th, 2008
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>
About
Leave a Comment