Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

infotype 2011 TEVEN table

muhammad_sohail
Participant
0 Kudos

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

1 ACCEPTED SOLUTION

former_member226519
Active Contributor
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

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

0 Kudos

Dear,

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

Thanks.

Sohail

0 Kudos

Thanks Muhammed.

This definitely encourage us.

Regards,

Pankaj

former_member226519
Active Contributor
0 Kudos

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

muhammad_sohail
Participant
0 Kudos

answered