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 |