TEVEN SAP (Time Events) Table details
Dictionary Type: Table
Description: Time Events
Description: Time Events
Table field list including key, data, relationships and ABAP select examples
TEVEN is a standard SAP Table which is used to store Time Events data and is available within R/3 SAP systems depending on the version and release level.
The TEVEN table consists of various fields, each holding specific information or linking keys about Time Events data available in SAP. These include PDSNR (Sequential number for PDC messages), PERNR (Personnel Number), LDATE (Logical Date), LTIME (Logical time).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TEVEN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PDSNR | Sequential number for PDC messages | PDSNR_D | NUMC | 12 | PDSNR | PDSNR | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
LDATE | Logical Date | LDATE | DATS | 8 | DATUM | ||||
LTIME | Logical time | LTIME | TIMS | 6 | UZEIT | ||||
ERDAT | Created on | PHDAT | DATS | 8 | DATUM | ||||
ERTIM | Created at | PHTIM | TIMS | 6 | UZEIT | ||||
SATZA | Time Event Type | RETYP | CHAR | 3 | RETYP | ||||
TERID | Terminal ID | TERID | CHAR | 4 | TERID | ||||
ABWGR | Attendance/Absence Reason | ABWGR | CHAR | 4 | T705A | ABWGR | |||
EXLGA | Employee Expenditures | EXLGA | CHAR | 4 | EXLGA | ||||
ZEINH | Time/Measurement Unit | PT_ZEINH | CHAR | 3 | T538A | RPMSH | |||
HRAZL | Number | HRAZL | DEC | 7(2) | PTM_DEC5_2S | ||||
HRBET | Amount for remuneration information | HRBET | CURR | 9(2) | WERTV5 | ||||
ORIGF | Origin Indicator of PDC Message | ORIGF | CHAR | 1 | ORIGF | ||||
DALLF | Day assignment | DALLF | CHAR | 1 | DALLF | DALLF | PT_DALLF_V3S | ||
PDC_OTYPE | Object Type | OTYPE | CHAR | 2 | Assigned to domain | OTYPE | POT | ||
PDC_PLANS | Position | PLANS | NUMC | 8 | Assigned to domain | PLANS | |||
OTYPE | Object Type | OTYPE | CHAR | 2 | Assigned to domain | OTYPE | POT | ||
PLANS | Position | PLANS | NUMC | 8 | T528B | PLANS | |||
PDC_USRUP | Customer-Specific Field | PDC_USRUP | CHAR | 20 | CHAR20 | ||||
USER2 | Customer-Specific Field | HR_USRFLD | CHAR | 40 | CHAR40 | ||||
UNAME | User Name | UNAME | CHAR | 12 | UNAME | ||||
AEDTM | Changed on | AEDTM | DATS | 8 | DATUM | ||||
STOKZ | Indicator: 'Confirmation Cancelled' | PW_STOKZ | CHAR | 1 | FLAG | ||||
REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | XFELD | ||||
ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | XFELD | ||||
RUECK | Completion confirmation number for the operation | PW_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
SPLIT | Dummy for B20 int1 (Local Everywhere) | INT1 | INT1 | 3 | INT1 | ||||
KAPAR | 3-Byte field | CHAR3 | CHAR | 3 | CHAR3 | ||||
ABWEX | Fields for alternative payment are filled | ABWEX | CHAR | 1 | XFELD | ||||
TRFGR | Pay Scale Group | TRFGR | CHAR | 8 | Assigned to domain | TRFGR | |||
TRFST | Pay Scale Level | TRFST | CHAR | 2 | Assigned to domain | TRFST | |||
PRAKN | Premium Number | PRAKN | CHAR | 2 | T510P | PRAKN | |||
PRAKZ | Premium Indicator | PRAKZ | NUMC | 4 | PRAKZ | ||||
AUFKZ | Extra Pay Indicator | AUFKN | CHAR | 1 | AUFKN | ||||
BWGRL | Valuation Basis for Different Payment | PTM_VBAS7S | CURR | 13(2) | P_AMT07V | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | ZAUSW |
Key field | Non-key field |
How do I retrieve data from SAP table TEVEN using ABAP code
The following ABAP code Example will allow you to do a basic selection on TEVEN to SELECT all data from the tableDATA: WA_TEVEN TYPE TEVEN.
SELECT SINGLE *
FROM TEVEN
INTO CORRESPONDING FIELDS OF WA_TEVEN
WHERE...
How to access SAP table TEVEN
Within an ECC or HANA version of SAP you can also view further information about TEVEN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects