POC_DB_ARC_CONN - Optical Archiving: Link Data (ArchiveLink)
Optical Archiving: Link Data (ArchiveLink) information is stored in SAP table POC_DB_ARC_CONN.
It is part of development package CMX_POC in software component PP-PI-PMA-PMC. This development package consists of objects that can be grouped under "Manufacturing Execution: Browser-Based PI Sheet".
It is part of development package CMX_POC in software component PP-PI-PMA-PMC. This development package consists of objects that can be grouped under "Manufacturing Execution: Browser-Based PI Sheet".
Fields for table POC_DB_ARC_CONN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| CRID | PI sheet (process instruction sheet) | X | PI_CRID | NUMC | 36 | COCHP |
| ACONNID | Index of shadow table for link to archive | X | ACONNID | NUMC | 40 | |
| OBJECT_ID | SAP ArchiveLink: Object ID (object identifier) | SAEOBJID | CHAR | 100 | ||
| OBJECT_TYPE | SAP ArchiveLink: Object type of business object | SAEANWDID | CHAR | 20 | ||
| DOC_TYPE | Document type | SAEOBJART | CHAR | 20 | ||
| DATE_CREA | Date on which the record was created | ERDAT | DATS | 16 | ||
| TIME_CREA | Time when the record was created | ANUZT | TIMS | 12 | ||
| PLANT | Plant | WERKS_D | CHAR | 8 | ||
| ORDER_NUMBER | Order Number | AUFNR | CHAR | 24 | ||
| ORDER_CAT | Order Type | AUFART | CHAR | 8 | T003O | |
| ORDER_TYPE | Order category | AUFTYP | NUMC | 4 | ||
| ORDER_TXT | Description | AUFTEXT | CHAR | 80 | ||
| ORDER_DATE_CREA | Date on which the record was created | ERDAT | DATS | 16 | ||
| PHSEQ | Control Recipe Destination | PHSEQ | CHAR | 4 | TC52 | |
| ADRES | Processor or Processor Group for a PI sheet | CO_PI_ADR | CHAR | 64 | ||
| MATERIAL | Material Number for Order | PI_MATNR | CHAR | 80 | MARA | |
| BATCH | Batch Number | CHARG_D | CHAR | 20 | ||
| CONNTXT | Optical Archiving: Short Text for Archive Link | POC_CONNTXT | CHAR | 100 | ||
| ARCH_USER | User Name in User Master Record | XUBNAME | CHAR | 24 | USR02 | |
| USER_NAM_FIRST | First name | XUPREVNAME | CHAR | 60 | ||
| USER_NAM_LAST | Last Name | XUFAMNAME | CHAR | 60 | ||
| ARCH_DATE | Date on which the record was created | ERDAT | DATS | 16 | ||
| ARCH_TIME | Time at Which Record Was Added | ERZEIT | TIMS | 12 | ||
| ON_DB | Database Data for PI Sheet/Work Instructions Exists | POC_ON_DB | CHAR | 2 | ||
| TSTKZ | Indicator: Message or Control Recipe for Test Purposes | TSTKZ | CHAR | 2 | ||
| .INCLUDE | BFW | CMX_BFW_S_EXT | 0 | |||
| HTML_MODE | HTML Mode | CMX_BFW_HTML_MODE | CHAR | 20 |