SAP Table TSERIAL
Serial Number Profile
TSERIAL (Serial Number Profile) 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 TSERIAL to other SAP tables.
TSERIAL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
SERIAL
Serial Number Profile
|
CIFSERIAL |
CHAR
|
4 | 0 | ||||||||||||
|
PREFIX
Serial Number Prefix
|
DE_SER_PREFIX |
CHAR
|
30 | 0 | ||||||||||||
|
NR_OBJECT
Name of number range object
|
NROBJ | TNRO |
CHAR
|
10 | 0 | |||||||||||
|
NR_INTERVAL
Number range number
|
NRNR | NRIV |
CHAR
|
2 | 0 | |||||||||||
|
NUMBERING
Automatic Numbering
|
DE_SER_NUMBERING |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
STOCK
Serial Number Requirement
|
DE_SER_STOCK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
UNIT
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
TSERIAL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TSERIAL | MANDT | TSERIAL | MANDT |
T000
Clients
|
MANDT |
| TSERIAL | NR_INTERVAL | TSERIAL | MANDT |
NRIV
Number Range Intervals
|
CLIENT |
| TSERIAL | NR_INTERVAL | TSERIAL | NR_OBJECT |
NRIV
Number Range Intervals
|
OBJECT |
| TSERIAL | NR_INTERVAL | * |
NRIV
Number Range Intervals
|
SUBOBJECT | |
| TSERIAL | NR_INTERVAL | TSERIAL | NR_INTERVAL |
NRIV
Number Range Intervals
|
NRRANGENR |
| TSERIAL | NR_INTERVAL | * |
NRIV
Number Range Intervals
|
TOYEAR | |
| TSERIAL | NR_OBJECT | TSERIAL | NR_OBJECT |
TNRO
Definition of number range objects
|
OBJECT |
| TSERIAL | UNIT | TSERIAL | MANDT |
T006
Units of Measurement
|
MANDT |
| TSERIAL | UNIT | TSERIAL | UNIT |
T006
Units of Measurement
|
MSEHI |