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 | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | MATNR |
MCHA
Batches
|
MATNR |
| EQSE | CHARGE | EQSE | WERK |
MCHA
Batches
|
WERKS |
| EQSE | CHARGE | EQSE | CHARGE |
MCHA
Batches
|
CHARG |
| EQSE | CHARGE | EQSE | MANDT |
MCHA
Batches
|
MANDT |
| 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 | MANDT |
MARA
General Material Data
|
MANDT |
| EQSE | HMATNR | EQSE | HMATNR |
MARA
General Material Data
|
MATNR |
| 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 | WERK |
T001L
Storage Locations
|
WERKS |
| EQSE | LAGER | EQSE | LAGER |
T001L
Storage Locations
|
LGORT |
| EQSE | LAGER | EQSE | MANDT |
T001L
Storage Locations
|
MANDT |
| 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 | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| EQSE | SDBELN | EQSE | SDBELN |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| EQSE | WERK | EQSE | MANDT |
T001W
Plants/Branches
|
MANDT |
| EQSE | WERK | EQSE | WERK |
T001W
Plants/Branches
|
WERKS |