ESSR SAP (Service Entry Sheet Header Data) Table details
Dictionary Type: Table
Description: Service Entry Sheet Header Data
Description: Service Entry Sheet Header Data
Table field list including key, data, relationships and ABAP select examples
ESSR is a standard SAP Table which is used to store Service Entry Sheet Header Data data and is available within R/3 SAP systems depending on the version and release level.
The ESSR table consists of various fields, each holding specific information or linking keys about Service Entry Sheet Header Data data available in SAP. These include LBLNI (Entry Sheet Number), LBLNE (External Entry Sheet Number), ERNAM (Name of Person who Created the Object), ERDAT (Date on Which Record Was Created).. 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 ESSR 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 | |||
LBLNI | Entry Sheet Number | LBLNI | CHAR | 10 | ALPHA | LBLNI | LBL | ESSR | |
LBLNE | External Entry Sheet Number | LBLNE1 | CHAR | 16 | XBLNR1 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
SBNAMAG | Person Responsible (Internally) | SBNAMAG | CHAR | 12 | SBNAM | ||||
SBNAMAN | Person Responsible (Externally) | SBNAMAN | CHAR | 12 | SBNAM | ||||
DLORT | Location Where Service Was Performed | DLORT | CHAR | 25 | TEXT25 | ||||
LBLDT | Price Reference Date of Entry Sheet | LBLDT | DATS | 8 | DATUM | ||||
LZVON | Period | LZVON | DATS | 8 | DATUM | ||||
LZBIS | End of period | LZBIS | DATS | 8 | DATUM | ||||
LWERT | Value of Services | LWERT | CURR | 11(2) | WERT11 | ||||
UWERT | Portion from Unplanned Services | NETWR_UNG | CURR | 11(2) | WERT11V | ||||
UNPLV | Portion Unplanned Value Without Reference to Contract | UNPLV | CURR | 11(2) | WERT11V | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | PACKNO | |||
TXZ01 | Short Text of Service Entry Sheet | TXZ01_ESSR | CHAR | 40 | TEXT40 | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
LOEKZ | Deletion indicator in entry sheet | LOEKZ_ESSR | CHAR | 1 | ELOEK | ||||
KZABN | Acceptance indicator | KZABN | CHAR | 1 | CHAR01 | ||||
FINAL | Indicator: Final Entry Sheet | FINAL | CHAR | 1 | CHAR01 | ||||
FRGGR | Release group | FRGGR | CHAR | 2 | T16FG | FRGGR | |||
FRGSX | Release Strategy | FRGSX | CHAR | 2 | T16FS | FRGSX | |||
FRGKL | Release indicator: Entry sheet | FRGKL | CHAR | 1 | CHAR01 | ||||
FRGZU | Release status | FRGZU | CHAR | 8 | FRGZU | ||||
FRGRL | Release Not Yet Completely Effected | FRGRL | CHAR | 1 | XFELD | ||||
F_LOCK | Block Release of Entry Sheet | F_LOCK | CHAR | 1 | XFELD | ||||
PWWE | Points score for quality of services | MC_PWWE | DEC | 3 | DEC3 | ||||
PWFR | Points score for on-time delivery | MC_PWFR | DEC | 3 | DEC3 | ||||
BLDAT | Document Date in Document | BLDAT_SRV | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT_SRV | DATS | 8 | DATUM | ||||
XBLNR | Reference Document Number | XBLNR_SRV1 | CHAR | 16 | XBLNR1 | ||||
BKTXT | Document Header Text | BKTXT_SRV | CHAR | 25 | TEXT25 | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
NETWR | Net Value of Entry Sheet | NETWR_ESSR | CURR | 11(2) | WERT11 | ||||
BANFN | Purchase Requisition Number | BANFN_ESSR | CHAR | 10 | ALPHA | BANFN | |||
BNFPO | Item number of purchase requisition | BNFPO_ESSR | NUMC | 5 | EBAN | BNFPO | |||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | ABNUM | ||||
FKNUM | Shipment Cost Number | FKNUM | CHAR | 10 | VFKK | ALPHA | FKNUM | FKK | SD_F4_SCD_ID |
FKPOS | Shipment costs item | FKPOS | NUMC | 6 | VFKP | FKPOS | |||
USER1 | Technical Reference Field for External Entry Sheet Number | ESSR_D | CHAR | 20 | CHAR20 | ||||
USER2 | User field: Service entry sheet | USR_ESSR | CHAR | 20 | CHAR20 | ||||
NAVNW | Non-deductible input tax | NAVNW_SRV | CURR | 11(2) | WERT11V | ||||
SPEC_NO | Number of a Set of Model Service Specifications | SPEC_NO | CHAR | 10 | Assigned to domain | ALPHA | SPEC10 | MSP | SPEC |
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
LEMIN | Returns Indicator | SRVRET | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table ESSR using ABAP code
The following ABAP code Example will allow you to do a basic selection on ESSR to SELECT all data from the tableDATA: WA_ESSR TYPE ESSR.
SELECT SINGLE *
FROM ESSR
INTO CORRESPONDING FIELDS OF WA_ESSR
WHERE...
How to access SAP table ESSR
Within an ECC or HANA version of SAP you can also view further information about ESSR 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