SAP Table TCN01
Key Word Text for PS User Fields
TCN01 (Key Word Text for PS User Fields) 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 TCN01 to other SAP tables.
TCN01 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SPRAS | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||
| SLWID | Key word ID for user-defined fields | SLWID | TCN00 | CHAR | 7 | 0 | ||
| KTEXT | Description for the key word ID | SLWTXT | CHAR | 40 | 0 | |||
| SWRT0 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT1 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT2 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT3 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT4 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT5 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT6 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT7 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT8 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT9 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT10 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
| SWRT11 | Key word for user-defined fields | SLWORT | CHAR | 15 | 0 | |||
TCN01 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TCN01 | MANDT | TCN01 | MANDT | T000 | Clients | MANDT |
| TCN01 | SLWID | TCN01 | MANDT | TCN00 | Key Word ID for PS User Fields | MANDT |
| TCN01 | SLWID | TCN01 | SLWID | TCN00 | Key Word ID for PS User Fields | SLWID |
| TCN01 | SPRAS | TCN01 | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
