SAP table DISERX1 (Serial Number History)

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
LIEF_NR Delivery CHAR 10 0 * VBELN_VL
POSNR Delivery Item NUMC 6 0 * POSNR_VL
DATUM Date DATS 8 0 DATUM
LETZNR Counter key NUMC 4 0 OBZAE
KUNDE Customer Number CHAR 10 0 KNA1 KUNNR
ANZSN Number of serial numbers INT4 10 0 ANZSN
VORGANG Serialization Procedure for Serial Number Management CHAR 4 0 T377X BELEG
UZEIT Time TIMS 6 0 UZEIT
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
BWART Movement type (inventory management) CHAR 3 0 * BWART
LOKNZ Object list deletion indicator CHAR 1 0 LOEKNZ
DBKNZ Data base indicator CHAR 1 0 DBKNZ
SDAUFNR Order CHAR 10 0 VBELN_VLA
SD_AUART Sales Document Type CHAR 4 0 * AUART
SD_POSTYP Sales document item category CHAR 4 0 * PSTYV
MSEGZN Counter for MSEG Serial Number Assignment INT4 10 0 MSEGZN
PRUEFLOS Inspection Lot Number NUMC 12 0 QPLOS
LIEFERANT Vendor number CHAR 10 0 * ELIEF
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 * BLART
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
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
WAPOS Maintenance item CHAR 16 0 WAPOS
PMAUFNR Order Number CHAR 12 0 * AUFNR
XAUTO Indicator: Line item automatically created CHAR 1 0 XAUTO
PREFETCH Prefetch Indicator CHAR 1 0 PREFT
PPAUFNR Order Number CHAR 12 0 * AUFNR
PPPOSNR Order item number NUMC 4 0 CO_POSNR
PPAUTYP Order category NUMC 2 0 AUFTYP
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
99 Master Planned order
PPAUFART Order Type CHAR 4 0 * AUFART
PPWERK Plant CHAR 4 0 WERKS_D
PMRSORD Refurbishment order indicator (PM) CHAR 1 0 RSORD
VENUM Internal Handling Unit Number CHAR 10 0 * VENUM
VEPOS Handling Unit Item NUMC 6 0 * VEPOS
EXIDV External Handling Unit Identification CHAR 20 0 EXIDV
IBLNR Physical Inventory Document CHAR 10 0 IBLNR
ZEILI Line Number NUMC 3 0 DZEILE
OLTPI Object List Feature - Physical Inventory CHAR 1 0 OLTPI
1 Inventory balance object list
2 Counted stock object list
BSTAR Stock Type (Physical Inventory) CHAR 1 0 * I_BSTAR
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 * EBELP
ETENR Delivery Schedule Line Counter NUMC 4 0 * EETEN
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
BSART Purchasing Document Type CHAR 4 0 * ESART
PSTYP Item category in purchasing document CHAR 1 0 * PSTYP
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BNFPO Item number of purchase requisition NUMC 5 0 * BNFPO
INTERNALJITCALLNUMBER Call Number NUMC 10 0 NJIT_INT_CALL_NUM
EXTERNALJITCALLNUMBER External Call Number CHAR 35 0 NJIT_EXT_CALL_NUM
COMPGRPNUMBER Component Group Number CHAR 60 0 NJIT_COMP_GRP_NUM
JITCALLITEMNUMBER Call Item Number NUMC 4 0 NJIT_CALL_ITEM_NUM
VEHICLEIDENTIFICATIONNUMBER Vehicle Identification Number (Vehicle Identification No.) CHAR 35 0 VLC_VHVIN
JITEXTSEQUENCENUMBER External Sequence Number CHAR 35 0 NJIT_EXT_SEQNR
SHIPTOPARTY Ship-to Party CHAR 10 0 * KUNWE
JITSCENARIO Just-In-Time Scenarios CHAR 1 0 NJIT_SCENARIO
All
1 S2C - Supply to Customer
2 S2P - Supply to Production
LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
STAPO Item is statistical CHAR 1 0 STAPO
SERRU Type of subcontracting CHAR 1 0 SERRU
Subcontracting
1 Refurbishment with unchanged material number
2 Refurbishment with changed material number
3 Replacement
UEBPO Higher-Level Item in Purchasing Documents NUMC 5 0 * UEBPO
UPTYP Subitem Category, Purchasing Document CHAR 1 0 * UPTYP
EQUNR Equipment Number CHAR 18 0 EQUNR
IHNUM Notification Number CHAR 12 0 * QMNUM
BAUTL Assembly CHAR 40 0 * BAUTL
ILOAN Location and account assignment for technical object CHAR 12 0 * ILOAN
SORTF Object list sort field CHAR 20 0 OBSORT
BEARB Processing indicator CHAR 1 0 BEARBZS
OBJVW Object list usage CHAR 1 0 OBJVW
A PM order
K Maintenance contract
S Serial number list
W Maintenance item
SERNR Serial Number CHAR 18 0 GERNR
MATNR Material Number CHAR 40 0 MATNR
EQSNR EQSE Number CHAR 18 0 * EQSNR
TASER Table for Serial Numbers CHAR 5 0 TASER
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
SER10 Document Header for Serial Numbers in JIT Call
TPLNR Functional Location CHAR 30 0 TPLNR
INST_DISM Install/Dismantle CHAR 1 0 INST_DISM
UII Unique Item Identifier CHAR 72 0 UII_CHAR72
IUID_TYPE Structure Type of UII CHAR 10 0 IUID_TYPE
UII_PLANT Plant Responsible for UII CHAR 4 0 UII_PLANT

DISERX1 foreign key relationships

Table Field Check Table Check Field
0 DISERX1 KUNDE KNA1 General Data in Customer Master MANDT
0 DISERX1 KUNDE KNA1 General Data in Customer Master KUNNR
1 DISERX1 LAGERORT T001L Storage Locations MANDT
1 DISERX1 LAGERORT T001L Storage Locations WERKS
0 DISERX1 MANDT T000 Clients MANDT
1 DISERX1 OBKNR SER00 General Header Table for Serial Number Management MANDT
1 DISERX1 OBKNR SER00 General Header Table for Serial Number Management OBKNR
0 DISERX1 VORGANG T377X Documents Allowed for Serial Number Management MANDT
1 DISERX1 WERK T001W Plants/Branches WERKS