TSP0A (Spool: Device types) 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 TSP0A to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
PATYPE
Spool: Device type name
|
RSPOPTYPE |
CHAR
|
8 | 0 | ||||||||||||||||||
|
PPRINT
Spool: Page printer
|
RSPOPPRINT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
DRIVER
Spool: Driver name
|
RSPODRIVER | TSP09 |
CHAR
|
4 | 0 | |||||||||||||||||
|
PVERS
Spool printer version
|
RSPOPVERS |
NUMC
|
5 | 0 | ||||||||||||||||||
|
PNAME
Spool: Name
|
RSPONAME |
CHAR
|
30 | 0 | ||||||||||||||||||
|
CPCODEPAGE
SAP Character Set ID
|
CPCODEPAGE | TCP00 |
NUMC
|
4 | 0 | |||||||||||||||||
|
CODEPG1ALT
SAP Character Set ID
|
CPCODEPAGE | TCP00 |
NUMC
|
4 | 0 | |||||||||||||||||
|
CODEPG2ALT
SAP Character Set ID
|
CPCODEPAGE | TCP00 |
NUMC
|
4 | 0 | |||||||||||||||||
|
CODEPGSYNT
SAP Character Set ID
|
CPCODEPAGE | TCP00 |
NUMC
|
4 | 0 | |||||||||||||||||
|
BASE
Spool: Name of a standard device type
|
RSPOBPTYP | TSP0A |
CHAR
|
8 | 0 | |||||||||||||||||
|
LSTDRIVER
Spool: Name of a list driver
|
RSPOLSTDRV |
CHAR
|
4 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
LSTSUBTYPE
Spool: list driver argument
|
RSPOLSTARG |
CHAR
|
4 | 0 | ||||||||||||||||||
|
CHGNAME1
Spool: changed by
|
RSPOCHGNME |
CHAR
|
12 | 0 | ||||||||||||||||||
|
CHGTSTMP1
Spool: Time stamp for modification
|
RSPOCHGTME |
CHAR
|
14 | 0 | ||||||||||||||||||
|
CHGSAPREL1
Release of SAP System
|
SYSAPRL |
CHAR
|
4 | 0 | ||||||||||||||||||
|
CHGSAPSYS1
Name of SAP System
|
SYSYSID |
CHAR
|
8 | 0 | ||||||||||||||||||
|
CHGNAME2
Spool: changed by
|
RSPOCHGNME |
CHAR
|
12 | 0 | ||||||||||||||||||
|
CHGTSTMP2
Spool: Time stamp for modification
|
RSPOCHGTME |
CHAR
|
14 | 0 | ||||||||||||||||||
|
CHGSAPREL2
Release of SAP System
|
SYSAPRL |
CHAR
|
4 | 0 | ||||||||||||||||||
|
CHGSAPSYS2
Name of SAP System
|
SYSYSID |
CHAR
|
8 | 0 | ||||||||||||||||||
|
CHGNAME3
Spool: changed by
|
RSPOCHGNME |
CHAR
|
12 | 0 | ||||||||||||||||||
|
CHGTSTMP3
Spool: Time stamp for modification
|
RSPOCHGTME |
CHAR
|
14 | 0 | ||||||||||||||||||
|
CHGSAPREL3
Release of SAP System
|
SYSAPRL |
CHAR
|
4 | 0 | ||||||||||||||||||
|
CHGSAPSYS3
Name of SAP System
|
SYSYSID |
CHAR
|
8 | 0 | ||||||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TSP0A | BASE | TSP0A | BASE |
TSP0A
Spool: Device types
|
PATYPE |
| TSP0A | CODEPG1ALT | TSP0A | CODEPG1ALT |
TCP00
SAP code page catalog
|
CPCODEPAGE |
| TSP0A | CODEPG2ALT | TSP0A | CODEPG2ALT |
TCP00
SAP code page catalog
|
CPCODEPAGE |
| TSP0A | CODEPGSYNT | TSP0A | CODEPGSYNT |
TCP00
SAP code page catalog
|
CPCODEPAGE |
| TSP0A | CPCODEPAGE | TSP0A | CPCODEPAGE |
TCP00
SAP code page catalog
|
CPCODEPAGE |
| TSP0A | DRIVER | TSP0A | DRIVER |
TSP09
Spool: Printer drivers
|
DRIVER |