TEVEN table Entries ( Infotype 2011 )

[former_member209696]

Hi Experts,

I am trying to pull data from TEVEN Table for a reporting purpose. But I doubt there are some discrepancy in the table entries.

In our scenario, the data from the Time Keeping System will update in custom table every day at 7:00 : 00 AM

And TEVEN table get updated from the custom table at 07:15:00 AM .

The entries which found in the TEVEN table is as shown below.

Cl.

Number

Pers.No.

Log.date

Time

Creatd on

CreateAt

TET

TID

DA

OT

User Name

Changed on

200

4301

210

3/3/2015

8:17:00 AM

3/3/2015

7:15:17 AM

P10

0003

=

BATCH_USR

3/4/2015

200

4303

210

3/3/2015

3:23:00 PM

3/3/2015

7:15:17 AM

P20

0004

=

BATCH_USR

3/4/2015

As per above entries :

Employee 210 SWIPED IN on 03/03/2015 at 8:17:00 AM ( Log. Date & Time )

But Created on & Created at is 03/03/2015 at 7:15:17 AM ( Entry created before employee swipe in. Please correct if I am wrong ). Is this data is correct? If it is correct how can I get the exact Date and Time when the entry is created in SAP.

My functional consultant stating that this is a STANDARD SAP behavior and We should consider Changed On and Created at to get the exact Date time of the data entry creation.

I strongly believe that we need to correct the upload program first to get correct created date and created time of the data entry. Please correct me if I am wrong in any of these points.

Also help me with detailed meaning of created on & created time fields of TEVEN table.

[Former Member]

Hi,

You please check Time of the data uploading system date and Biometric system time. I think those two are not same on your case.

Thanks

[former_member209696]

Hi Rabi,

As per my understanding there is no relationship between time of SAP system and Bio-metric System.

Because first Data is uploading into a Z table with the help of a custom program. In this Z table there is no created time.

TEVEN table is updating from this ZTable with the help of a custom program. So there is no direct relation between SAP standard Table ( TEVEN ) and Bio-metric system.

Thanks,

Muhammed Riyas V A

[Former Member]

Hi,

I didn't say those two systems are related directly. I just told you time of those two machines are not same.

Eg. Employee punch in 8:00 AM biometric record the time as 8:00 AM. Then it's upload in ZTABLE. But here upload time is only related to your system time. If system time is 7:30 then upload time shows 7:30 not 8:00 AM.

I think you got my point.

Thannks