SAP table TC52 (Control Recipe Destinations)
SAP table TC52 has 3 primary key fields being MANDT,WERKS,PHSEQ.
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 | |||||||||
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||
| PHSEQ | Control Recipe Destination | CHAR | 2 | 0 | PHSEQ | ||||||||||
| ADRES | Address of the Control Recipe Destination | CHAR | 32 | 0 | ADR | ||||||||||
| COMTY | Type of Control Recipe Destination | CHAR | 1 | 0 | COMTY |
|
|||||||||
| SEBEZ | Description of the Control Recipe Destination | CHAR | 20 | 0 | SEBEZ | ||||||||||
| VIS_PHASES | Number of Phases Displayed in a PI Sheet | NUMC | 4 | 0 | CO_VISPH |
|
|||||||||
| CHK_SIGN | Password Entry for SIGN | CHAR | 1 | 0 | CO_CHKSIGN | ||||||||||
| ELEC_SIGN | Digital Signature in the PI Sheet | CHAR | 1 | 0 | SIG_SH | ||||||||||
| SIGNSTRAT_DEV | Default Signature Strategy for Deviations | CHAR | 8 | 0 | TC85 | SIGNSTRAT_DEV | |||||||||
| SIGNSTRAT_STEP | Default Signature Strategy for Process Steps | CHAR | 8 | 0 | TC85 | SIGNSTRAT_STEP | |||||||||
| PV_SORT_MAT | Ind.: Sort Generated Process Instructions by Material | CHAR | 1 | 0 | PV_SORT_MAT | ||||||||||
| PROT_ACTV_DEAC | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||||||||||
| PROT_LOCK_UNLO | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||||||||||
| PROT_COMP | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||||||||||
| PROT_ENTR | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||||||||||
| SIG_STR_ACT_DEAC | Signature Strategy | CHAR | 8 | 0 | TC85 | SIGNSTRAT | |||||||||
| SIG_STR_LOC_UNLO | Signature Strategy | CHAR | 8 | 0 | TC85 | SIGNSTRAT | |||||||||
| SIG_STR_COMP | Signature Strategy | CHAR | 8 | 0 | TC85 | SIGNSTRAT | |||||||||
| SIG_STR_ENTR | Signature Strategy | CHAR | 8 | 0 | TC85 | SIGNSTRAT | |||||||||
| GEN_MODE | Ctrl Recipe Destination: Type of Gen. Ctrl Recipe (XSteps) | CHAR | 1 | 0 | CMX_CR_GEN_MODE |
TC52 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TC52 | SIGNSTRAT_DEV | TC85 | Signature Strategy | MANDT |
| 0 TC52 | SIGNSTRAT_DEV | TC85 | Signature Strategy | APPLICID |
| 1 TC52 | SIGNSTRAT_STEP | TC85 | Signature Strategy | MANDT |
| 1 TC52 | SIGNSTRAT_STEP | TC85 | Signature Strategy | APPLICID |
| 0 TC52 | SIG_STR_ACT_DEAC | TC85 | Signature Strategy | MANDT |
| 0 TC52 | SIG_STR_ACT_DEAC | TC85 | Signature Strategy | APPLICID |
| 1 TC52 | SIG_STR_COMP | TC85 | Signature Strategy | MANDT |
| 1 TC52 | SIG_STR_COMP | TC85 | Signature Strategy | APPLICID |
| 0 TC52 | SIG_STR_ENTR | TC85 | Signature Strategy | MANDT |
| 0 TC52 | SIG_STR_ENTR | TC85 | Signature Strategy | APPLICID |
| 1 TC52 | SIG_STR_LOC_UNLO | TC85 | Signature Strategy | MANDT |
| 1 TC52 | SIG_STR_LOC_UNLO | TC85 | Signature Strategy | APPLICID |
| 0 TC52 | WERKS | T001W | Plants/Branches | WERKS |