SAP table COCHP (PI sheet: Control Recipe Header)
SAP table COCHP 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 | PI sheet (process instruction sheet) | NUMC | 18 | 0 | PI_CRID | ||||||||||||||||
| WERK | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||||||||
| BID | Process order number | CHAR | 12 | 0 | AUFK | CO_BORD | |||||||||||||||
| PHSEQ | Control Recipe Destination | CHAR | 2 | 0 | TC52 | PHSEQ | |||||||||||||||
| ADRES | Processor or Processor Group for a PI sheet | CHAR | 32 | 0 | CO_PI_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 | Status of the PI sheet | CHAR | 5 | 0 | CO_PISTAT |
|
|||||||||||||||
| ANDAT | Creation date of the PI sheet | DATS | 8 | 0 | CO_ANDAT | ||||||||||||||||
| ANUZT | Time when the record was created | TIMS | 6 | 0 | ANUZT | ||||||||||||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||||||||||
| COM_NAME | Name | CHAR | 70 | 0 | TDOBNAME | ||||||||||||||||
| S_STARO | Top Displayed List Line | INT4 | 10 | 0 | SYSTARO | ||||||||||||||||
| S_STACO | First List Column Displayed | INT4 | 10 | 0 | SYSTACO | ||||||||||||||||
| S_CPAGE | Page Number of List | INT4 | 10 | 0 | SYCPAGE | ||||||||||||||||
| 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 | |||||||||||||||
| VIS_VORNR | Operation/Activity Number | CHAR | 4 | 0 | VORNR |
COCHP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 COCHP | BID | AUFK | Order master data | AUFNR |
| 1 COCHP | MANDT | T000 | Clients | MANDT |
| 0 COCHP | MATNR | MARA | General Material Data | MANDT |
| 0 COCHP | MATNR | MARA | General Material Data | MATNR |
| 1 COCHP | PHSEQ | TC52 | Control Recipe Destinations | MANDT |
| 1 COCHP | PHSEQ | TC52 | Control Recipe Destinations | WERKS |
| 0 COCHP | PRUEFLOS | QALS | Inspection lot record | MANDANT |
| 1 COCHP | WERK | T001W | Plants/Branches | WERKS |