05-28-2009 10:02 AM
Dear All,
TEVEN is a time event table of infotype 2011. satza is a field which has P10 value as clock-in time of an employee. I want to select first P10(Clock-In time) of an employee on a distinct date. How can i do that.
there is a field of pdsnr which is a unique number, but in which table i have to join it to get a first P10 record of an employee on a particular date.
Thanks.
Sohail
05-28-2009 10:39 AM
select min( LTIME ) from TEVEN into MY_TIMEVAR where PERNR = MY_PERNR and LDATE = MY_DATE
05-28-2009 10:07 AM
Dear Muhammed,
First please close all the threads which were answered,also please give points to the answers which helped you.Its a motivation factor for us.
I have seen all the threads posted by you. None of them have been closed or given points.
We are here to help you.
Regards,
Pankaj
05-28-2009 10:13 AM
Dear,
I have closed all my threads. Pls. check again.
Thanks.
Sohail
05-28-2009 10:16 AM
05-28-2009 10:39 AM
select min( LTIME ) from TEVEN into MY_TIMEVAR where PERNR = MY_PERNR and LDATE = MY_DATE
06-02-2009 5:22 AM