ARCH_IDX_PROT SAP table for – Index Table for Log Archiving for BI Authorizations

Here we would like to draw your attention to ARCH_IDX_PROT table in SAP. As we know it is being mainly used with the SAP BW-BEX (Business Explorer in BW) component which is coming under BW module (Business Warehouse). ARCH_IDX_PROT is a SAP standard transp table used for storing Index Table for Log Archiving for BI Authorizations related data in SAP. It comes under the package RSEC.

SAP ARCH_IDX_PROT table

Table ARCH_IDX_PROT technical data

TableARCH_IDX_PROT
Data storingIndex Table for Log Archiving for BI Authorizations
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSEC
Delivery ClassL – Table for storing temporary data
ComponentSAP_BW
Table CategoryTRANSP

SAP ARCH_IDX_PROT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ARCH_IDX_PROT table.

  • BNAME : User Name in User Master Record
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • RNAME : User Name in User Master Record
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • TIMESTMP : UTC time stamp in short form (YYYYMMDDhhmmss) + conv.exit
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SESSIONID : UUID in character form
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • ARCHIVEKEY : Key for Archive File
    Its data type is CHAR (Character String) with field length 20
  • OBJ_OFFSET : Archive file data object offset
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10