SAP ARCH_USR Customizing Table for Archiving Table data and field list

ARCH_USR is a standard SAP Table which is used to store Customizing Table for Archiving data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ARCH_USR table consists of various fields, each holding specific information or linking keys about Customizing Table for Archiving data available in SAP. These include FILENAME (Logical file name), ARCH_CNTRL (Control field for delete programs in archiving), ARCH_LINK (Automatic Storage of Archive Files in Storage System), ARCH_SIZE (Maximum Size of an Archive File in Megabyte)... 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. .

ARCH_USR table Technical Details:

Delivery Class: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ARCH_USR table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ARCH_USR table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OBJECTArchiving Object OBJCT_TR01CHAR10ARCH_OBJOBJCT_TR01OBT
FILENAMELogical file name FILEINTERNCHAR60FILENAMECIFILEINTERN
ARCH_CNTRLControl field for delete programs in archiving ARCH_CNTRLCHAR10CHAR10
ARCH_LINKAutomatic Storage of Archive Files in Storage System ARCH_LINKCHAR1X
ARCH_SIZEMaximum Size of an Archive File in Megabyte ARCH_SIZEINT410U_INT_4
ARCH_COUNTMaximum Number of Objects Allowed in an Archive File ARCH_COUNTINT410U_INT_4
ARCH_DELAutomatic Start of Delete Program ARCH_DELCHAR1X
ARCH_COMITNumber of Data Objects Per Commit in Program ARCH_COMITINT410
ARCH_LDOCUDocument type SAEOBJARTCHAR10TOADVSADC10_DVDOK
ADMI_JOBSYTarget system on which the archive job should run ADMI_JOBSYCHAR32TEXT32
DELETE_SYSFlag: Delete jobs distributed freely in network ADMI_DELSYCHAR1X
PROD_VARIAVariant of Program for Production Mode ARCH_VPRODCHAR14Assigned to domainVARIANT
TEST_VARIAVariant of Program for Test Mode ARCH_VTESTCHAR14Assigned to domainVARIANT
ARCH_INDEXIndicates Whether an Index is to be Built for Data Objects ARCH_INDEXCHAR1X
ARCH_LASTAutomatic post-processing flag ARCH_LASTCHAR1CHAR1
LAST_VARIAVariant for the Post Processing Program ARCH_LPRODCHAR14Assigned to domainVARIANT
CREPStorage Repository for Physical Objects SCMS_CREPCHAR30V_CREP_ALSCMS_CREP
STORE_FRSTIndicates Whether Storing File Takes Place Before Delete ARCH_STORECHAR1X
READARCSYSIndicates Whether Delete Program Reads from Storage System ARCH_READCHAR1X
BTCEVENTIDBackground Processing Event BTCEVENTIDCHAR32CHAR32
BTCEVTPARMBackground Event Parameters (Such as, Jobname/Jobcount) BTCEVTPARMCHAR64TEXT64
DEL_EVENTEvent-Driven Start of Delete Job ARCH_D_EVTCHAR1X
DEL_REPLACEDAutomatic Destruction of Replaced Files ARCH_DEL_REPLACEDCHAR1BOOLE
RESPONSIBLEPerson Responsible for Performing Archiving ARCH_RESPONSIBLECHAR12USR02XUBNAME

Key field Non-key field



How do I retrieve data from SAP table ARCH_USR using ABAP code

The following ABAP code Example will allow you to do a basic selection on ARCH_USR to SELECT all data from the table
DATA: WA_ARCH_USR TYPE ARCH_USR.

SELECT SINGLE *
FROM ARCH_USR
INTO CORRESPONDING FIELDS OF WA_ARCH_USR
WHERE...

How to access SAP table ARCH_USR

Within an ECC or HANA version of SAP you can also view further information about ARCH_USR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).