Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table DISERX1

Serial Number History

DISERX1 (Serial Number History) 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 DISERX1 to other SAP tables.

DISERX1 table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
 MANDT T000
CLNT
 3 0
OBKNR
Object list number
 OBJKNR SER00
INT4
 10 0
LIEF_NR
Delivery
 VBELN_VL VBUK
CHAR
 10 0
POSNR
Delivery Item
 POSNR_VL VBUP
NUMC
 6 0
DATUM
Date
 DATUM
DATS
 8 0
LETZNR
Counter key
 OBZAE
NUMC
 4 0
KUNDE
Customer Number
 KUNNR KNA1
CHAR
 10 0
ANZSN
Number of serial numbers
 ANZSN
INT4
 10 0
VORGANG
Serialization Procedure for Serial Number Management
 BELEG T377X
CHAR
 4 0
UZEIT
Time
 UZEIT
TIMS
 6 0
VBTYP
SD document category
 VBTYP
CHAR
 1 0
BWART
Movement Type (Inventory Management)
 BWART
CHAR
 3 0
VKORG
Sales Organization
 VKORG
CHAR
 4 0
VTWEG
Distribution Channel
 VTWEG
CHAR
 2 0
SPART
Division
 SPART
CHAR
 2 0
LTSPS
Indicator : stockable type switched into standard product
 /SAPHT/SW_LTSPS
CHAR
 1 0
LOKNZ
Object list deletion indicator
 LOEKNZ
CHAR
 1 0
DBKNZ
Data base indicator
 DBKNZ
CHAR
 1 0
SDAUFNR
Order
 VBELN_VLA
CHAR
 10 0
SD_AUART
Sales Document Type
 AUART
CHAR
 4 0
SD_POSTYP
Sales document item category
 PSTYV
CHAR
 4 0
MSEGZN
Counter for MSEG Serial Number Assignment
 MSEGZN
INT4
 10 0
PRUEFLOS
Inspection Lot Number
 QPLOS
NUMC
 12 0
LIEFERANT
Vendor number
 ELIEF
CHAR
 10 0
MBLNR
Number of Material Document
 MBLNR
CHAR
 10 0
MJAHR
Material Document Year
 MJAHR
NUMC
 4 0
ZEILE
Item in Material Document
 MBLPO
NUMC
 4 0
BLART
Document Type
 BLART
CHAR
 2 0
SHKZG
Debit/Credit Indicator
 SHKZG
CHAR
 1 0
WERK
Plant
 WERKS_D T001W
CHAR
 4 0
LAGERORT
Storage Location
 LGORT_D T001L
CHAR
 4 0
CHARGE
Batch Number
 CHARG_D
CHAR
 10 0
WAPOS
Maintenance item
 WAPOS
CHAR
 16 0
PMAUFNR
Order Number
 AUFNR
CHAR
 12 0
XAUTO
Indicator: Line item automatically created
 XAUTO
CHAR
 1 0
PREFETCH
Prefetch Indicator
 PREFT
CHAR
 1 0
PPAUFNR
Order Number
 AUFNR
CHAR
 12 0
PPPOSNR
Order Item Number
 CO_POSNR
NUMC
 4 0
PPAUTYP
Order category
 AUFTYP
NUMC
 2 0
PPAUFART
Order Type
 AUFART
CHAR
 4 0
PPWERK
Plant
 WERKS_D
CHAR
 4 0
PMRSORD
Refurbishment order indicator (PM)
 RSORD
CHAR
 1 0
VENUM
Internal Handling Unit Number
 VENUM
CHAR
 10 0
VEPOS
Handling Unit Item
 VEPOS
NUMC
 6 0
EXIDV
External Handling Unit Identification
 EXIDV
CHAR
 20 0
IBLNR
Physical Inventory Document
 IBLNR
CHAR
 10 0
ZEILI
Line Number
 DZEILE
NUMC
 3 0
OLTPI
Object List Feature - Physical Inventory
 OLTPI
CHAR
 1 0
