1. Home
  2. Resources
  3. SAP Tables
  4. ESSR - Service Entry Sheet Header Data

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
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
X Yes
NULL No
F_LOCK Block Release of Entry Sheet F_LOCK CHAR 1 0
X Yes
NULL No
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
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
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
X Yes
NULL No

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