Skip to Content
0
Apr 15, 2014 at 08:29 AM

How to get no. of active employees in a employee subgroup on a particular date

89 Views

Dear Experts.

Sorry for the basic questions.

I want to get the no. of active employees in a employee subgroup on a particular date. I am not using logical database.

I am facing problem with the date .

my select query as below .

SELECT PERNR PERSK

FROM PA0001

INTO TABLE LT_DATA

WHERE PERSG = '1'

AND ( PERSK = 'M1' OR

PERSK = 'M2' OR

PERSK = 'M3' OR

PERSK = 'M4' OR

PERSK = 'M5' OR

PERSK = 'M6' OR

PERSK = 'M7' OR

PERSK = 'P1' )

AND BEGDA = LV_DATE . with this select query i am get only those entries which are created on LV_DATE.

Please suggest the select query so the i can get no. of active employees working in employee sub group on LV_DATE.

I hope its clear.

Thanks & Regards,

Bhushan