topic Re: USING COUNT(*) in Application Development and Automation Discussions

USING COUNT(*)

Former Member — Wed, 08 Jul 2009 07:21:07 GMT

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.

Re: USING COUNT(*)

ThomasZloch — Wed, 08 Jul 2009 07:22:30 GMT

Try dropping "CORRESPONDING FIELDS OF", as this requires identical field names which is not the case here.

Thomas

Re: USING COUNT(*)

Former Member — Wed, 08 Jul 2009 07:27:11 GMT

you are not using occurs o clause in your begin statement of internal table declaration.

Regds,

Anil

Re: USING COUNT(*)

huseyindereli — Wed, 08 Jul 2009 07:31:18 GMT

try using this.

SELECT zuonr dmbtr COUNT( * ) AS 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.

Re: USING COUNT(*)

Former Member — Wed, 08 Jul 2009 07:33:22 GMT

Hi,

Please go for F1 help on the select statement and you will get to know how to fetch the count along with the fieds... You have some sample programs there to help you..

Re: USING COUNT(*)

Former Member — Wed, 08 Jul 2009 07:34:15 GMT

hi,

try this:

SELECT zuonr dmbtr COUNT( * )

INTO TABLE git_dups2

FROM zfi_dups

WHERE BUKRS in s_bukrs

AND gjahr in s_gjahr

GROUP BY zuonr dmbtr.

regards, darek