SAP Table
TCA11 Object selection for object overviews
SAP table TCA11 has 2 primary key fields being MANDT,OBJST.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TCA11 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyOBJST | Object Selection | CHAR | 4 | 0 | OBJST_D | ||||||||||
| FLG_ALT | Indicator: headers | CHAR | 1 | 0 | ALT_FLG | ||||||||||
| FLG_SEQ | Sequences | CHAR | 1 | 0 | SEQ_FLG | ||||||||||
| FLG_OPR | Indicator: operations | CHAR | 1 | 0 | OPR_FLG | ||||||||||
| FLG_SOP | Indicator: sub-operations | CHAR | 1 | 0 | SOP_FLG | ||||||||||
| FLG_MAT | Indicator: material component | CHAR | 1 | 0 | MAT_FLG | ||||||||||
| FLG_FHM | Indicator: production resources/tools | CHAR | 1 | 0 | FHM_FLG | ||||||||||
| FLG_QMK | Indicator: inspection characteristics | CHAR | 1 | 0 | QMK_FLG | ||||||||||
| FLG_QMW | Indicator: values for inspection characteristics | CHAR | 1 | 0 | QMW_FLG | ||||||||||
| FLG_AOB | Key: View of relationships | CHAR | 1 | 0 | AOB_KEY | ||||||||||
|
|||||||||||||||
| FLG_TXT | Indicator: PS texts | CHAR | 1 | 0 | TXT_FLG | ||||||||||
| FLG_PMS | Flag for maintenance package allocation | CHAR | 1 | 0 | PMS_FLG | ||||||||||
| FLG_APS | Order item indicator | CHAR | 1 | 0 | APS_FLG | ||||||||||
| FLG_BED | Indicator: Capacity requirements | CHAR | 1 | 0 | BED_FLG | ||||||||||
| FLG_PHAS | Indicator: CAP/sub-operations active | CHAR | 1 | 0 | FLG_PHAS | ||||||||||
| FLG_MST | Indicator: Operation is a Milestone | CHAR | 1 | 0 | FLG_MST | ||||||||||
| FLG_SNT | Indicator: Subnetwork | CHAR | 1 | 0 | FLG_SNT | ||||||||||
| FLG_FEAT | Indicator: Recipe/proc. instructions active | CHAR | 1 | 0 | FLG_FEAT | ||||||||||
| FLG_FEAV | Indicator: Process instruction characteristic/parameter val. | CHAR | 1 | 0 | FLG_FEAV | ||||||||||