POC_DB_ARC_CONN

Optical Archiving: Link Data (ArchiveLink) | #masterdata | Component: Browser-Based PI Sheet / Cockpit
Column Name Description
MANDT Client
CRID FK PI sheet (process instruction sheet)
ACONNID Index of shadow table for link to archive
Column Name Description
Column Name Description
Column Name Description
DATE_CREA Date on which the record was created
TIME_CREA Time when the record was created
ORDER_DATE_CREA Date on which the record was created
ARCH_DATE Date on which the record was created
ARCH_TIME Time at Which Record Was Added
Column Name Description
ORDER_TYPE Order category Show values
ON_DB Database Data for PI Sheet/Work Instructions Exists Show values
TSTKZ Indicator: Message or Control Recipe for Test Purposes Show values
HTML_MODE HTML Mode Show values
Column Name Description Domain name
OBJECT_ID SAP ArchiveLink: Object ID (object identifier) SADC50
OBJECT_TYPE SAP ArchiveLink: Object type of business object OJ_NAME
DOC_TYPE Document type SADC10_DV
PLANT Plant WERKS
ORDER_NUMBER Order Number AUFNR
ORDER_TXT Description TEXT40
ADRES Processor or Processor Group for a PI sheet CHAR32
BATCH Batch Number CHARG
CONNTXT Optical Archiving: Short Text for Archive Link CONNTXT
USER_NAM_FIRST First name XUNAME1
USER_NAM_LAST Last Name XUNAME1
Master Data Relations Join Conditions
User Name in User Master Record
  • POC_DB_ARC_CONN.MANDT == USR02.MANDT
  • POC_DB_ARC_CONN.ARCH_USER == USR02.BNAME
Material Number for Order
  • Material Number for Order
  • Client
  • POC_DB_ARC_CONN.MATERIAL == MARA.MATNR
  • POC_DB_ARC_CONN.MANDT == MARA.MANDT
Order Type
  • POC_DB_ARC_CONN.MANDT == T003O.CLIENT
  • POC_DB_ARC_CONN.ORDER_CAT == T003O.AUART
Other Relations | to Master Data Relations ↑ Join Conditions
Control Recipe Destination
  • Control Recipe Destination
  • Plant
  • POC_DB_ARC_CONN.MANDT == TC52.MANDT
  • POC_DB_ARC_CONN.PHSEQ == TC52.PHSEQ
  • POC_DB_ARC_CONN.PLANT == TC52.WERKS