topic using aggregate function count in Application Development and Automation Discussions

using aggregate function count

Former Member — Tue, 19 Feb 2008 17:00:22 GMT

hi experts,

I want to select 2 fields from a table and put into structure (gw_konzs.) and with respect to that i want to use aggregate function count(*) for knowing how many rows has been selected ? and i dont want to use select & endselect

please help regarding this ...........

for example:

select konts ltext from ztab into corresponding fields of gw_konzs.

select count(*) from kna1 into gw_konzs

where konzs = gw_konzs-konzs.

append gw_konzs to gt_konzs

endselect.

Re: using aggregate function count

Former Member — Tue, 19 Feb 2008 17:07:11 GMT

hi experts,

I want to select 2 fields from a table and put into structure and i want to select based on the where condition i dont want to use select & endselect

please help regarding this ...........

rewarded if useful

for example:

gw_detail & gw_konzs is structure

gt_detail & gt_konzsis internal table

select kunnr name1 from kna1 into corresponding fields of gw_detail where konzs = gw_konzs-konzs.

gw_detail-konzs = gw_konzs-konzs.

append gw_detail-konzs to gt_detail-konzs

endselect.

Re: using aggregate function count

Former Member — Wed, 20 Feb 2008 10:29:11 GMT

Your code doesn't link together, but you need something like

select konzs count(*)

into l_it_mytable

from kna1

group by konzs

Re: using aggregate function count

Former Member — Wed, 20 Feb 2008 11:09:51 GMT

it is not working fine............ and i dont want to use select.......endselect but when i check for syntax it is showing error for not using endselect.............what to do?

Re: using aggregate function count

Former Member — Wed, 20 Feb 2008 13:02:16 GMT

I want to select gruop key(konzs) field from ztable then i want to know how many customers are there with respect to gruop key(konzs) field and how many vendors are for that group key ..iam using aggregate function count(*) but i dont want to use inside select..endselect

sample output should be:

grp key customer vendor

abc 1 4