ERZU SAP (Event Assignment) Table details
Dictionary Type: Table
Description: Event Assignment
Description: Event Assignment
Table field list including key, data, relationships and ABAP select examples
ERZU is a standard SAP Table which is used to store Event Assignment data and is available within R/3 SAP systems depending on the version and release level.
The ERZU table consists of various fields, each holding specific information or linking keys about Event Assignment data available in SAP. These include PLOBJ (Planning object), STFNA (Field name in the generated DDIC structure), ERNMR (Event Number), RELDA (Date of assignment for events).. 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 ERZU 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 | |||
PLOBJ | Planning object | PLOBJ | CHAR | 18 | CHAR18 | ||||
STFNA | Field name in the generated DDIC structure | STFNA | CHAR | 30 | Assigned to domain | FDNAME | |||
ERNMR | Event Number | ERNMR | CHAR | 18 | ERKO | ERNMR | ERN | ||
RELDA | Date of assignment for events | RELDA | DATS | 8 | RELDA | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | P44V | VRSIO | MCV | ||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
RELST | Assignment status | RELST | CHAR | 1 | RELST | ||||
REVLU | Value of event assignment | REVLU | FLTP | 16(16) | REVLU | ||||
GSTRU | Generated DDIC table for LIS, conditions, messages | GSTRU | CHAR | 30 | Assigned to domain | AS4TAB | |||
RFERE | Reference event | RFERE | CHAR | 18 | ERKO | ERNMR | |||
DECIM | Number of decimal places for number display | DECAN | INT2 | 5 | DECAN | ||||
EXPON | Base ten exponent for floating-point display | EXPON | INT2 | 5 | EXP10 | ||||
CDAT | Created on | CDAT | DATS | 8 | SYDATS | ||||
CTIME | Time of creation | CTME | TIMS | 6 | CTME | ||||
AUTOR | Author | AUTOR | CHAR | 12 | CHAR12 | ||||
UDAT | Changed On | UDAT | DATS | 8 | SYDATS | ||||
UPNAM | Last Changed By | UPNAM | CHAR | 12 | USNAM | ||||
UTIME | Time of last change | UTME | TIMS | 6 | CTME |
Key field | Non-key field |
How do I retrieve data from SAP table ERZU using ABAP code
The following ABAP code Example will allow you to do a basic selection on ERZU to SELECT all data from the tableDATA: WA_ERZU TYPE ERZU.
SELECT SINGLE *
FROM ERZU
INTO CORRESPONDING FIELDS OF WA_ERZU
WHERE...
How to access SAP table ERZU
Within an ECC or HANA version of SAP you can also view further information about ERZU 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