SAP EQSE Serial Number Records Table data and field list

EQSE is a standard SAP Table which is used to store Serial Number Records data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The EQSE table consists of various fields, each holding specific information or linking keys about Serial Number Records data available in SAP. These include EQSNR (EQSE Number), MATNR (Material Number), SERNR (Serial Number), ERNAM (Name of Person who Created the Object)... 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. .

EQSE table Technical Details:

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 EQSE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the EQSE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
EQSNR	EQSE Number	EQSNR	CHAR	18			EQSNR
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1
SERNR	Serial Number	GERNR	CHAR	18		GERNR	GERNR	SER
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
AEDAT	Changed On	AEDAT	DATS	8			DATUM
EQUNR	Equipment Number	EQUNR	CHAR	18	EQUI	ALPHA	EQUNR	EQN	EQUI
STATUS	Status of Serial Number Managment	SERSTATUS	CHAR	1			SERSTATUS
WERK	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
LAGER	Storage Location	LGORT_D	CHAR	4	T001L		LGORT	LAG
CHARGE	Batch Number	CHARG_D	CHAR	10	MCHA		CHARG	CHA
KUNDE	Customer to Whom Serial Number was Delivered	KUNDSE	CHAR	10	KNA1	ALPHA	KUNNR
SDBELN	Delivery	VBELN_VL	CHAR	10	VBUK	ALPHA	VBELN	VL
WABELN	Number of Material Document	MBLNR	CHAR	10		ALPHA	BELNR	MBN
BLART	Document Type	BLART	CHAR	2	T003		BLART	BAR
HEQSNR	Main Serial Number	HEQSNR	CHAR	18	EQSE		EQSNR
HSNPOS	Item in Superior Serial Number	HSNPOS	CHAR	4			HSNPOS
HMATNR	Material of Superior Serial Number	HMATNR	CHAR	18	MARA	MATN1	MATNR
REVLV	Revision Level	REVLV	CHAR	2		NUMCV	REVLV	RVS
OBJNR	Object number	J_OBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR

Key field

Non-key field

< EQPNDEX - EQST - Equipment to BOM Link >

How do I retrieve data from SAP table EQSE using ABAP code

The following ABAP code Example will allow you to do a basic selection on EQSE to SELECT all data from the table
DATA: WA_EQSE TYPE EQSE.

SELECT SINGLE *
FROM EQSE
INTO CORRESPONDING FIELDS OF WA_EQSE
WHERE...

How to access SAP table EQSE

Within an ECC or HANA version of SAP you can also view further information about EQSE and the data within it using relevant transactions such as

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