select with count

SELECT COUNT( * ) FROM pa0001
INTO wa_teken_itab-ex_immobile
WHERE persg = '6'
AND persg = '7'
AND persg = '8'
AND orgeh = 'Z'
AND orgeh NE '00009999'
AND stell = 'A'.

HI,

SELECT COUNT( DISTINCT EMPID )

FROM pa0001

INTO IT_EMPID_COUNT

WHERE persg = '6'

AND persg = '7'

AND persg = '8'

AND orgeh = 'Z'

AND orgeh NE '00009999'

AND stell = 'A'.

now the field IT_EMPID_COUNT will have the No of records

Regards

Sudheer

try this code

data : count type i.

select count( * ) into count FROM pa0001

INTO wa_teken_itab-ex_immobile

WHERE persg = '6'

AND persg = '7'

AND persg = '8'

AND orgeh = 'Z'

AND orgeh NE '00009999'

AND stell = 'A'.

Dont forget to reward points.

Regards,

barath.

You can't use COUNT, because there will be more than one record per employee. These records are date sensitive, so everytime there is a change, a new record is created with begin/end dates. So you will need to get all of these records within your condition, then sort by PERNR and delete the adjacent records.

report zrich_0001.

data: no_employees type i.
data: ipa0001 type table of pa0001.

select * from pa0001
             into table ipa0001
                 where persg = '6'
                 and persg = '7'
                 and persg = '8'
                 and orgeh = 'Z'
                 and orgeh ne '00009999'
                 and stell = 'A'.

sort ipa0001 by pernr ascending.
delete adjacent duplicates from ipa0001 comparing pernr.


describe table ipa0001 lines no_employees.

write:/ no_employees.

Regards,

Rich Heilman

Maybe I'm crazy, but is there ever going to be a record where persg = '6' AND '7' AND '8'?

select * from pa0001

into table itab

where persg = '6'

and persg = '7'

and persg = '8'

and orgeh = 'Z'

and orgeh ne '00009999'

and stell = 'A'.

sort itab by pernr ascending.

delete adjacent duplicates from itab comparing pernr.

describe table itab lines count.

write:/ count.

AWARD POINTS