SAP table reference
TSERIAL
Serial Number ProfileExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TSERIAL.
SAP table TSERIAL has 2 primary key fields: MANDT,SERIAL.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
TSERIAL fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key SERIAL | Serial Number Profile | CHAR | 4 | 0 | CIFSERIAL | ||
| PREFIX | Serial Number Prefix | CHAR | 30 | 0 | DE_SER_PREFIX | ||
| NR_OBJECT | Number Range Object | CHAR | 10 | 0 | TNRO | NROBJ | |
| NR_INTERVAL | Number range number | CHAR | 2 | 0 | NRIV | NRNR | |
| NUMBERING | Automatic Numbering | CHAR | 1 | 0 | DE_SER_NUMBERING | ||
| STOCK | Serial Number Requirement | CHAR | 1 | 0 | DE_SER_STOCK | ||
| UNIT | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |
| IUID_ACTIVE | IUID Active | CHAR | 1 | 0 | DE_IUID_ACTIVE |
/ Relationships
TSERIAL relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| TSERIAL | NR_INTERVAL | NRIV | Number Range Intervals | CLIENT |
| TSERIAL | NR_INTERVAL | NRIV | Number Range Intervals | SUBOBJECT |
| TSERIAL | NR_INTERVAL | NRIV | Number Range Intervals | NRRANGENR |
| TSERIAL | NR_INTERVAL | NRIV | Number Range Intervals | TOYEAR |
| TSERIAL | NR_OBJECT | TNRO | Definition of number range objects | OBJECT |
| TSERIAL | UNIT | T006 | Units of Measurement | MANDT |
| TSERIAL | UNIT | T006 | Units of Measurement | MSEHI |