SAP table TCA01 (Task list types)
SAP table TCA01 has 2 primary key fields being MANDT,PLNTY.
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 | |
| PLNTY | Task List Type | CHAR | 1 | 0 | PLNTY | ||
| PLNAW | Application of the task list | CHAR | 1 | 0 | TCA09 | PLNAW | |
| MATKZ | Indicator: material allocation | CHAR | 1 | 0 | MATKZ | ||
| BLDTY | Screen sequence type for table: T185 Control | CHAR | 1 | 0 | BLDTY | ||
| OBJECT | Number Range Object | CHAR | 10 | 0 | TNRO | NROBJ | |
| NKNRI | Number range number for internal number assignment | CHAR | 2 | 0 | NKNRI | ||
| NKNRE | Number range number for external number assignment | CHAR | 2 | 0 | NKNRE | ||
| FLG_OPRSOP | Indicator: same handling of operations and sub-operations | CHAR | 1 | 0 | FLG_OPRSOP | ||
| FLG_SEQ | Indicator: parallel / alternative sequences | CHAR | 1 | 0 | FLG_SEQ | ||
| FLG_QSS | Indicator: QM data | CHAR | 1 | 0 | FLG_QSS | ||
| FLG_AOB | Indicator: relationships | CHAR | 1 | 0 | FLG_AOB | ||
| FLG_UOBJ | Indicator: sub-objects used when processing dialog tables | CHAR | 1 | 0 | FLG_UOBJ | ||
| FLG_EQUI | Indicator: allocation of equipment possible | CHAR | 1 | 0 | IEQKZ | ||
| FLG_IFL | Indicator: allocation of functional location possible | CHAR | 1 | 0 | IFLKZ | ||
| FLG_INST | Indicator: plant maintenance data active | CHAR | 1 | 0 | FLG_INST | ||
| SCREENTY | SCREEN TYPE: for order-order category (see domain) | CHAR | 4 | 0 | SCREENTY | ||
| FLG_REF | Indicator: task list can be referenced | CHAR | 1 | 0 | FLG_REF | ||
| FLG_PHAS | Indicator: CAP/sub-operations active | CHAR | 1 | 0 | FLG_PHAS | ||
| FLG_FEAT | Indicator: Recipe/proc. instructions active | CHAR | 1 | 0 | FLG_FEAT | ||
| FLG_DOC | Indicator: creation of change documents active | CHAR | 1 | 0 | FLG_DOC | ||
| FLG_PHYS | Indicator: Delete physically | CHAR | 1 | 0 | PLG_PHYS | ||
| FLG_MST | Indicator: Operation is a Milestone | CHAR | 1 | 0 | FLG_MST | ||
| FLG_CHK | Ind: Consistency check prior to posting | CHAR | 1 | 0 | FLG_CHK | ||
| PID_MAT | Take get/set parameter into account for material field | CHAR | 1 | 0 | PID_MAT | ||
| PID_PLN | Take get/set parameter into account for task list field | CHAR | 1 | 0 | PID_PLN | ||
| FLG_STUELI | Ind: Bill of material can be allocated | CHAR | 1 | 0 | FLG_STUELI | ||
| PID_AUN | Take get/set parameter for SD document number into account | CHAR | 1 | 0 | PID_AUN | ||
| FLG_GPOS | Indicator: Items in graphics | CHAR | 1 | 0 | FLG_GPOS | ||
| FLG_MKAL | Indicator: Production version | CHAR | 1 | 0 | FLG_MKAL | ||
| FLG_ERF_OP | Indicator: Operation screen seq. active using tca60/62 | CHAR | 1 | 0 | FLG_ERF_OP | ||
| OPR_BLDGR | Screen group | CHAR | 2 | 0 | OPR_BLDGR | ||
| OPR_PANEL | Identifies current screen display | CHAR | 4 | 0 | OPR_PANEL | ||
| FLG_CHK_RE | Indicator: Inspection scope reduced on screens | CHAR | 1 | 0 | FLG_CHK_RE | ||
| FLG_ARBEI | Indicator: Default value work is relevant | CHAR | 1 | 0 | FLG_ARBEI | ||
| FLG_KALC | Indicator: material quantity calculation | CHAR | 1 | 0 | FLG_KALC | ||
| FLG_CHRULE | Indicator: change rule can be activated | CHAR | 1 | 0 | FLG_CHRULE | ||
| FLG_LK_CHK | Indicator: Authorization check for deletion active | CHAR | 1 | 0 | FLG_LOEKZ_CHK | ||
| FLG_MATCOM | Check material type against components | CHAR | 1 | 0 | FLG_MATCOM |
TCA01 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCA01 | OBJECT | TNRO | Definition of number range objects | OBJECT |
| 1 TCA01 | PLNAW | TCA09 | Task list applications | MANDT |
| 1 TCA01 | PLNAW | TCA09 | Task list applications | PLNAW |