ESSR table — Service Entry Sheet Header Table
ESSR stores the header of a service entry sheet: the entry sheet number, the purchase order and item it was created against, the package number that points to the actual service lines in ESLL, and the creation and release status of the sheet. It does not hold service quantities, values, or account assignment; those live in ESLL and the linked account assignment table.
Explains what a service entry sheet header record in ESSR actually represents on a service procurement PO, how it links to the line-item detail in ESLL and back to the purchase order, and the recurring mistakes consultants make when they read ESSR as if it contained amounts or a single release truth. Covers the join path a consultant writes in a real investigation and how to prove a service acceptance or invoice block issue from the data.
Published 15 Sept 2026· 1,044 words
What it stores
One row in ESSR represents the header of a single service entry sheet, the document used to record that services under a service line of a purchase order have actually been performed, prior to acceptance and invoice verification. It carries the entry sheet number as its business key, the purchase order and item it was raised against, and a package number that links the header to the actual list of service lines stored separately. A single service PO item can generate several entry sheets over time as work is delivered in stages, so ESSR is one row per submission, not one row per PO item. The header also carries creation and status information used to drive the release/acceptance workflow, but no monetary values, quantities, or account assignment splits, all of which sit in child tables reached through the package number.
Key fields
- MANDT - client
- LBLNI - service entry sheet number, the primary business key of the header
- EBELN - purchase order number the entry sheet was created against
- EBELP - item number of that purchase order (the service line item)
- PACKNO - package number, the link from the header to the actual service lines and their values held in the line-item table
- ERNAM - user who created the entry sheet
- ERDAT - date the entry sheet was created
- LOEKZ - deletion indicator on the header
How it joins the data model
- ESSR-EBELN = EKKO-EBELN
- ESSR-EBELN and ESSR-EBELP = EKPO-EBELN and EKPO-EBELP
- ESSR-PACKNO = ESLL-PACKNO to reach the actual service descriptions, quantities and values entered on the sheet
- ESSR-LBLNI referenced from EKBE where the history record type identifies a service entry sheet acceptance posting
- ESLL-PACKNO also used to reach account assignment detail for each service line, kept in a separate table outside this join chain
How to read it safely
Always restrict on MANDT plus at least one of LBLNI or EBELN before running against ESSR in a productive system with heavy service procurement volume; a PO-restricted read is the normal entry point since users almost always come in asking about a specific purchase order, not a specific entry sheet number they already know. LBLNI is the fastest lookup once known, since it is the table's key field. Do not attempt to read ESSR by date range alone across company codes without a PO or vendor filter; entry sheets accumulate continuously and a broad ERDAT scan on a live system is a common cause of an unnecessary full or near-full table scan.
How to prove it in the data
Symptom: an invoice is blocked because the service performed has not been accepted. Select ESSR by EBELN and EBELP for the PO item in question, note the LBLNI values returned, then check each entry sheet's status through the standard service entry sheet transaction or the linked release workflow record. If a sheet exists but shows no acceptance, the invoice block is legitimate. Then join to ESLL on PACKNO to see the actual service lines and confirm the value expected does in fact match what was entered before escalating as a data problem.
ECC vs S/4HANA
ESSR is retained in S/4HANA in the same structural role as in ECC; there is no compatibility CDS view replacing it as the primary persistence for service entry sheet headers. The Fiori app used to manage service entry sheets reads and writes through this table and its line-item counterpart underneath an OData layer, but the underlying table names and key structure are unchanged, so joins written against ECC continue to work.
Common pitfalls
- Reading ESSR and expecting to find amounts or quantities there; they are not on the header, they are on the service lines reached through PACKNO
- Treating EBELN/EBELP as a unique key into ESSR; a service PO item can have multiple entry sheets over its life, so a query without LBLNI can return several rows that need to be reconciled, not one
- Assuming a LOEKZ set on the header means the entry sheet has no effect on the PO history or accounting; a deletion flag marks the header, it does not retroactively remove postings already made against it
- Confusing package numbers between service master templates and actual service entry sheets; ESLL is shared structurally by both, so a PACKNO join without going through ESSR first can pull line data from the wrong context
- Assuming acceptance and release are the same event; a sheet can be technically released for further processing without yet being business-accepted by the requester, and the two statuses are tracked through different means, not both visible directly as amounts on ESSR
- Using ESSR alone to explain a GR/IR discrepancy; the actual posting evidence sits in the PO history table, and ESSR only tells you an entry sheet exists, not that it produced a value-affecting document
Whose problem this is
Ownership of a data question on ESSR sits with the MM service procurement consultant responsible for the entry sheet configuration and release strategy, working with whoever owns the invoice verification process when the issue is a blocked invoice. Master data or authorization questions about who can create or release a sheet belong to the same functional owner, not to a Basis or FI team.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/essrERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.