ESSR SAP (Service Entry Sheet Header Data) Table details

Dictionary Type: Table
Description: Service Entry Sheet Header Data




ABAP Code to SELECT data from ESSR
Related tables to ESSR
Access table ESSR




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
MANDTClient MANDTCLNT3T000MANDT
LBLNIEntry Sheet Number LBLNICHAR10ALPHALBLNILBLESSR
LBLNEExternal Entry Sheet Number LBLNE1CHAR16XBLNR1
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
SBNAMAGPerson Responsible (Internally) SBNAMAGCHAR12SBNAM
SBNAMANPerson Responsible (Externally) SBNAMANCHAR12SBNAM
DLORTLocation Where Service Was Performed DLORTCHAR25TEXT25
LBLDTPrice Reference Date of Entry Sheet LBLDTDATS8DATUM
LZVONPeriod LZVONDATS8DATUM
LZBISEnd of period LZBISDATS8DATUM
LWERTValue of Services LWERTCURR11(2) WERT11
UWERTPortion from Unplanned Services NETWR_UNGCURR11(2) WERT11V
UNPLVPortion Unplanned Value Without Reference to Contract UNPLVCURR11(2) WERT11V
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
PACKNOPackage number PACKNONUMC10ESLHPACKNO
TXZ01Short Text of Service Entry Sheet TXZ01_ESSRCHAR40TEXT40
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
LOEKZDeletion indicator in entry sheet LOEKZ_ESSRCHAR1ELOEK
KZABNAcceptance indicator KZABNCHAR1CHAR01
FINALIndicator: Final Entry Sheet FINALCHAR1CHAR01
FRGGRRelease group FRGGRCHAR2T16FGFRGGR
FRGSXRelease Strategy FRGSXCHAR2T16FSFRGSX
FRGKLRelease indicator: Entry sheet FRGKLCHAR1CHAR01
FRGZURelease status FRGZUCHAR8FRGZU
FRGRLRelease Not Yet Completely Effected FRGRLCHAR1XFELD
F_LOCKBlock Release of Entry Sheet F_LOCKCHAR1XFELD
PWWEPoints score for quality of services MC_PWWEDEC3DEC3
PWFRPoints score for on-time delivery MC_PWFRDEC3DEC3
BLDATDocument Date in Document BLDAT_SRVDATS8DATUM
BUDATPosting Date in the Document BUDAT_SRVDATS8DATUM
XBLNRReference Document Number XBLNR_SRV1CHAR16XBLNR1
BKTXTDocument Header Text BKTXT_SRVCHAR25TEXT25
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
KZVBRConsumption Posting KZVBRCHAR1KZVBR
NETWRNet Value of Entry Sheet NETWR_ESSRCURR11(2) WERT11
BANFNPurchase Requisition Number BANFN_ESSRCHAR10ALPHABANFN
BNFPOItem number of purchase requisition BNFPO_ESSRNUMC5EBANBNFPO
WARPLMaintenance Plan WARPLCHAR12MPLAALPHAWARPLMPLMPLAL
WAPOSMaintenance item WAPOSCHAR16ALPHAPOSNUMPSMPOSL
ABNUMMaintenance Plan Call Number ABNUMINT410ABNUM
FKNUMShipment Cost Number FKNUMCHAR10VFKKALPHAFKNUMFKKSD_F4_SCD_ID
FKPOSShipment costs item FKPOSNUMC6VFKPFKPOS
USER1Technical Reference Field for External Entry Sheet Number ESSR_DCHAR20CHAR20
USER2User field: Service entry sheet USR_ESSRCHAR20CHAR20
NAVNWNon-deductible input tax NAVNW_SRVCURR11(2) WERT11V
SPEC_NONumber of a Set of Model Service Specifications SPEC_NOCHAR10Assigned to domainALPHASPEC10MSPSPEC
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
LEMINReturns Indicator SRVRETCHAR1XFELD

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!