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
MANDT Client CLNT 3 0 * MANDT
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 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