SAP table SER03 (Document Header for Serial Numbers for Goods Movements)

SAP table SER03 has 2 primary key fields being MANDT,OBKNR.

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
OBKNR Object list number INT8 19 0 SER00 OBJKNR
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item in Material Document NUMC 4 0 MBLPO
BLART Document Type CHAR 2 0 T003 BLART
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
DATUM Date DATS 8 0 DATUM
UZEIT Time TIMS 6 0 UZEIT
LETZNR Counter key NUMC 4 0 OBZAE
ANZSN Number of serial numbers INT4 10 0 ANZSN
VORGANG Serialization Procedure for Serial Number Management CHAR 4 0 T377X BELEG
LIEFERANT Vendor number CHAR 10 0 LFA1 ELIEF
KUNDE Customer Number CHAR 10 0 KNA1 KUNNR
WERK Plant CHAR 4 0 T001W WERKS_D
LAGERORT Storage location CHAR 4 0 T001L LGORT_D
CHARGE Batch Number CHAR 10 0 CHARG_D

SER03 foreign key relationships

Table Field Check Table Check Field
0 SER03 BLART T003 Document Types MANDT
1 SER03 BWART T156 Movement Type MANDT
1 SER03 BWART T156 Movement Type BWART
0 SER03 KUNDE KNA1 General Data in Customer Master MANDT
0 SER03 KUNDE KNA1 General Data in Customer Master KUNNR
1 SER03 LAGERORT T001L Storage Locations MANDT
1 SER03 LAGERORT T001L Storage Locations WERKS
0 SER03 LIEFERANT LFA1 Supplier Master (General Section) MANDT
0 SER03 LIEFERANT LFA1 Supplier Master (General Section) LIFNR
1 SER03 OBKNR SER00 General Header Table for Serial Number Management MANDT
1 SER03 OBKNR SER00 General Header Table for Serial Number Management OBKNR
0 SER03 VORGANG T377X Documents Allowed for Serial Number Management MANDT
1 SER03 WERK T001W Plants/Branches WERKS