how to read occurence of ldate in teven data dictionary table

[furqanbaig_mirza]

i want to get the occurrence of the date in TEVEN table.

actually i am working on a report that deals with the clock in and clock out events of an employee.

so i want to check that if more than 1 record of in or out exist of a particular date this means that someone manually put that , and that's the task i want to sort out.

kindly help me..

Regards

Furqan

[marcin_cholewczuk]

Hi,

I would divide it in 2 queries. One for clock in and one for clock out. First one would look like this

SELECT employee 
  FROM teven
  INTO TABLE lt_employee
  GROUP BY employee clock_in
  HAVING count(*) > 1.

Best regards

Marcin Choleczuk