SAP table TCA43 (Automatic selection of task lists (alternatives))
SAP table TCA43 has 3 primary key fields being MANDT,SEL_ID,SEL_PR.
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 | |
| SEL_ID | Selection ID for the selection of task lists | CHAR | 2 | 0 | CP_SEL_ID | ||
| SEL_PR | Priority for the selection of task lists | NUMC | 2 | 0 | CP_SEL_PR | ||
| PLNTY | Task List Type | CHAR | 1 | 0 | TCA01 | PLNTY | |
| VERWE | Task List Usage | CHAR | 3 | 0 | T411 | PLN_VERWE | |
| STATU | Status | CHAR | 3 | 0 | T412 | PLNST |
TCA43 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCA43 | PLNTY | TCA01 | Task list types | MANDT |
| 1 TCA43 | STATU | T412 | Task list status | MANDT |
| 1 TCA43 | STATU | T412 | Task list status | PLNST |
| 0 TCA43 | VERWE | T411 | Task list usage | MANDT |