SAP Table EQSE

Serial Number Records

EQSE (Serial Number Records) 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 EQSE to other SAP tables.

EQSE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EQSNR EQSE Number EQSNR CHAR 18 0
MATNR Material Number MATNR MARA CHAR 18 0
SERNR Serial Number GERNR CHAR 18 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
STATUS Status of Serial Number Managment SERSTATUS CHAR 1 0
1 Directly Assigned
2 Installed
3 In stock
4 At customer
9 Entered manually
WERK Plant WERKS_D T001W CHAR 4 0
LAGER Storage Location LGORT_D T001L CHAR 4 0
CHARGE Batch Number CHARG_D MCHA CHAR 10 0
KUNDE Customer to Whom Serial Number was Delivered KUNDSE KNA1 CHAR 10 0
SDBELN Delivery VBELN_VL VBUK CHAR 10 0
WABELN Number of Material Document MBLNR CHAR 10 0
BLART Document Type BLART T003 CHAR 2 0
HEQSNR Main Serial Number HEQSNR EQSE CHAR 18 0
HSNPOS Item in Superior Serial Number HSNPOS CHAR 4 0
HMATNR Material of Superior Serial Number HMATNR MARA CHAR 18 0
REVLV Revision Level REVLV CHAR 2 0
OBJNR Object number J_OBJNR CHAR 22 0

EQSE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EQSE BLART EQSE MANDT T003 Document Types MANDT
EQSE BLART EQSE BLART T003 Document Types BLART
EQSE CHARGE EQSE WERK MCHA Batches WERKS
EQSE CHARGE EQSE CHARGE MCHA Batches CHARG
EQSE CHARGE EQSE MANDT MCHA Batches MANDT
EQSE CHARGE EQSE MATNR MCHA Batches MATNR
EQSE EQUNR EQSE MANDT EQUI Equipment master data MANDT
EQSE EQUNR EQSE EQUNR EQUI Equipment master data EQUNR
EQSE HEQSNR EQSE MANDT EQSE Serial Number Records MANDT
EQSE HEQSNR EQSE HEQSNR EQSE Serial Number Records EQSNR
EQSE HMATNR EQSE HMATNR MARA General Material Data MATNR
EQSE HMATNR EQSE MANDT MARA General Material Data MANDT
EQSE KUNDE EQSE MANDT KNA1 General Data in Customer Master MANDT
EQSE KUNDE EQSE KUNDE KNA1 General Data in Customer Master KUNNR
EQSE LAGER EQSE MANDT T001L Storage Locations MANDT
EQSE LAGER EQSE WERK T001L Storage Locations WERKS
EQSE LAGER EQSE LAGER T001L Storage Locations LGORT
EQSE MANDT EQSE MANDT T000 Clients MANDT
EQSE MATNR EQSE MANDT MARA General Material Data MANDT
EQSE MATNR EQSE MATNR MARA General Material Data MATNR
EQSE SDBELN EQSE SDBELN VBUK Sales Document: Header Status and Administrative Data VBELN
EQSE SDBELN EQSE MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
EQSE WERK EQSE MANDT T001W Plants/Branches MANDT
EQSE WERK EQSE WERK T001W Plants/Branches WERKS