POC_DB_ARC_CONN SAP (Optical Archiving: Link Data (ArchiveLink)) Table details
Description: Optical Archiving: Link Data (ArchiveLink)
Related tables to POC_DB_ARC_CONN
Access table POC_DB_ARC_CONN
Table field list including key, data, relationships and ABAP select examples
POC_DB_ARC_CONN is a standard SAP Table which is used to store Optical Archiving: Link Data (ArchiveLink) data and is available within R/3 SAP systems depending on the version and release level.
The POC_DB_ARC_CONN table consists of various fields, each holding specific information or linking keys about Optical Archiving: Link Data (ArchiveLink) data available in SAP. These include CRID (PI sheet (process instruction sheet)), ACONNID (Index of shadow table for link to archive), OBJECT_ID (SAP ArchiveLink: Object ID (object identifier)), OBJECT_TYPE (SAP ArchiveLink: Object type of business object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP POC_DB_ARC_CONN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
CRID | PI sheet (process instruction sheet) | PI_CRID | NUMC | 18 | COCHP | PI_CRID | PVL | ||
ACONNID | Index of shadow table for link to archive | ACONNID | NUMC | 20 | ACONNID | ||||
OBJECT_ID | SAP ArchiveLink: Object ID (object identifier) | SAEOBJID | CHAR | 50 | SADC50 | ||||
OBJECT_TYPE | SAP ArchiveLink: Object type of business object | SAEANWDID | CHAR | 10 | Assigned to domain | OJ_NAME | OAO | ||
DOC_TYPE | Document type | SAEOBJART | CHAR | 10 | Assigned to domain | SADC10_DV | DOK | ||
DATE_CREA | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
TIME_CREA | Time when the record was created | ANUZT | TIMS | 6 | UZEIT | ||||
PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ORDER_NUMBER | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
ORDER_CAT | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
ORDER_TYPE | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
ORDER_TXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
ORDER_DATE_CREA | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
PHSEQ | Control Recipe Destination | PHSEQ | CHAR | 2 | TC52 | PHSEQ | |||
ADRES | Operator or group of operators processing a PI sheet | CO_PI_ADR | CHAR | 32 | CHAR32 | ||||
MATERIAL | Material Number for Order | PI_MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
BATCH | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
CONNTXT | Optical Archiving: Short Text for Archive Link | POC_CONNTXT | CHAR | 50 | CONNTXT | ||||
ARCH_USER | User Name in User Master Record | XUBNAME | CHAR | 12 | USR02 | XUBNAME | XUS | ||
USER_NAM_FIRST | First name | XUPREVNAME | CHAR | 30 | XUNAME1 | ||||
USER_NAM_LAST | Last name | XUFAMNAME | CHAR | 30 | XUNAME1 | ||||
ARCH_DATE | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ARCH_TIME | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
ON_DB | Database Data for PI Sheet/Work Instructions Exists | POC_ON_DB | CHAR | 1 | XFELD | ||||
TSTKZ | Indicator: Message or Control Recipe for Test Purposes | TSTKZ | CHAR | 1 | FLAG |
Key field | Non-key field |
How do I retrieve data from SAP table POC_DB_ARC_CONN using ABAP code
The following ABAP code Example will allow you to do a basic selection on POC_DB_ARC_CONN to SELECT all data from the tableDATA: WA_POC_DB_ARC_CONN TYPE POC_DB_ARC_CONN.
SELECT SINGLE *
FROM POC_DB_ARC_CONN
INTO CORRESPONDING FIELDS OF WA_POC_DB_ARC_CONN
WHERE...
How to access SAP table POC_DB_ARC_CONN
Within an ECC or HANA version of SAP you can also view further information about POC_DB_ARC_CONN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects