SAP ABAP Table POC_DB_ARC_CONN (Optical Archiving: Link Data (ArchiveLink))

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PP-PI-PMA-PMC (Application Component) Browser-Based PI Sheet / Cockpit
     ⤷ CMX_POC (Package) Manufacturing Execution: Browser-Based PI Sheet

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	POC_DB_ARC_CONN	Table Relationship Diagram
Short Description	Optical Archiving: Link Data (ArchiveLink)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	CRID	☑	PI_CRID	PI_CRID	NUMC	18	0	PI sheet (process instruction sheet)	COCHP
3	ACONNID	☑	ACONNID	ACONNID	NUMC	20	0	Index of shadow table for link to archive
4	OBJECT_ID	☐	SAEOBJID	SADC50	CHAR	50	0	SAP ArchiveLink: Object ID (object identifier)
5	OBJECT_TYPE	☐	SAEANWDID	OJ_NAME	CHAR	10	0	SAP ArchiveLink: Object type of business object	*
6	DOC_TYPE	☐	SAEOBJART	SADC10_DV	CHAR	10	0	Document type	*
7	DATE_CREA	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	TIME_CREA	☐	ANUZT	UZEIT	TIMS	6	0	Time when the record was created
9	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
10	ORDER_NUMBER	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
11	ORDER_CAT	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
12	ORDER_TYPE	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
13	ORDER_TXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
14	ORDER_DATE_CREA	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
15	PHSEQ	☐	PHSEQ	PHSEQ	CHAR	2	0	Control Recipe Destination	TC52
16	ADRES	☐	CO_PI_ADR	CHAR32	CHAR	32	0	Operator or group of operators processing a PI sheet
17	MATERIAL	☐	PI_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
18	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
19	CONNTXT	☐	POC_CONNTXT	CONNTXT	CHAR	50	0	Optical Archiving: Short Text for Archive Link
20	ARCH_USER	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
21	USER_NAM_FIRST	☐	XUPREVNAME	XUNAME1	CHAR	30	0	First name
22	USER_NAM_LAST	☐	XUFAMNAME	XUNAME1	CHAR	30	0	Last name
23	ARCH_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
24	ARCH_TIME	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
25	ON_DB	☐	POC_ON_DB	XFELD	CHAR	1	0	Database Data for PI Sheet/Work Instructions Exists
26	TSTKZ	☐	TSTKZ	FLAG	CHAR	1	0	Indicator: Message or Control Recipe for Test Purposes

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	POC_DB_ARC_CONN	ARCH_USER	USR02	BNAME
2	POC_DB_ARC_CONN	CRID	COCHP	CRID
3	POC_DB_ARC_CONN	MATERIAL	MARA	MATNR	REF
4	POC_DB_ARC_CONN	ORDER_CAT	T003O	AUART
5	POC_DB_ARC_CONN	PHSEQ	TC52	PHSEQ

History

Last changed by/on	SAP	20130529
SAP Release Created in	605