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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||
| STOCK | Serial Number Requirement | DE_SER_STOCK | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 | NR_INTERVAL | NRIV | Number Range Intervals | NRRANGENR |
| TSERIAL | NR_INTERVAL | * | NRIV | Number Range Intervals | TOYEAR | |
| 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_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 |
