SAP table EQSE (Serial Number Records)

SAP table EQSE has 2 primary key fields being MANDT,EQSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

EQSE foreign key relationships

Table Field Check Table Check Field
0 EQSE BLART T003 Document Types MANDT
1 EQSE CHARGE MCHA Batches MANDT
1 EQSE CHARGE MCHA Batches WERKS
1 EQSE CHARGE MCHA Batches CHARG
0 EQSE EQUNR EQUI Equipment master data MANDT
1 EQSE HMATNR MARA General Material Data MANDT
1 EQSE HMATNR MARA General Material Data MATNR
0 EQSE KUNDE KNA1 General Data in Customer Master MANDT
0 EQSE KUNDE KNA1 General Data in Customer Master KUNNR
1 EQSE LAGER T001L Storage Locations MANDT
1 EQSE LAGER T001L Storage Locations WERKS
0 EQSE MANDT T000 Clients MANDT
1 EQSE MATNR MARA General Material Data MANDT
1 EQSE MATNR MARA General Material Data MATNR
0 EQSE WERK T001W Plants/Branches WERKS