Skip to Content
0
Former Member
Jul 08, 2009 at 07:21 AM

USING COUNT(*)

36 Views

Any ideas why the below select would always return a count of 0 in the count column. Data is being returned and appears to be group;ed correctly but the count equals 0.

BEGIN OF t_dups2,

zuonr TYPE DZUONR,

dmbtr TYPE dmbtr,

count TYPE i,

END OF t_dups2.

SELECT zuonr dmbtr COUNT( * )

INTO CORRESPONDING FIELDS OF TABLE git_dups2

FROM zfi_dups

WHERE BUKRS in s_bukrs

AND gjahr in s_gjahr

GROUP BY zuonr dmbtr.