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".

Fields for table POC_DB_ARC_CONN

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
CRIDPI sheet (process instruction sheet)XPI_CRIDNUMC36COCHP
ACONNIDIndex of shadow table for link to archiveXACONNIDNUMC40
OBJECT_IDSAP ArchiveLink: Object ID (object identifier)SAEOBJIDCHAR100
OBJECT_TYPESAP ArchiveLink: Object type of business objectSAEANWDIDCHAR20
DOC_TYPEDocument typeSAEOBJARTCHAR20
DATE_CREADate on which the record was createdERDATDATS16
TIME_CREATime when the record was createdANUZTTIMS12
PLANTPlantWERKS_DCHAR8
ORDER_NUMBEROrder NumberAUFNRCHAR24
ORDER_CATOrder TypeAUFARTCHAR8T003O
ORDER_TYPEOrder categoryAUFTYPNUMC4
ORDER_TXTDescriptionAUFTEXTCHAR80
ORDER_DATE_CREADate on which the record was createdERDATDATS16
PHSEQControl Recipe DestinationPHSEQCHAR4TC52
ADRESProcessor or Processor Group for a PI sheetCO_PI_ADRCHAR64
MATERIALMaterial Number for OrderPI_MATNRCHAR80MARA
BATCHBatch NumberCHARG_DCHAR20
CONNTXTOptical Archiving: Short Text for Archive LinkPOC_CONNTXTCHAR100
ARCH_USERUser Name in User Master RecordXUBNAMECHAR24USR02
USER_NAM_FIRSTFirst nameXUPREVNAMECHAR60
USER_NAM_LASTLast NameXUFAMNAMECHAR60
ARCH_DATEDate on which the record was createdERDATDATS16
ARCH_TIMETime at Which Record Was AddedERZEITTIMS12
ON_DBDatabase Data for PI Sheet/Work Instructions ExistsPOC_ON_DBCHAR2
TSTKZIndicator: Message or Control Recipe for Test PurposesTSTKZCHAR2
.INCLUDEBFWCMX_BFW_S_EXT0
HTML_MODEHTML ModeCMX_BFW_HTML_MODECHAR20
Privacy Policy