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