SAP table SERI (Serial Numbers)
SAP table SERI has 3 primary key fields being MANDT,MATNR,SERNR.
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
Client
CLNT
3
0
*
MANDT
Material Number
CHAR
40
0
MARA
MATNR
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
Possible values
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
Sold-to Party
CHAR
10
0
KNA1
KUNAG
SDBELN
Delivery
CHAR
10
0
*
VBELN_VL
WABELN
Number of Material Document
CHAR
10
0
MBLNR
BLART
Document Type
CHAR
2
0
T003
BLART
SERI foreign key relationships
Table
Field
Check Table
Check Field
0 SERI
BLART
T003 Document Types
MANDT
1 SERI
CHARGE
MCHA Batches
MANDT
1 SERI
CHARGE
MCHA Batches
WERKS
1 SERI
CHARGE
MCHA Batches
CHARG
0 SERI
EQUNR
EQUI Equipment master data
MANDT
1 SERI
KUNDE
KNA1 General Data in Customer Master
MANDT
1 SERI
KUNDE
KNA1 General Data in Customer Master
KUNNR
0 SERI
LAGER
T001L Storage Locations
MANDT
0 SERI
LAGER
T001L Storage Locations
WERKS
1 SERI
MATNR
MARA General Material Data
MANDT
1 SERI
MATNR
MARA General Material Data
MATNR
0 SERI
WERK
T001W Plants/Branches
WERKS