SAP Table ESSR
Service Entry Sheet Header Data
ESSR (Service Entry Sheet Header Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ESSR to other SAP tables.
ESSR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
LBLNI
Entry Sheet Number
|
LBLNI |
CHAR
|
10 | 0 | ||||||||||||||
|
LBLNE
External Entry Sheet Number
|
LBLNE1 |
CHAR
|
16 | 0 | ||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||||
|
SBNAMAG
Person Responsible (Internally)
|
SBNAMAG |
CHAR
|
12 | 0 | ||||||||||||||
|
SBNAMAN
Person Responsible (Externally)
|
SBNAMAN |
CHAR
|
12 | 0 | ||||||||||||||
|
DLORT
Location Where Service Was Performed
|
DLORT |
CHAR
|
25 | 0 | ||||||||||||||
|
LBLDT
Price Reference Date of Entry Sheet
|
LBLDT |
DATS
|
8 | 0 | ||||||||||||||
|
LZVON
Period
|
LZVON |
DATS
|
8 | 0 | ||||||||||||||
|
LZBIS
End of period
|
LZBIS |
DATS
|
8 | 0 | ||||||||||||||
|
LWERT
Value of Services
|
LWERT |
CURR
|
11 | 2 | ||||||||||||||
|
UWERT
Portion from Unplanned Services
|
NETWR_UNG |
CURR
|
11 | 2 | ||||||||||||||
|
UNPLV
Portion Unplanned Value Without Reference to Contract
|
UNPLV |
CURR
|
11 | 2 | ||||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||
|
PACKNO
Package number
|
PACKNO | ESLH |
NUMC
|
10 | 0 | |||||||||||||
|
TXZ01
Short Text of Service Entry Sheet
|
TXZ01_ESSR |
CHAR
|
40 | 0 | ||||||||||||||
|
EBELN
Purchasing Document Number
|
EBELN | EKKO |
CHAR
|
10 | 0 | |||||||||||||
|
EBELP
Item Number of Purchasing Document
|
EBELP | EKPO |
NUMC
|
5 | 0 | |||||||||||||
|
LOEKZ
Deletion indicator in entry sheet
|
LOEKZ_ESSR |
CHAR
|
1 | 0 | ||||||||||||||
|
KZABN
Acceptance indicator
|
KZABN |
CHAR
|
1 | 0 | ||||||||||||||
|
FINAL
Indicator: Final Entry Sheet
|
FINAL |
CHAR
|
1 | 0 | ||||||||||||||
|
FRGGR
Release group
|
FRGGR | T16FG |
CHAR
|
2 | 0 | |||||||||||||
|
FRGSX
Release Strategy
|
FRGSX | T16FS |
CHAR
|
2 | 0 | |||||||||||||
|
FRGKL
Release indicator: Entry sheet
|
FRGKL |
CHAR
|
1 | 0 | ||||||||||||||
|
FRGZU
Release status
|
FRGZU |
CHAR
|
8 | 0 | ||||||||||||||
|
FRGRL
Release Not Yet Completely Effected
|
FRGRL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
F_LOCK
Block Release of Entry Sheet
|
F_LOCK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PWWE
Points score for quality of services
|
MC_PWWE |
DEC
|
3 | 0 | ||||||||||||||
|
PWFR
Points score for on-time delivery
|
MC_PWFR |
DEC
|
3 | 0 | ||||||||||||||
|
BLDAT
Document Date in Document
|
BLDAT_SRV |
DATS
|
8 | 0 | ||||||||||||||
|
BUDAT
Posting Date in the Document
|
BUDAT_SRV |
DATS
|
8 | 0 | ||||||||||||||
|
XBLNR
Reference Document Number
|
XBLNR_SRV1 |
CHAR
|
16 | 0 | ||||||||||||||
|
BKTXT
Document Header Text
|
BKTXT_SRV |
CHAR
|
25 | 0 | ||||||||||||||
|
KNTTP
Account Assignment Category
|
KNTTP | T163K |
CHAR
|
1 | 0 | |||||||||||||
|
KZVBR
Consumption Posting
|
KZVBR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
NETWR
Net Value of Entry Sheet
|
NETWR_ESSR |
CURR
|
11 | 2 | ||||||||||||||
|
BANFN
Purchase Requisition Number
|
BANFN_ESSR |
CHAR
|
10 | 0 | ||||||||||||||
|
BNFPO
Item number of purchase requisition
|
BNFPO_ESSR | EBAN |
NUMC
|
5 | 0 | |||||||||||||
|
WARPL
Maintenance Plan
|
WARPL | MPLA |
CHAR
|
12 | 0 | |||||||||||||
|
WAPOS
Maintenance item
|
WAPOS |
CHAR
|
16 | 0 | ||||||||||||||
|
ABNUM
Maintenance Plan Call Number
|
ABNUM |
INT4
|
10 | 0 | ||||||||||||||
|
FKNUM
Shipment Cost Number
|
FKNUM | VFKK |
CHAR
|
10 | 0 | |||||||||||||
|
FKPOS
Shipment costs item
|
FKPOS | VFKP |
NUMC
|
6 | 0 | |||||||||||||
|
USER1
Technical Reference Field for External Entry Sheet Number
|
ESSR_D |
CHAR
|
20 | 0 | ||||||||||||||
|
USER2
User field: Service entry sheet
|
USR_ESSR |
CHAR
|
20 | 0 | ||||||||||||||
|
NAVNW
Non-deductible input tax
|
NAVNW_SRV |
CURR
|
11 | 2 | ||||||||||||||
|
SPEC_NO
Number of a Set of Model Service Specifications
|
SPEC_NO |
CHAR
|
10 | 0 | ||||||||||||||
|
CUOBJ
Configuration (internal object number)
|
CUOBJ |
NUMC
|
18 | 0 | ||||||||||||||
|
LEMIN
Returns Indicator
|
SRVRET |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
ESSR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ESSR | BNFPO | ESSR | MANDT |
EBAN
Purchase Requisition
|
MANDT |
| ESSR | BNFPO | ESSR | BANFN |
EBAN
Purchase Requisition
|
BANFN |
| ESSR | BNFPO | ESSR | BNFPO |
EBAN
Purchase Requisition
|
BNFPO |
| ESSR | EBELN | ESSR | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| ESSR | EBELN | ESSR | EBELN |
EKKO
Purchasing Document Header
|
EBELN |
| ESSR | EBELP | ESSR | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| ESSR | EBELP | ESSR | EBELP |
EKPO
Purchasing Document Item
|
EBELP |
| ESSR | EBELP | ESSR | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| ESSR | FKNUM | ESSR | MANDT |
VFKK
Shipment Costs: Header Data
|
MANDT |
| ESSR | FKNUM | ESSR | FKNUM |
VFKK
Shipment Costs: Header Data
|
FKNUM |
| ESSR | FKPOS | ESSR | MANDT |
VFKP
Shipment Costs: Item Data
|
MANDT |
| ESSR | FKPOS | ESSR | FKNUM |
VFKP
Shipment Costs: Item Data
|
FKNUM |
| ESSR | FKPOS | ESSR | FKPOS |
VFKP
Shipment Costs: Item Data
|
FKPOS |
| ESSR | FRGGR | ESSR | FRGGR |
T16FG
Release Groups
|
FRGGR |
| ESSR | FRGGR | ESSR | MANDT |
T16FG
Release Groups
|
MANDT |
| ESSR | FRGSX | ESSR | MANDT |
T16FS
Release Strategies
|
MANDT |
| ESSR | FRGSX | ESSR | FRGGR |
T16FS
Release Strategies
|
FRGGR |
| ESSR | FRGSX | ESSR | FRGSX |
T16FS
Release Strategies
|
FRGSX |
| ESSR | KNTTP | ESSR | MANDT |
T163K
Account Assignment Categories in Purchasing Document
|
MANDT |
| ESSR | KNTTP | ESSR | KNTTP |
T163K
Account Assignment Categories in Purchasing Document
|
KNTTP |
| ESSR | MANDT | ESSR | MANDT |
T000
Clients
|
MANDT |
| ESSR | PACKNO | ESSR | MANDT |
ESLH
Service Package Header Data
|
MANDT |
| ESSR | PACKNO | ESSR | PACKNO |
ESLH
Service Package Header Data
|
PACKNO |
| ESSR | WAERS | ESSR | MANDT |
TCURC
Currency Codes
|
MANDT |
| ESSR | WAERS | ESSR | WAERS |
TCURC
Currency Codes
|
WAERS |
| ESSR | WARPL | ESSR | WARPL |
MPLA
Maintenance plan
|
WARPL |
| ESSR | WARPL | ESSR | MANDT |
MPLA
Maintenance plan
|
MANDT |