infotype 2011 TEVEN table

[muhammad_sohail]

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

[muhammad_sohail]

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

[Former Member]

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

[muhammad_sohail]

Dear,

I have closed all my threads. Pls. check again.

Thanks.

Sohail

[Former Member]

Thanks Muhammed.

This definitely encourage us.

Regards,

Pankaj

[former_member226519]

select min( LTIME ) from TEVEN into MY_TIMEVAR where PERNR = MY_PERNR and LDATE = MY_DATE

[muhammad_sohail]

answered