SAP table COCH (Process Management: Control Recipe Header)
SAP table COCH has 2 primary key fields being MANDT,CRID.
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 | |||||||||
| CRID | Control Recipe ID | NUMC | 18 | 0 | CO_CRID | ||||||||||
| WERK | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||
| BID | Process Order | CHAR | 12 | 0 | CO_BID | ||||||||||
| PHSEQ | Control Recipe Destination | CHAR | 2 | 0 | TC52 | PHSEQ | |||||||||
| ADRES | Address of the Control Recipe Destination | CHAR | 32 | 0 | ADR | ||||||||||
| COTYP | Type of Control Recipe Destination | CHAR | 1 | 0 | COMTY |
|
|||||||||
| TSTKZ | Indicator: Message or Control Recipe for Test Purposes | CHAR | 1 | 0 | TSTKZ | ||||||||||
| CRSTAT | Control Recipe Status | CHAR | 5 | 0 | CO_CRSTAT | ||||||||||
| ANDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||||||
| ANUZT | Time when the record was created | TIMS | 6 | 0 | ANUZT | ||||||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||||
| KTXT | Description | CHAR | 40 | 0 | AUFTEXT | ||||||||||
| MATNR | Material Number for Order | CHAR | 40 | 0 | MARA | PI_MATNR | |||||||||
| MATXT | Material Description | CHAR | 40 | 0 | PI_MATXT | ||||||||||
| PRUEFLOS | Inspection Lot Number | NUMC | 12 | 0 | QALS | PI_QPLOS | |||||||||
| ERRKZ | Processing Status of the Process Message/the Control Recipe | CHAR | 1 | 0 | CO_ERRKZ | ||||||||||
| ARFCIPID | Host ID (IP ID | CHAR | 8 | 0 | ARFCIPID | ||||||||||
| ARFCPID | Process ID | CHAR | 4 | 0 | ARFCPID | ||||||||||
| ARFCTIME | Time Stamp | CHAR | 8 | 0 | ARFCTIME | ||||||||||
| ARFCTIDCNT | Transaction ID (LUW -> COMMIT WORK) | CHAR | 4 | 0 | ARFCTIDCNT | ||||||||||
| EXSTAT | Execution Status of a Control Recipe | CHAR | 5 | 0 | CO_EXSTAT | ||||||||||
| CHARG | Batch Number | CHAR | 10 | 0 | CHARG_D | ||||||||||
| FSAVD | Earliest scheduled start: Execution (date) | DATS | 8 | 0 | FSAVD | ||||||||||
| FSAVZ | Earliest scheduled start: Execution (time) | TIMS | 6 | 0 | FSAVZ | ||||||||||
| DECNTRL_PRC | Indicator for Decentralized Control Recipe Execution | CHAR | 1 | 0 | DECNTRL_PRC | ||||||||||
| XS_ID | XSteps: Unique ID of a Node | CHAR | 22 | 0 | CMX_CR_XS_GUID | ||||||||||
| HTML_MODE | HTML Mode | CHAR | 10 | 0 | CMX_BFW_HTML_MODE |
COCH foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 COCH | MANDT | T000 | Clients | MANDT |
| 1 COCH | MATNR | MARA | General Material Data | MANDT |
| 1 COCH | MATNR | MARA | General Material Data | MATNR |
| 0 COCH | PHSEQ | TC52 | Control Recipe Destinations | MANDT |
| 0 COCH | PHSEQ | TC52 | Control Recipe Destinations | WERKS |
| 1 COCH | PRUEFLOS | QALS | Inspection lot record | MANDANT |
| 0 COCH | WERK | T001W | Plants/Branches | WERKS |