Serial Number Records — the serial-number history/master table linking a material's serial number (MATNR+SERNR) to the equipment master it generated (EQUNR), including creation/change audit fields, plant/storage location/batch/customer context at the time of serialization, and a self-referencing history pointer (HEQSNR) to prior serial-number records. Small, complete table.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| NSR key | numerus serialis | Internal serial number | EQSNR | NUMC 10 | — |
| MAT_NUM | materia numerus | Material Number | MATNR | CHAR 18 | MARA |
| NSR2 | numerus serialis | Serial number | GERNR | CHAR 18 | — |
| NOM_PSN_CRE | nomen persona creatus | Name of Person who Created the Object | ERNAM | CHAR 12 | — |
| DIE_TBL_CRE | dies tabula creatus | Date on Which Record Was Created | ERDAT | DATS 8 | — |
| NOM_PSN_MUT | nomen persona mutatus | Name of Person Who Changed Object | AENAM | CHAR 12 | — |
| MUT | mutatus | Changed On | AEDAT | DATS 8 | — |
| INM_NUM | instrumentum numerus | Equipment Number | EQUNR | CHAR 18 | EQUI |
| STA_NSR | status numerus serialis | Status of the serial number | STATUS_EQSE | CHAR 2 | — |
| OFC | officina | Plant | WERK_D | CHAR 4 | T001W |
| LOC | locus repositionis | Storage Location | LGORT_D | CHAR 4 | T001L |
| GRX_NUM | grex numerus | Batch Number | CHARG_D | CHAR 10 | MCHA |
| EMP_NUM | emptor numerus | Customer Number | KUNDE | CHAR 10 | KNA1 |
| VDT_DTB_NDO | venditio distributio numerus documenti | Sales and Distribution Document Number | SDBELN | CHAR 10 | VBUK |
| NUM_MTM_MAT | numerus motus mercium materia | Number of Goods Movement (Material Document) | WABELN | CHAR 10 | — |
| GDO | genus documenti | Document Type | BLART | CHAR 2 | T003 |
| NSR3 | numerus serialis | History: Internal serial number | HEQSNR | NUMC 10 | EQSE |
| POS_NUM_NSR | positio numerus numerus serialis | History: Item number of the serial number in the document | HSNPOS | NUMC 4 | — |
| MAT_NUM2 | materia numerus | History: Material Number | HMATNR | CHAR 18 | MARA |
| IDX_NSR | index numerus serialis | Indicator: Reversed serial number history | REVLV | CHAR 1 | — |
| OBI_NUM | obiectum numerus | Object number | J_OBJNR | CHAR 22 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
BLART | T003 | BLART |
CHARGE | MCHA | MATNR |
CHARGE | MCHA | WERKS |
CHARGE | MCHA | CHARG |
EQUNR | EQUI | EQUNR |
HEQSNR | EQSE | EQSNR |
HMATNR | MARA | MATNR |
KUNDE | KNA1 | KUNNR |
LAGER | T001L | LGORT |
MANDT | T000 | MANDT |
MATNR | MARA | MATNR |
SDBELN | VBUK | VBELN |
WERK | T001W | WERKS |