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 Muhammed,

Take an example of the SAP Server time being US (EST) and the employee time being updated is from China (GMT+8).

In your scenario, it looks like the time events are sent from the time terminals to SAP once daily.

Therefore you get this time deviation.

Log.Date/Log.Time are the Actual time employee clocked-in/out from China as per GMT+8.

Created Date /Created Time is the Actual time when the record was posted in SAP (US EST).

This is standard behaviour in SAP.

Hope this helps.

Regards

Kumarpal

[sivakumar_mobility]

Hi,

I have facing  exactly what you are facing issue now while I am doing clock In and Clock out application. It is because of time deviation between our Local computer  time and SAP application server time.

For that You have to do some calculation which I marked in block.

Note:

You can calculate according to your Deviation.I got 26 minutes deviation.

DATA: LS_P2011          TYPE P2011,

           BAPIRETURN1       TYPE BAPIRETURN1,

          BAPIPAKEY           TYPE BAPIPAKEY.

LS_P2011-PERNR = LV_PERNR.

LS_P2011-LDATE = SY-DATUM.

  LS_P2011-LTIME = SY-UZEIT + ( 26 * 60 ) .

LS_P2011-SATZA = 'P10'.

CALL FUNCTION 'HR_INFOTYPE_OPERATION'

       EXPORTING

         INFTY            = '2011'

         NUMBER           = LS_P2011-PERNR

*       SUBTYPE          =

*       OBJECTID         =

*       LOCKINDICATOR    =

*       VALIDITYEND      =

*       VALIDITYBEGIN    =

*       RECORDNUMBER     =

         RECORD           = LS_P2011

         OPERATION        = 'INS'

         TCLAS            = 'A'

         DIALOG_MODE      = '0'

         NOCOMMIT         = ''

*       VIEW_IDENTIFIER  =

*       SECONDARY_RECORD =

       IMPORTING

         RETURN           = BAPIRETURN1

         KEY              = BAPIPAKEY.

     .

with Regards,

Siva.

.

Message was edited by: sivakumar M

[former_member209696]

       gwa_timeevent-ldate = gwa_tks_sap-event_date.  " Log Date

       gwa_timeevent-ltime = gwa_tks_sap-event_time.  " Log Time

       IF  gwa_tks_sap-terminal_id EQ gc_09.                   

         gwa_timeevent-erdat = gwa_tks_sap-event_date.

       ELSE.

         gwa_timeevent-erdat = gwa_tks_sap-date_created.

       ENDIF.

       gwa_timeevent-ertim = sy-uzeit.

Is this piece of code is correct? GWA_TKS_SAP is workarea which holding Custom table value. If Terminal is 9 it is passing Log date as created date else it is passing created date which stored in Z table. terminal 9 entries are marked as P60 (information) entries. What it means?

Log date is passing ERDAT the time should also pass as Log time right?

[sivakumar_mobility]

Hi,

Please Change the code like given below and check.

     gwa_timeevent-ldate = gwa_tks_sap-event_date.  " Log Date

       gwa_timeevent-ltime = gwa_tks_sap-event_time.  " Log Time

       IF  gwa_tks_sap-terminal_id EQ gc_09.                  

         gwa_timeevent-erdat = gwa_tks_sap-event_date.

       ELSE.

         gwa_timeevent-erdat = gwa_tks_sap-date_created.

       ENDIF.

       gwa_timeevent-ertim = sy-uzeit  - ( 15 * 60 ) .

[former_member209696]

HI,

How you finalize 15 min deviation? You are mentioning something else I guess

[sivakumar_mobility]

Hi Riyas,

I am sure that Its because of deviation only. Because I also worked as a Abaper , Its working fine in production.

Ask your Abaper to help you .Its because of two different systems only as per Ravi also.

With Regards,

Siva.

[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