SAP table TJ30 (User Status)
SAP table TJ30 has 3 primary key fields being MANDT,STSMA,ESTAT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| STSMA | Status Profile | CHAR | 8 | 0 | TJ20 | J_STSMA | |
| ESTAT | User Status | CHAR | 5 | 0 | J_ESTAT | ||
| INIST | Initial status flag | CHAR | 1 | 0 | J_INIST | ||
| STONR | Status Order Number | NUMC | 2 | 0 | J_STONR | ||
| HSONR | Highest Status Number | NUMC | 2 | 0 | J_HSONR | ||
| NSONR | Lowest status number | NUMC | 2 | 0 | J_NSONR | ||
| LINEP | Position of the status in the status display | NUMC | 2 | 0 | J_LINEP | ||
| STATP | Status display priority at a particular position | NUMC | 2 | 0 | J_STATP | ||
| BERSL | Authorization key | CHAR | 8 | 0 | TJ10 | J_BERSL | |
| CRM_VRGNG | CRM: User Status Triggers Business Transaction | CHAR | 4 | 0 | TJ01 | J_CRMVRG |
TJ30 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TJ30 | BERSL | TJ10 | Authorization Keys in Status Management | MANDT |
| 1 TJ30 | CRM_VRGNG | TJ01 | Business Transactions | VRGNG |
| 0 TJ30 | STSMA | TJ20 | Status profiles | MANDT |
| 0 TJ30 | STSMA | TJ20 | Status profiles | STSMA |