Mastering SAP Data: A Comprehensive Guide to Archiving & ILM T-Codes
In today's data-driven world, efficient management of SAP data is paramount for system performance, cost optimization, and regulatory compliance. Understanding the key transaction codes (T-codes) is your gateway to mastering SAP data archiving and Information Lifecycle Management (ILM).
This post compiles and categorizes essential SAP T-codes directly from expert guides, offering a functional overview to help you navigate your SAP data journey.
Understanding SAP T-Code Categories
We've grouped the T-codes based on their primary function to provide a clearer landscape of how they contribute to your data strategy:
1. Core Archiving Operations (Execution & Management)
| T-code | Description |
|---|---|
| AOBJ | Configures and manages archiving objects. |
| SARA | Central transaction for all core data archiving activities. |
| FILE | Defines logical/physical file paths for archive files. |
| SF01 | Defines client-dependent file names for archiving. |
| SARJ | Configures and activates archive infostructures (indexes for retrieval). |
2. Data Analysis & Monitoring (Pre-Archiving)
| T-code | Description |
|---|---|
| DB02 | Monitors database and table sizes for archiving candidate identification. |
| TAANA | Performs table analyses for data distribution and archiving strategy planning. |
| DB15 | Determines archiving objects linked to specific tables. |
| DBACOCKPIT | Broader database management, integrating DB02 functions. |
| TAANA_AV | Manages analysis variants for TAANA. |
| TAANA_VF | Includes virtual fields in TAANA analyses. |
3. Archived Data Access & Display
| T-code | Description |
|---|---|
| SARI | Accesses Archive Information System (AIS) for archived data display. |
| SARE | Launches Archive Explorer for displaying archived data. |
| ALO1 | Accesses the Document Relationship Browser (DRB) for linked documents. |
| AS_AFB | Calls Archive File Browser to search archive files by document number. |
| OA_FIND_ARCHIVE_DATA | Searches for archived documents via ArchiveLink. |
| SCU3 | Displays table history, including archived data. |
| SLG1 | Displays application logs, relevant to archiving runs. |
| SWW_ARCHIV | Displays workflows from the archive. |
4. ILM Specific (General Retention & Data Aging)
| T-code | Description |
|---|---|
| ILM_WORK_CENTER | Central hub for all ILM activities: retention, data aging, destruction. |
| ILM_CUST | Customizes general SAP ILM aspects: retention policies, legal holds. |
| IRM_CUST | Customizes Information Retention Manager; defines retention rules. |
| IRM_CUST_BS | Customizes Information Retention Manager for Business Suite adaptations. |
| IRMPOL | Defines retention/residence rules within Information Retention Manager. |
| SCASE | Legal Case Management: creates/manages legal cases and holds. |
| ILMSIM | Simulates ILM rule implementation for testing. |
| ILM_DESTRUCTION | Permanently deletes data meeting retention periods. |
| ILM_LH_AL | Propagates legal holds for ArchiveLink documents. |
| AS_ILM_BUPA_DA_WP | Accesses the Business Partner Data Aging Worklist. |
| DAGOBJ | Manages Data Aging Objects. |
| DAGPTC | Customizes partitioning in data aging. |
| DAGPTM | Manages partitions in data aging. |
| DAGRUN | Provides overview of data aging runs. |
| DAGADM | Manages Data Aging Objects (administrative view). |
| DAGLOG | Displays data aging logs. |
| ILM | Menu transaction for various ILM-related T-codes. |
| ILM_C_RAOB | Manages retention archiving objects via ILM menu. |
| ILM_C_RAOB_TAB | Manages retention archiving objects at table level via ILM menu. |
| ILM_C_SOEX | Relates to source object existence checks via ILM menu. |
| ILM_C_OBJECTS | Manages ILM objects via ILM menu. |
| ILM_C_CON | Manages ILM context objects via ILM menu. |
| ILM_C_C_CON | Manages ILM context objects via ILM menu. |
| ILM_C_STRC | Manages ILM structures via ILM menu. |
| ILM_C_APPL | Manages ILM applications via ILM menu. |
| ILM_C_RELA | Manages ILM relationships via ILM menu. |
| ILMAPT | Processes Audit Package Templates. |
| ILMARA | Processes Audit Areas. |
| ILMCHECK | Defines and executes checksums for data integrity. |
| IWP01 | Handles Audit Packages. |
| IWP_WP_GENERATE | (Program/Internal) Generates an audit package. |
| IWP_QUERY_EXPORT | (Program/Internal) Exports query results from audit packages. |
| IWP_VIEWLOG | (Program/Internal) Displays available view files for audit packages. |
5. System Decommissioning (with ILM Retention Warehouse)
| T-code | Description |
|---|---|
| LTRC | Manages data replication from legacy systems to Retention Warehouse. |
| ILM_DATA_TRANSFER_RUN | Manages transfer of archived data to ILM Retention Warehouse. |
| ILM_TRANS_ADMIN | Transfers archive administration data/files between systems. |
6. Document & Content Repository Management (ArchiveLink)
| T-code | Description |
|---|---|
| OAC0 | Creates/maintains content repositories. |
| OAC2 | Specifies/maintains document types/classes for ArchiveLink. |
| OAC3 | Links SAP objects to documents for ArchiveLink. |
| OAD2 | (Appendix A.4) SAP ArchiveLink Document Types Global. |
7. DART (Data Retention Tool)
| T-code | Description |
|---|---|
| FTW0 | Main transaction for DART area menu. |
| FTW1A | ExtracTs tax-relevant data using DART. |
| FTWK | Deletes DART extracts. |
| FTWF | Data Extract Browser: displays/manages DART extracts. |
| FTWH | Displays Data Extract Views for auditors. |
| FTWL | Displays extract log for DART. |
| FTWN | Displays view log for DART extracts. |
| FTWE | Verifies FI Control Totals in DART extract. |
| FTWE1 | Verifies all FI Control Totals in DART extract. |
| FTWD | Verifies Data Checksums in DART extract. |
| FTWP | Configures DART extraction scope/storage. |
| FTWQ | Configures data segments for DART extraction. |
| FTWY | Defines data extract views for DART. |
| FTWC | (DART menu transaction) DART configuration. |
| FTWM | (DART menu transaction) DART management. |
| FTWES | (DART menu transaction) DART extractions/settings. |
| FTWAD | DART's Associated Data Detector. |
| FTWCS | (DART menu transaction) DART Customizing. |
| FTWCF | (DART menu transaction) DART Customizing. |
| FTWESL | (DART menu transaction) DART extract log or status. |
| FTWW | (DART menu transaction) DART processing. |
| FTWI | (DART menu transaction) DART information. |
| FTWYR | (DART menu transaction) DART view reports. |
| FTWSCC | Configures DART settings for company codes. |
8. Application-Specific Display & Processing (Interacting with Archived Data)
| T-code | Description |
|---|---|
| VL03N | Displays outbound deliveries and can be used to access archived data. |
| VL33N | Displays inbound deliveries and can be used to access archived data. |
| VA03 | Displays sales orders and can be configured for direct access to archived data. |
| VF07 | Specifically used to display archived billing documents directly from the archive. |
| ME53N | Displays purchase requisitions (data candidate for archiving). |
| ME23N | Displays purchase orders (data candidate for archiving). |
| IW63 | Displays historical Plant Maintenance (PM) orders from the archive. |
| VELOARDI | Displays archived vehicles from the Vehicle Management System. |
| EA22 | Displays settlement documents in SAP IS-U (Industry-Specific Solution Utilities). |
| EA40 | Displays print documents in SAP IS-U. |
| EA63 | Displays budget billing plans in SAP IS-U. |
| FPL3 | Displays documents in Contract Accounts Receivable and Payable (FI-CA). |
| FPL9 | Displays account balances in Contract Accounts Receivable and Payable (FI-CA). |
| LT21 | Displays transfer orders in Warehouse Management (WM). |
| LT22 | Displays transfer orders for a storage type in WM. |
| LT23 | Displays a list of resident transfer orders in WM. |
| LT24 | Displays transfer orders for a material in WM. |
| LT25 | Displays transfer orders for each group in WM. |
| LT26 | Displays transfer orders for a storage bin in WM. |
| LT27 | Displays transfer orders for a storage unit in WM. |
| LT31 | Prints transfer orders in WM. |
| WE02 | Displays a list of IDocs (Intermediate Documents). |
| WE09 | Searches IDocs by business content. |
| MIGO | Used for goods movements. |
| MB51 | Displays a list of material documents. |
| MB03 | Displays a single material document. |
| COR3 | Displays process orders. |
9. General System & Security Administration
| T-code | Description |
|---|---|
| SPRO | The main Customizing transaction for configuring various aspects of SAP. |
| SE16 | The Data Browser, used for displaying table contents directly. |
| PFCG | Manages roles and authorizations within SAP security. |
| SUIM | The User Information System, used for checking user authorizations and roles. |
| SM37 | Monitors background jobs, including archiving runs. |
| SPAM | The Support Package Manager, used for managing support packages. |
| STRUST | The Trust Manager, manages security certificates. |
| SMICM | The ICM Monitor (Internet Communication Manager), monitors and restarts the ICM. |
| OIOA | (Appendix A.2) Plant Maintenance Order Types. (Context limited to name only). |
Ready to Optimize Your SAP Data Management?
At SAPIXOS Archiving Solution, we specialize in helping businesses like yours master SAP data archiving and ILM for enhanced performance and compliance. Our experts can guide you through implementing effective strategies tailored to your unique needs.
For more discussion, or inquiries about **training and internship opportunities**, please contact us directly: [email protected].