BSTAR
Stock Type (Physical Inventory
 I_BSTAR
CHAR
 1 0
EBELN
Purchasing Document Number
 EBELN
CHAR
 10 0
EBELP
Item Number of Purchasing Document
 EBELP
NUMC
 5 0
ETENR
Delivery Schedule Line Counter
 EETEN
NUMC
 4 0
BSTYP
Purchasing Document Category
 BSTYP
CHAR
 1 0
BSART
Purchasing Document Type
 ESART
CHAR
 4 0
PSTYP
Item Category in Purchasing Document
 PSTYP
CHAR
 1 0
BANFN
Purchase Requisition Number
 BANFN
CHAR
 10 0
BNFPO
Item Number of Purchase Requisition
 BNFPO
NUMC
 5 0
LOEKZ
Deletion Indicator in Purchasing Document
 ELOEK
CHAR
 1 0
STAPO
Item is statistical
 STAPO
CHAR
 1 0
SERRU
Type of subcontracting
 SERRU
CHAR
 1 0
UEBPO
Higher-Level Item in Purchasing Documents
 UEBPO
NUMC
 5 0
UPTYP
Subitem Category, Purchasing Document
 UPTYP
CHAR
 1 0
EQUNR
Equipment Number
 EQUNR
CHAR
 18 0
IHNUM
Notification No
 QMNUM
CHAR
 12 0
BAUTL
Assembly
 BAUTL
CHAR
 18 0
ILOAN
Location and account assignment for technical object
 ILOAN
CHAR
 12 0
SORTF
Object list sort field
 OBSORT
CHAR
 20 0
BEARB
Processing indicator
 BEARBZS
CHAR
 1 0
OBJVW
Object list usage
 OBJVW
CHAR
 1 0
SERNR
Serial Number
 GERNR
CHAR
 18 0
MATNR
Material Number
 MATNR
CHAR
 18 0
EQSNR
EQSE Number
 EQSNR
CHAR
 18 0
TASER
Table for Serial Numbers
 TASER
CHAR
 5 0
TPLNR
Functional Location
 TPLNR
CHAR
 30 0
INST_DISM
Install/Dismantle
 INST_DISM
CHAR
 1 0
UII
Unique Item Identifier
 UII_CHAR72
CHAR
 72 0
IUID_TYPE
Structure Type of UII
 IUID_TYPE
CHAR
 10 0
UII_PLANT
Plant Responsible for UII
 UII_PLANT
CHAR
 4 0

DISERX1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DISERX1 KUNDE DISERX1 MANDT KNA1
General Data in Customer Master
 MANDT
DISERX1 KUNDE DISERX1 KUNDE KNA1
General Data in Customer Master
 KUNNR
DISERX1 LAGERORT DISERX1 WERK T001L
Storage Locations
 WERKS
DISERX1 LAGERORT DISERX1 LAGERORT T001L
Storage Locations
 LGORT
DISERX1 LAGERORT DISERX1 MANDT T001L
Storage Locations
 MANDT
DISERX1 LIEF_NR DISERX1 MANDT VBUK
Sales Document: Header Status and Administrative Data
 MANDT
DISERX1 LIEF_NR DISERX1 LIEF_NR VBUK
Sales Document: Header Status and Administrative Data
 VBELN
DISERX1 MANDT DISERX1 MANDT T000
Clients
 MANDT
DISERX1 OBKNR DISERX1 MANDT SER00
General Header Table for Serial Number Management
 MANDT
DISERX1 OBKNR DISERX1 OBKNR SER00
General Header Table for Serial Number Management
 OBKNR
DISERX1 POSNR DISERX1 POSNR VBUP
Sales Document: Item Status
 POSNR
DISERX1 POSNR DISERX1 MANDT VBUP
Sales Document: Item Status
 MANDT
DISERX1 POSNR DISERX1 LIEF_NR VBUP
Sales Document: Item Status
 VBELN
DISERX1 VORGANG DISERX1 VORGANG T377X
Documents Allowed for Serial Number Management
 BELEG
DISERX1 VORGANG DISERX1 MANDT T377X
Documents Allowed for Serial Number Management
 MANDT
DISERX1 WERK DISERX1 MANDT T001W
Plants/Branches
 MANDT
DISERX1 WERK DISERX1 WERK T001W
Plants/Branches
 WERKS