1. Home
  2. Resources
  3. SAP Tables
  4. DISERX1 - Serial Number History

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
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
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
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
NULL No switch
3 Switched - configuration changeable; compare TVAP-LTYPA
4 Switched - configuration not changeable; compare TVAP-LTYPA
LOKNZ Object list deletion indicator LOEKNZ CHAR 1 0
X Yes
NULL No
DBKNZ Data base indicator DBKNZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
H Credit
S Debit
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
X Yes
NULL No
PREFETCH Prefetch Indicator PREFT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PPAUFNR Order Number AUFNR CHAR 12 0
PPPOSNR Order Item Number CO_POSNR NUMC 4 0
PPAUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
PPAUFART Order Type AUFART CHAR 4 0
PPWERK Plant WERKS_D CHAR 4 0
PMRSORD Refurbishment order indicator (PM) RSORD CHAR 1 0
X Yes
NULL No
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
1 Inventory balance object list
2 Counted stock object list
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
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
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
X Yes
NULL No
SERRU Type of subcontracting SERRU CHAR 1 0
NULL Subcontracting
1 Refurbishment with unchanged material number
2 Refurbishment with changed material number
3 Replacement
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
A PM order
W Maintenance item
S Serial number list
K Maintenance contract
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
SER01 Document Header for Serial Numbers for Delivery
SER02 Document Header for Serial Nos for Maint.Contract (SD Order)
SER03 Document Header for Serial Numbers for Goods Movements
SER04 Document Header for Serial Numbers for Inspection Lot
SER05 Document Header for Serial Numbers for PP Order
SER06 Document Header for Serial Numbers for Handling Unit-Content
SER07 Document Header for Serial Numbers in Physical Inventory
SER08 Document Header for Serial Numbers in Purchase Order
SER09 Document Header for Serial Numbers in Purchase Requisition
TPLNR Functional Location TPLNR CHAR 30 0
INST_DISM Install/Dismantle INST_DISM CHAR 1 0
X Entry Exists
NULL Entry Does Not Exist
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 MANDT T001L Storage Locations MANDT
DISERX1 LAGERORT DISERX1 WERK T001L Storage Locations WERKS
DISERX1 LAGERORT DISERX1 LAGERORT T001L Storage Locations LGORT
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 LIEF_NR VBUP Sales Document: Item Status VBELN
DISERX1 POSNR DISERX1 POSNR VBUP Sales Document: Item Status POSNR
DISERX1 POSNR DISERX1 MANDT VBUP Sales Document: Item Status MANDT
DISERX1 VORGANG DISERX1 MANDT T377X Documents Allowed for Serial Number Management MANDT
DISERX1 VORGANG DISERX1 VORGANG T377X Documents Allowed for Serial Number Management BELEG
DISERX1 WERK DISERX1 MANDT T001W Plants/Branches MANDT
DISERX1 WERK DISERX1 WERK T001W Plants/Branches WERKS