EVHR SAP (HR Order Confirmations (Times/Time Events)) Table details
Dictionary Type: Table
Description: HR Order Confirmations (Times/Time Events)
Description: HR Order Confirmations (Times/Time Events)
Table field list including key, data, relationships and ABAP select examples
EVHR is a standard SAP Table which is used to store HR Order Confirmations (Times/Time Events) data and is available within R/3 SAP systems depending on the version and release level.
The EVHR table consists of various fields, each holding specific information or linking keys about HR Order Confirmations (Times/Time Events) data available in SAP. These include PDSNR (Sequential number for PDC messages), PERNR (Personnel Number), ZAUSW (Time Recording ID Number), LDATE (Logical Date).. 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: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP EVHR 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 | Assigned to domain | MANDT | |||
PDSNR | Sequential number for PDC messages | PDSNR_D | NUMC | 12 | Assigned to domain | PDSNR | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | ZAUSW | ||||
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 | Assigned to domain | ABWGR | |||
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 | Assigned to domain | PLANS | |||
PDC_USRUP | Customer-Specific Field | PDC_USRUP | CHAR | 20 | CHAR20 | ||||
USER2 | Customer-Specific Field | HR_USRFLD | CHAR | 40 | CHAR40 | ||||
INDEU | Insert/delete or update indicator | INDEU | CHAR | 1 | INDEU | ||||
RUECK | Completion confirmation number for the operation | PW_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
RMZHL | Confirmation counter | PW_RMZHL | NUMC | 8 | CIM_COUNT | RZL | |||
STOKZ | Indicator: 'Confirmation Cancelled' | PW_STOKZ | CHAR | 1 | FLAG | ||||
STZHL | Confirmation counter of cancelled confirmation | PW_STZHL | NUMC | 8 | CIM_COUNT | ||||
GRUNR | Group number | PW_GRUNR | NUMC | 8 | Assigned to domain | GRUNR | GRN | ||
GRUNA | Group name | PW_GRUNA | CHAR | 20 | CHAR20 | ||||
BUDAT | Posting date | PW_BUDAT | DATS | 8 | DATUM | ||||
LSTYP | Time ticket type | PW_LSTYP | CHAR | 2 | Assigned to domain | LSTYP | |||
PRFOR | Premium formula | PW_PRFOR | NUMC | 3 | Assigned to domain | PRFOR | |||
APPKZ | Source application (for confirmations) | PW_APPKZ | CHAR | 2 | PW_APPKZ | ||||
SRCSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
AUFTYP | Order category | PW_AUFTYP | NUMC | 2 | AUFTYP | ||||
AUFART | Order type | PW_AUFART | CHAR | 4 | Assigned to domain | AUFART | |||
AUFNR | Order Number | PW_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
FOLGE | Sequence number | PW_AUFFN | CHAR | 6 | ALPHA | PLNFOLGE | |||
VORNR | Operation number | PW_AUFAV | CHAR | 4 | NUMCV | VORNR | |||
UVORN | Suboperation Number | PW_AUFUV | CHAR | 4 | NUMCV | VORNR | |||
SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
KAPAR | Capacity category | KAPAR | CHAR | 3 | CHAR3 | ||||
LOARR | Wage type | PW_LGART | CHAR | 4 | Assigned to domain | LGART | |||
ARBPL | Work Center | PW_ARBPL | CHAR | 8 | ARBPL | AGR | |||
WERKS | Plant | PW_WERKS | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
BUKRS | Company code | PW_BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
KOSTL | Cost center | PW_KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
LOGRR | Pay Scale Group | PW_TRFGR | CHAR | 8 | CHAR8 | ||||
TRFST | Pay scale level | PW_TRFST | CHAR | 2 | CHAR2 | ||||
MEINH | Unit of Measure | PW_MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
LMNGA | Yield | PW_LMNGR | QUAN | 13(3) | PW_QUAN13 | ||||
XMNGA | Scrap | PW_XMNGR | QUAN | 13(3) | PW_QUAN13 | ||||
GRUND | Scrap reason | PW_GRUND | CHAR | 4 | CHAR4 | ||||
BMSCH | Base quantity | PW_BMSCH | QUAN | 13(3) | PW_QUAN13 | ||||
VGW01 | Standard value of processing time | PW_VGWRT01 | QUAN | 13(3) | PW_QUAN13 | ||||
VGE01 | Measurement unit for standard value | PW_VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOW01 | Target value of processing time | PW_SOWRT01 | QUAN | 13(3) | PW_QUAN13 | ||||
SOE01 | Measurement unit for target value | PW_SOWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
RUW01 | Confirmed value of processing time | PW_RUWRT01 | QUAN | 13(3) | PW_QUAN13 | ||||
RUE01 | Measurement unit of confirmed value | PW_RUWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BEG01 | Start of processing time | PW_BEGUZ01 | TIMS | 6 | UZEIT | ||||
END01 | End of processing time | PW_ENDUZ01 | TIMS | 6 | UZEIT | ||||
VGW02 | Standard value of setup time | PW_VGWRT02 | QUAN | 13(3) | PW_QUAN13 | ||||
VGE02 | Measurement unit for standard value | PW_VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOW02 | Target value of setup time | PW_SOWRT02 | QUAN | 13(3) | PW_QUAN13 | ||||
SOE02 | Measurement unit for target value | PW_SOWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
RUW02 | Confirmed value of setup time | PW_RUWRT02 | QUAN | 13(3) | PW_QUAN13 | ||||
RUE02 | Measurement unit of confirmed value | PW_RUWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BEG02 | Start of setup time | PW_BEGUZ02 | TIMS | 6 | UZEIT | ||||
END02 | End of setup time | PW_ENDUZ02 | TIMS | 6 | UZEIT | ||||
VGW03 | Standard value of machine time | PW_VGWRT03 | QUAN | 13(3) | PW_QUAN13 | ||||
VGE03 | Measurement unit for standard value | PW_VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOW03 | Target value of machine time | PW_SOWRT03 | QUAN | 13(3) | PW_QUAN13 | ||||
SOE03 | Measurement unit for target value | PW_SOWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
RUW03 | Confirmed value of machine time | PW_RUWRT03 | QUAN | 13(3) | PW_QUAN13 | ||||
RUE03 | Measurement unit of confirmed value | PW_RUWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BEG03 | Start machine time | PW_BEGUZ03 | TIMS | 6 | UZEIT | ||||
END03 | End of machine time | PW_ENDUZ03 | TIMS | 6 | UZEIT | ||||
VGW04 | Standard value of variable activity | PW_VGWRT04 | QUAN | 13(3) | PW_QUAN13 | ||||
VGE04 | Measurement unit for standard value | PW_VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOW04 | Target value of variable activity | PW_SOWRT04 | QUAN | 13(3) | PW_QUAN13 | ||||
SOE04 | Measurement unit for target value | PW_SOWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
RUW04 | Confirmed value of variable activity | PW_RUWRT04 | QUAN | 13(3) | PW_QUAN13 | ||||
RUE04 | Measurement unit of confirmed value | PW_RUWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BEG04 | Start of variable activity | PW_BEGUZ04 | TIMS | 6 | UZEIT | ||||
END04 | End of variable activity | PW_ENDUZ04 | TIMS | 6 | UZEIT | ||||
VGW05 | Standard value of teardown time | PW_VGWRT05 | QUAN | 13(3) | PW_QUAN13 | ||||
VGE05 | Measurement unit for standard value | PW_VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOW05 | Target value of teardown time | PW_SOWRT05 | QUAN | 13(3) | PW_QUAN13 | ||||
SOE05 | Measurement unit for target value | PW_SOWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
RUW05 | Confirmed value of teardown time | PW_RUWRT05 | QUAN | 13(3) | PW_QUAN13 | ||||
RUE05 | Measurement unit of confirmed value | PW_RUWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BEG05 | Start of teardown time | PW_BEGUZ05 | TIMS | 6 | UZEIT | ||||
END05 | End of teardown time | PW_ENDUZ05 | TIMS | 6 | UZEIT | ||||
VGW06 | Standard value of variable activity | PW_VGWRT06 | QUAN | 13(3) | PW_QUAN13 | ||||
VGE06 | Measurement unit for standard value | PW_VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOW06 | Target value of variable activity | PW_SOWRT06 | QUAN | 13(3) | PW_QUAN13 | ||||
SOE06 | Measurement unit for target value | PW_SOWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
RUW06 | Confirmed value of variable activity | PW_RUWRT06 | QUAN | 13(3) | PW_QUAN13 | ||||
RUE06 | Measurement unit of confirmed value | PW_RUWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BEG06 | Start of variable activity | PW_BEGUZ06 | TIMS | 6 | UZEIT | ||||
END06 | End of variable activity | PW_ENDUZ06 | TIMS | 6 | UZEIT |
Key field | Non-key field |
How do I retrieve data from SAP table EVHR using ABAP code
The following ABAP code Example will allow you to do a basic selection on EVHR to SELECT all data from the tableDATA: WA_EVHR TYPE EVHR.
SELECT SINGLE *
FROM EVHR
INTO CORRESPONDING FIELDS OF WA_EVHR
WHERE...
How to access SAP table EVHR
Within an ECC or HANA version of SAP you can also view further information about EVHR 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