SAP Table TJ30
User Status
TJ30 (User Status) 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 TJ30 to other SAP tables.
TJ30 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| STSMA | Status Profile | J_STSMA | TJ20 | CHAR | 8 | 0 | ||||||
| ESTAT | User Status | J_ESTAT | CHAR | 5 | 0 | |||||||
| INIST | Initial status flag | J_INIST | CHAR | 1 | 0 |
Possible values
|
||||||
| STONR | Status Order Number | J_STONR | NUMC | 2 | 0 | |||||||
| HSONR | Highest Status Number | J_HSONR | NUMC | 2 | 0 | |||||||
| NSONR | Lowest status number | J_NSONR | NUMC | 2 | 0 | |||||||
| LINEP | Position of the status in the status display | J_LINEP | NUMC | 2 | 0 | |||||||
| STATP | Status display priority at a particular position | J_STATP | NUMC | 2 | 0 | |||||||
| BERSL | Authorization key | J_BERSL | TJ10 | CHAR | 8 | 0 | ||||||
| CRM_VRGNG | CRM: User Status Triggers Business Transaction | J_CRMVRG | TJ01 | CHAR | 4 | 0 | ||||||
TJ30 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TJ30 | BERSL | TJ30 | MANDT | TJ10 | Authorization Keys in Status Management | MANDT |
| TJ30 | BERSL | TJ30 | BERSL | TJ10 | Authorization Keys in Status Management | BERSL |
| TJ30 | CRM_VRGNG | TJ30 | CRM_VRGNG | TJ01 | Business Transactions | VRGNG |
| TJ30 | MANDT | TJ30 | MANDT | T000 | Clients | MANDT |
| TJ30 | STSMA | TJ30 | MANDT | TJ20 | Status profiles | MANDT |
| TJ30 | STSMA | TJ30 | STSMA | TJ20 | Status profiles | STSMA |
