Skip to Content
Technical Articles

Preparatory Know-How for SAP Data Archiving

Preparatory Know-How for SAP Data Archiving

In this blog post I will share with you some of the key knowledge aspects which you need to know to address the queries being raised by clients before they plan to proceed with archiving, as data archiving is a grey area for many stakeholders we work with and mostly the area of concern for them is whether the archived data will be safe outside SAP and how convenient it is for the business users and auditors to be able to access the archived data.

Questions Answers

Which data should be Archived?

 

This question is best answered by asking which data should not be archived. Storing application data in archives is not the equivalent to having data in the database. Applications are designed for accesses to the database and therefore all data that is needed for operation by the applications belongs in the database.
When should application data be archived?

Application data should only be archived when the following criteria has been fulfilled:

•        It is no longer needed in any transactions or processes, such as for completing the annual balance sheet.

•        It does not have to be changed anymore.

•        The data probably does not have to be displayed very often anymore.

Before you start archiving make sure you fulfill all documentation requirements

Is data archiving enough for auditing purposes?

Data archiving was not designed as a tax and audit tool. It can support you in meeting the requirements of tax authorities, by conserving data and making it available over a longer period of time.

During an audit it is also possible to access archived data, in case more detailed information is needed that does not appear in the other documents you previously created. Archived data should only be included in the auditing process if additional data is requested for the audit. To make the auditing process easier you should try to meet all requirements during the time the data is still in the database.

When is data archiving beneficial?

Archiving application data is beneficial when the effort spent on maintaining your database is becoming too expensive and when, at the same time, you can store and manage the archived data without spending huge amounts of money.

If the costs of accessing the archived data grow higher than the costs of storing and managing the data in the database, then the data should remain in the database. If you are weighing the costs of using data archiving, possibly to avoid having to purchase a new, more powerful database server, you should also include the costs of accessing the archived data in your calculation.

What status does archived data have? Archived data cannot be modified and can therefore no longer be used in the processes of current business operations. It is inseparable from the system in which it was created and can only be accessed and interpreted from this system. If you need historical data for informational purposes, you can read access the archived data. However, because this data has been stored away from any changes in the system (for example reorganization), it cannot be guaranteed that its contents and structure match the context currently being used. Moreover, some archiving objects only offer a very restricted access to archived data – for example only with single document displays or evaluations.
Can archived data be reloaded into the database?

From a technical standpoint, archived data can be reloaded into the database. However, because we are dealing with historical data, which has not been part of any changes in the database, you run the risk of generating inconsistencies in your database. Therefore we always discourage the reloading of data back into the database.

An exception would be if you reload archived data immediately after it has been archived. A reload of this kind would be an emergency measure after a failed or unsuccessful archiving session, because, for example, you archived the wrong data due to an error in the Customizing settings. Reloading is only possible with some archiving objects.

When should you start archiving your data?

You should begin with data archiving before it is too late and you have exhausted all the alternative measures for improving the condition of your system. This includes planning how big your system needs to be based on your anticipated data volume (sizing), and determining the residence times of your data. The latter point refers to the amount of time the data must remain in the database. You should also identify and fulfill any audit requirements before you begin archiving your data.

Always keep in mind that data archiving slows down the growth of your database. It cannot stop the growth completely. Therefore the goal of data archiving is to keep your system under control over a long period of time, not to return your system to a controllable state.

Is archived data Release- and Platform-Independent? (means can data archived in lower SAP release be accessed to higher SAP release or post upgrade to higher SAP Release?) Yes, data archived in lower version can be easily access on post upgrade on the higher version of SAP. Thus, SAP data archiving is able to ensure the release- and platform-independence of that data.
Is it possible to view/retrieve documents which has no format changed? You can access your archived data with additional changes in few standard and  all custom reports after upgrade or migration.
How Schema adjustment is addressed with the old archived data? If the archived tables and structures have been changed with respect to their original definition in the ABAP dictionary, a schema adjustment has to be made. The structural changes, however, must ensure compatibility of the structure components. This is accomplished by using the same semantics as in the ABAP command MOVE-CORRESPONDING. This means that structural components that did not exist when the data was archived are returned with initial values, and components that are no longer used after the upgrade are not output. If components have the same name then the usual ABAP conversion rules between the different data types apply.
How is Platform adjustment taken care in case of old archived data? If the CODEPAGE or number format have changed, a platform adjustment has to be made. When archive files that originated in a non-Unicode system are being read in a Unicode system, a CODEPAGE conversion always takes place for the character-like data.
Archiving in Online Mode? An archiving session, made up of write and delete jobs, can take place while the system is online, meaning that users can continue to use the system while data is being archived. However, you may encounter performance bottlenecks if tables from which data is being deleted are also accessed in online business processes. Therefore it is recommended that you archive during times of low user activity in your system.
Does data get compressed during archiving process? During data archiving, data is compressed by up to a factor of 5. Data that is saved in cluster tables is not compressed any further. Through the compression, the archive files occupy as little space as possible on the storage system.
How is Data Security ensured by the archiving process?

To ensure that no data is lost due to errors during the archiving session, the data archiving process consists of two steps.

In the first step the data is written to the archive files.

In the second step the data is removed from the database. However, this only takes place after the archive file has been written and read successfully. This process helps detect any errors that may have occurred when the data was transferred from the database to the archive file via the network. If an error occurred you can set up a new archiving session, because the data is either still located in the database or in an archive file.

SAP Tables under Archiving Objects

Here I will show you the list of table which is considered for archiving and under which archiving object you can find these tables.

Have listed the following archiving objects and tables based on my working experience moreover you can find additional archiving objects as per your requirement and application area.

  1. When you use the archiving object FI_DOCUMNT, the system archives data from the following tables
Objects in Financial Accounting Archiving Objects
Accounting Document FI_DOCUMNT

 

Table Description
WITH_ITEM Witholding tax info per W/tax type and FI line item
BFO_A_RA Versions for Resetting Cleared Items
FAGL_BSBW_HISTRY Valuation History for Documents
RF048 Subseq.BA/PC Adjustmnt: Index/Distributn Vector (Calculate)
STXL STXD SAPscript text file lines
STXH STXD SAPscript text file header
FAGL_SPLINFO Splittling Information of Open Items
FAGL_SPLINFO_VAL Splitting Information of Open Item Values
BSIM Secondary Index, Documents for Material
STXB SAPscript: Texts in non-SAPscript format
BVOR Intercompany posting procedures
BSIP Index for Vendor Validation of Double Documents
FAGLFLEXA General Ledger: Actual Line Items
FIGLDOC G/L accounting: Subsequent derivations
FDM_DCOBJ FSCM-DM Integration: Disputed Objects
BFOK_A FI subsequent BA/PC adjustment: Vendor items
BFIT_A FI Subsequent BA/PC Adjustment: G/L Account Items
BFOD_A FI Subsequent BA/PC Adjustment: Customer Items
BFIT_A0 FI Subseq.BA/PC Adjustmnt: Zero Bal.Postings for Bus.Area
BFOD_AB FI Subseq.BA/PC Adjustmnt: Valuatn Diffrnce in Customer OIs
BFOK_AB FI subseq.BA/PC adjustmnt: Valuatn difference in vendor OIs
Table Description
TTXY External tax interface: tax information
TTXI External tax interface: index file
ETXDCI External tax document: line item info
ETXDCH External tax document: header info
ETXDCJ Ext. tax document: tax rates and amounts by Jurisdict. level
BSEG_ADD Entry View of Accounting Document for Additional Ledgers
BSEGC Document: Data on Payment Card Payments
BSBW Document Valuation Fields
BSE_CLR_ASGMT Doc. Segment Add. Data: Clearing Info with Acct Assignment
CDCLS Cluster structure for change documents
RFBLG Cluster for accounting document
AGKO Cleared Accounts
CDHDR Change document header
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
BSE_CLR Additional Data for Document Segment: Clearing Information
CDPOS_STR Additional Change Document – Table for STRINGs
BSAK Accounting: Secondary Index for Vendors (Cleared Items)
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items)
BSIS Accounting: Secondary Index for G/L Accounts
BSAD Accounting: Secondary Index for Customers (Cleared Items)
BKPF Accounting Document Header

Following is the correlation between Cluster and Index finance tables being captured in Archiving Objects

Archiving Object Cluster Table         Description                                                 Index tables Description                                                
FI_DOCUMNT CDCLS Cluster structure for change documents

CDPOS

PCDPOS

Change document items

Change document items

FI_DOCUMNT RFBLG Cluster for accounting document

BSEC

BSED

BSEG

BSES

BSET

One-Time Account Data Document Segment

Bill of Exchange Fields Document Segment

Accounting Document Segment

Document Control Data (Obsolete)

Tax Data Document Segment

  1. When you use the archiving object FI_SL_DATA, the system archives data from the following tables
Objects in Financial Accounting Archiving Objects
FI Special Ledger: Totals and Line Items FI_SL_DATA

 

Table Description
COFIP Single plan items for reconciliation ledger
COFIS Actual line items for reconciliation ledger
COFIT Totals Records for Reconciliation Ledger
ECMCA SAP Cons.: Journal Entry Table (Actual)
ECMCT SAP Cons.: Totals Table
EPIDXB Line item index for company code
EPIDXC Line item index for global company
FBICRC001A ICRC: Open Items GL Accounts: Documents
FBICRC001T ICRC: Open Items GL Accounts: Totals
FBICRC002A ICRC: GL Accounts: Documents
FBICRC002T ICRC: GL Accounts: Totals
FILCA FI-LC: Actual journal entry table with 2 object tables
FILCP FI-LC: Plan line items for object table
FILCT FI-LC: Global totals table with 2 object tables
FMIA Actual Line Item Table for Funds Management
FMIP Plan Line Items Table for Funds Management
FMIT Totals Table for Funds Management
FMUSFGA Actual line item table  for US Federal Government
FMUSFGFACTS1A Actual line item table
FMUSFGFACTS1P Plan line items table
FMUSFGFACTS1T Summary table
FMUSFGFACTS2A Actual line item table
FMUSFGFACTS2P Plan line items table
FMUSFGFACTS2T Summary  table
FMUSFGP Plan line items table
FMUSFGT Summary table   for US Federal Government
GLFLEXA Flexible general ledger: Actual line items
GLFLEXP Flexible G/L: Plan line items
GLFLEXT Flexible G/L: Totals
GLFUNCA Actual Line Items Table for Cost of Sales Accounting
GLFUNCP Plan Line Items Table for Cost of Sales Accounting
GLFUNCT Totals Table for Cost of Sales Accounting
GLIDXA Index to Find FI-SL Documents Based on AWKEY
GLP0 Local Logical General Ledger Plan Line Items
GLPCA EC-PCA: Actual Line Items
GLPCP EC-PCA: Plan Line Items
GLPCT EC-PCA: Totals Table
GLSP General Ledger line item database
GLT0 G/L account master record transaction figures
GLT3 Summary Data Preparations for Consolidation
GLTP General Ledger summary database
GLTPC Profit Center Accounting
GMAVCA Actual line item table
GMAVCP Plan line items table
GMAVCT Summary table
GMIA Actual Line Item Table
GMIP Plan line items table
GMIT Summary table
JVPO1 JVA: Plan Line Items
JVPSC01A Actual line item table
JVPSC01P Plan line item table
JVPSC01T Summary table
JVSO1 JV LI Table with Objects for JVTO1
JVSO2 JV Billing FI-SL Line Item
JVTO1 JV Summary Table with Objects
JVTO2 JV Billing FI-SL Summary Table
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
TRACTSLA Actual Line Item Table
TRACTSLP Plan Line Items Table
TRACTSLT Totals Table
  1. When you use CO_ITEM archiving object, system archives data from the following tables
Objects in Controlling Archiving Objects
CO Line Items CO_ITEM

 

Table Description
COBK CO Object: Document Header
COBK_INDX Index in COBK for ORGVG
COEJ CO Object: Line Items (by Fiscal Year)
COEJL CO Object: Line Items for Activity Types (by Fiscal Year)
COEJR CO Object: Line Items for Stat. Key Figures (by Fiscal Year)
COEJT CO Object: Line Items for Prices (by Fiscal Year)
COEP CO Object: Line Items (by Period)
COEPB CO Object: Line Items Variance/Period-Based Results Analysis
COEPL CO Object: Line Items for Activity Types (by Period)
COEPR CO Object: Line Items for Stat. Key Figs (by Period)
COEPT CO Object: Line Items for Prices (by Period)
EBII CO/SD document flow: billed portions of expense items
  1. When you use CO_TOTAL archiving object, system archives data from the following tables
Objects in Controlling Archiving Objects
CO Totals Records CO_TOTAL

 

Table Description
CKHS Header: Unit Costing (Control + Totals)
CKHT Texts for CKHS
CKIP Unit Costing: Period Costs Line Item
CKIS Items Unit Costing/Itemization Product Costing
CKIT Texts for CKIS
COKP CO Object: Control Data for Primary Planning
COKR CO Object: Control Data for Statistical Key Figures
COKS CO Object: Control Data for Secondary Planning
COOI Commitments Management: Line Items
COSB CO Object: Total Variances/Results Analyses
COSL CO Object: Activity Type Totals
COSP CO Object: Cost Totals for External Postings
COSPR CO Objekt: Enhancement to COSP for Dependency Planning
COSR CO Object: Statistical Key Figure Totals
COSS CO Object: Cost Totals for Internal Postings
COST CO Object: Price Totals
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAP script text file header
STXL STXD SAP script text file lines
  1. When you use EC_PCA_ITM archiving object, system archives data from the following tables
Objects in Controlling Archiving Objects
Profit Center Acctg: Actual and Plan Line Items EC_PCA_ITM

 

Table Description
GLPCA EC-PCA: Actual Line Items
GLPCP EC-PCA: Plan Line Items
  1. When you use EC_PCA_SUM archiving object, system archives data from the following tables
Objects in Controlling Archiving Objects
Profit Center Accounting: Totals Records EC_PCA_SUM

 

Table Description
GLPCT EC-PCA: Totals Table
  1. When you use SCMG archiving object, system archives data from the following tables
Objects in FSCM Archiving Objects
Case Management: Case Archiving SCMG

 

Table Description
Table  Description
 SCMG_T_CASE  Case: Entity Table for Case
 SCMG_T_CASE_ATTR  Case Attributes
UDM_P2P_ATTR Promise to Pay
UDMCASEATTR00 Dispute Case Attributes
UDMCASEATTR10 Dispute Case Attribute for Account Balance
  1. When you use MM_MATBEL archiving object, system archives data from the following tables
Objects in MM Archiving Objects
Materials management: Material documents MM_MATBEL

 

Table Description
IMEXT Enhancement Fields for Goods Receipt
MKPF Header: Material Document
MSEG Document Segment: Material
NAST Message Status
  1. When you use MM_ACCTIT archiving object, system archives data from the following tables
Objects in MM Archiving Objects
MM- Accounting interface posting data MM_ACCTIT

 

Table Description
ACCTCR Compressed Data from FI/CO Document – Currencies
ACCTHD Compressed Data from FI/CO Document – Header
ACCTIT Compressed Data from FI/CO Document
  1. When you use MM_EBAN archiving object, system archives data from the following tables
Objects in MM Archiving Objects
Purchase Requisitions MM_EBAN

 

Table Description
A081 Contract Conditions at Plant Level
A082 Contract Conditions without Plant
A215 Contract header conditions at outline level without plant
ADR10 Printer (Business Address Services)
ADR11 SSF (Business Address Services)
ADR12 FTP and URL (Business Address Services)
ADR13 Pager (Business Address Services)
ADR2 Telephone Numbers (Business Address Services)
ADR3 Fax Numbers (Business Address Services)
ADR4 Teletex Numbers (Business Address Services)
ADR5 Telex Numbers (Business Address Services)
ADR6 E-Mail Addresses (Business Address Services)
ADR7 Remote Mail Addresses (SAP – SAP – Communication; BAS)
ADR8 X.400 Numbers (Business Address Services)
ADR9 RFC Destinations (Business Address Services)
ADRCOMC Comm. Data Serial Number Counter (Business Address Services)
ADRCT Address Texts (Business Address Services)
ADRG Assignment of Addresses to Other Address Groups (BAS)
ADRGP Assignment of Persons to Further Person Groups (BAS)
ADRT Communication Data Text (Business Address Services)
ADRU Table for Communication Usages
ADRV Address Where-Used List (Business Address Services)
ADRVP Person Where-Used List (Business Address Services)
AUSP Characteristic Values
CDCLS Cluster structure for change documents
CDHDR Change document header
CDPOS_STR Additional Change Document – Table for STRINGs
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
DJEST Individual Status per Object: Key Date Based Management
EBAN Purchase Requisition
EBAN_TECH Purchase requisition external sourcing
EBKN Purchase Requisition Account Assignment
EBUB Index for Stock Transport Requisitions for Material
EREV Version in Purchasing
ESKL Account Assignment Specification: Service Line
ESLH Service Package Header Data
ESLL Lines of Service Package
ESUC Ext. Services Management: Unplanned Limits on Contract Item
ESUH Ext. Services Management: Unpl. Service Limits: Header Data
IBADDR IBase: Business Address Services Connection
IBIB IB: Installed Base/IBase
IBIBOBS IB: IBase observer
IBIBT IB: Installed base short texts
IBIN IB: IBase Components – Condition
IBINDOMAINS IB: Redundant Design Object Character Domains for Instance
IBINOBS IB: Observer of an IBase Component
IBINOWN IB: Owner of an IBase Component
IBINT IB: Component short texts
IBINTX IBase: Text for the Instance
IBINVALUES IB: IBase Components – Condition Characteristic Evaluation
IBSP IB: Installed Base Component – Enhancement/Specialization
IBST IB: Installation Component – Structure
IBSTREF IB: Installed Base – Reference to Master Data Structure
IBSYMBOL IB: Characteristic Value Assignment
INOB Link between Internal Number and Object
JCDO Change Documents for Status Object (Table JSTO)
JCDS Change Documents for System/User Statuses (Table JEST)
JEST Individual Object Status
JSTO Status object information
KOCLU Cluster for conditions in purchasing and sales
KONH Conditions (Header)
KONM Conditions (1-Dimensional Quantity Scale)
KONP Conditions (Item)
KONW Conditions (1-Dimensional Value Scale)
KSSK Allocation Table: Object to Class
PREXT Enhancement Fields for Purchase Requisition
RESB Reservation/dependent requirements
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
  1. When you use MM_EKKO archiving object, system archives data from the following tables
Objects in MM Archiving Objects
Purchasing Documents MM_EKKO

 

Table Description
A068 Outline Agreement Item: Plant-Dependent
A081 Contract Conditions at Plant Level
A082 Contract Conditions without Plant
A215 Contract header conditions at outline level without plant
ADR10 Printer (Business Address Services)
ADR11 SSF (Business Address Services)
ADR12 FTP and URL (Business Address Services)
ADR13 Pager (Business Address Services)
ADR2 Telephone Numbers (Business Address Services)
ADR3 Fax Numbers (Business Address Services)
ADR4 Teletex Numbers (Business Address Services)
ADR5 Telex Numbers (Business Address Services)
ADR6 E-Mail Addresses (Business Address Services)
ADR7 Remote Mail Addresses (SAP – SAP – Communication; BAS)
ADR8 X.400 Numbers (Business Address Services)
ADR9 RFC Destinations (Business Address Services)
ADRCOMC Comm. Data Serial Number Counter (Business Address Services)
ADRCT Address Texts (Business Address Services)
ADRG Assignment of Addresses to Other Address Groups (BAS)
ADRGP Assignment of Persons to Further Person Groups (BAS)
ADRT Communication Data Text (Business Address Services)
ADRU Table for Communication Usages
ADRV Address Where-Used List (Business Address Services)
ADRVP Person Where-Used List (Business Address Services)
AUSP Characteristic Values
CDCLS Cluster structure for change documents
CDHDR Change document header
CDPOS_STR Additional Change Document – Table for STRINGs
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
CMFK Storage Structure for the Error Log Header
CMFP Storage Structure for Errors Collected
DJEST Individual Status per Object: Key Date Based Management
EIKP Foreign Trade: Export/Import Header Data
EIPO Foreign Trade: Export/Import: Item Data
EKAB Release Documentation
EKBE History per Purchasing Document
EKBEH Removed PO History Records
EKBZ History per Purchasing Document: Delivery Costs
EKBZH History per Purchasing Document: Delivery Costs
EKEH Scheduling Agreement Release Documentation
EKEK Header Data for Scheduling Agreement Releases
EKES Vendor Confirmations
EKET Scheduling Agreement Schedule Lines
EKETH Scheduling Agreement Schedules: History Tables
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKPA Partner Roles in Purchasing
EKPO Purchasing Document Item
EKPV Shipping Data For Stock Transfer of Purchasing Document Item
EKUB Index for Stock Transport Orders for Material
EREV Version in Purchasing
ESKL Account Assignment Specification: Service Line
ESKN Account Assignment in Service Package
ESLH Service Package Header Data
ESLL Lines of Service Package
ESSR Service Entry Sheet Header Data
ESUC Ext. Services Management: Unplanned Limits on Contract Item
ESUH Ext. Services Management: Unpl. Service Limits: Header Data
FPLA Billing Plan
FPLT Billing Plan: Dates
IBADDR IBase: Business Address Services Connection
IBIB IB: Installed Base/IBase
IBIBOBS IB: IBase observer
IBIBT IB: Installed base short texts
IBIN IB: IBase Components – Condition
IBINDOMAINS IB: Redundant Design Object Character Domains for Instance
IBINOBS IB: Observer of an IBase Component
IBINOWN IB: Owner of an IBase Component
IBINT IB: Component short texts
IBINTX IBase: Text for the Instance
IBINVALUES IB: IBase Components – Condition Characteristic Evaluation
IBSP IB: Installed Base Component – Enhancement/Specialization
IBST IB: Installation Component – Structure
IBSTREF IB: Installed Base – Reference to Master Data Structure
IBSYMBOL IB: Characteristic Value Assignment
INOB Link between Internal Number and Object
JCDO Change Documents for Status Object (Table JSTO)
JCDS Change Documents for System/User Statuses (Table JEST)
JEST Individual Object Status
JSTO Status object information
KAPOL Condition pool : Prices and surcharges and discounts
KOCLU Cluster for conditions in purchasing and sales
KONH Conditions (Header)
KONM Conditions (1-Dimensional Quantity Scale)
KONP Conditions (Item)
KONW Conditions (1-Dimensional Value Scale)
KSSK Allocation Table: Object to Class
MLBE Material Ledger FS Item Table for GR/IR relevant transaction
MLBECR Material Ledger Currency Table for GR/IR relevant transact.
MLWERE Conversion Table between Purchasing and Material Ledger
NAST Message Status
POEXT Enhancement Fields for Purchase Order
RESB Reservation/dependent requirements
S111 Index: Subsequent Settlement
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
WRF_PSCD_DLHD Date Line, Header Data
WRF_PSCD_DLIT Date Line, Dates
WRF_PSCD_DLIT_SH Date Line: Dates, Shadow Table
  1. When you use MM_INVBEL archiving object, system archives data from the following tables
Objects in MM Archiving Objects
Materials management: Inventory documents MM_INVBEL

 

Table Description
CDCLS Cluster structure for change documents
CDHDR Change document header
CDPOS_STR Additional Change Document – Table for STRINGs
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
IKPF Header: Physical Inventory Document
ISEG Physical Inventory Document Items
  1. When you use SD_VBAK archiving object, system archives data from the following tables
Objects in SD Archiving Objects
Sales Documents SD_VBAK

 

Table Description
/CBAD/CON_DBS Advanced Order Processing and Billing: DBS Item Data
/CBAD/CON_FUND_H Advanced Order Processing and Billing: Fund Header Data
/CBAD/CON_HIST Advanced Order Processing and Billing: Contract History
/CBAD/CONTRACT_H Advanced Order Processing and Billing: Header Data
/CBAD/CONTRACT_I Advanced Order Processing and Billing: Item Data
AABLG Cluster for Settlement Document
AD01DLI Dynamic items (DI)
AD01DLIEF DI flow: Individual flow
AD01DLISF DI Flow: Totals Flow
ADR10 Printer (Business Address Services)
ADR11 SSF (Business Address Services)
ADR12 FTP and URL (Business Address Services)
ADR13 Pager (Business Address Services)
ADR2 Telephone Numbers (Business Address Services)
ADR3 Fax Numbers (Business Address Services)
ADR4 Teletex Numbers (Business Address Services)
ADR5 Telex Numbers (Business Address Services)
ADR6 E-Mail Addresses (Business Address Services)
ADR7 Remote Mail Addresses (SAP – SAP – Communication; BAS)
ADR8 X.400 Numbers (Business Address Services)
ADR9 RFC Destinations (Business Address Services)
ADRCOMC Comm. Data Serial Number Counter (Business Address Services)
ADRCT Address Texts (Business Address Services)
ADRG Assignment of Addresses to Other Address Groups (BAS)
ADRGP Assignment of Persons to Further Person Groups (BAS)
ADRT Communication Data Text (Business Address Services)
ADRU Table for Communication Usages
ADRV Address Where-Used List (Business Address Services)
ADRVP Person Where-Used List (Business Address Services)
AFFL Work order sequence
AFVC Operation within an order
AFVU DB structure of the user fields of the operation
AUAI Settlement Amounts per Depreciation Area
AUAK Document Header for Settlement
AUSP Characteristic Values
BPBK Doc.Header                                 Controlling Obj.
BPEG Line Item Overall Values                   Controlling Obj.
BPEJ Line Item Annual Values                    Controlling Obj.
BPEP Line Item Period Values                    Controlling Obj.
BPGE Totals Record for Total Value              Controlling obj.
BPHI Cross-hierarchy Data                       Controlling obj.
BPIG Budget Object Index (Overall Budget)
BPIJ Budget Object Index (Annual Budget)
BPJA Totals Record for Annual Total             Controlling Obj.
BPPE Totals Record for Period Values            Controlling Obj.
BPTR Object Data                                Controlling Obj.
BPTX Budgeting Text
CABN Characteristic
CABNT Characteristic Descriptions
CAWNT Value Texts
CDCLS Cluster structure for change documents
CDHDR Change document header
CDPOS_STR Additional Change Document – Table for STRINGs
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
CKHS Header: Unit Costing (Control + Totals)
CKHT Texts for CKHS
CKIP Unit Costing: Period Costs Line Item
CKIS Items Unit Costing/Itemization Product Costing
CKIT Texts for CKIS
CMFK Storage Structure for the Error Log Header
CMFP Storage Structure for Errors Collected
CMPB_ASGN Campaign Assignment
COANZ Index of Objects With Down Payments/Requests
COBK CO Object: Document Header
COBK_INDX Index in COBK for ORGVG
COBRA Settlement Rule for Order Settlement
COBRB Distribution Rules Settlement Rule Order Settlement
COEJ CO Object: Line Items (by Fiscal Year)
COEJL CO Object: Line Items for Activity Types (by Fiscal Year)
COEJR CO Object: Line Items for Stat. Key Figures (by Fiscal Year)
COEJT CO Object: Line Items for Prices (by Fiscal Year)
COEP CO Object: Line Items (by Period)
COEPB CO Object: Line Items Variance/Period-Based Results Analysis
COEPBR CO Object: Valuated Line Item Settlement
COEPD CO Object: Line Item Settlement, Not Valuated, With Status
COEPL CO Object: Line Items for Activity Types (by Period)
COEPR CO Object: Line Items for Stat. Key Figs (by Period)
COEPT CO Object: Line Items for Prices (by Period)
COER Sales Order Value Revenue
COES CO Object: Sales Order Value Line Items
COFP Document Lines (project cash management)
COKA CO Object: Control Data for Cost Elements
COKL CO Object: Control Data for Activity Types
COKP CO Object: Control Data for Primary Planning
COKR CO Object: Control Data for Statistical Key Figures
COKS CO Object: Control Data for Secondary Planning
COOI Commitments Management: Line Items
COSB CO Object: Total Variances/Results Analyses
COSBD CO Object: Total of variances/accruals, of which settled
COSL CO Object: Activity Type Totals
COSLD CO Object: Activity Type Totals – of Which Settled
COSP CO Object: Cost Totals for External Postings
COSPD CO Object: Settled Primary Cost Totals
COSR CO Object: Statistical Key Figure Totals
COSS CO Object: Cost Totals for Internal Postings
COSSD CO Object: Settled Secondary Cost Totals
COST CO Object: Price Totals
CPED_DEFFORMDOC CPE Formula – Default in Document
CPED_DEFTERMGRP CPE Term – Default for Grouping and General Data in Docume
CPED_FORMCONVIN CPE Formula – Input for Conversion
CPED_FORMCONVOUT CPE Formula – Result of Conversion
CPED_FORMDOC CPE Formula – Grouping and General Result
CPED_FORMINPUT CPE Formula – Changed  Input for General Data
CPED_FORMROUNDIN CPE Formula – Input for Rounding
CPED_KNUMVTOGUID CPE Caller – Mapping KNUMV and Document Item to GUID
CPED_PERIODDTIN CPE Term – Changed Input Data for Period Determination
CPED_PERIODDTOUT CPE Term – Result Data of Period Determination
CPED_TERMCONVIN CPE Term – Input for Conversion
CPED_TERMCONVOUT CPE Term – Result of Conversion
CPED_TERMGRPOUT CPE Term – Changed Grouping and General Term Result
CPED_TERMINPUT CPE Term – Changed  Input for General Data
CPED_TERMOUT CPE Term – General Result
CPED_TERMROUNDIN CPE Term – Input for Rounding
DGMSD DG: Dangerous Goods Document Table DGMSD
DJEST Individual Status per Object: Key Date Based Management
EBII CO/SD document flow: billed portions of expense items
FMSU FI-FM Totals Records
FPLA Billing Plan
FPLT Billing Plan: Dates
FPLTC Payment cards: Transaction data – SD
IBADDR IBase: Business Address Services Connection
IBIB IB: Installed Base/IBase
IBIBOBS IB: IBase observer
IBIBT IB: Installed base short texts
IBIN IB: IBase Components – Condition
IBINDOMAINS IB: Redundant Design Object Character Domains for Instance
IBINOBS IB: Observer of an IBase Component
IBINOWN IB: Owner of an IBase Component
IBINT IB: Component short texts
IBINTX IBase: Text for the Instance
IBINVALUES IB: IBase Components – Condition Characteristic Evaluation
IBSP IB: Installed Base Component – Enhancement/Specialization
IBST IB: Installation Component – Structure
IBSTREF IB: Installed Base – Reference to Master Data Structure
IBSYMBOL IB: Characteristic Value Assignment
INOB Link between Internal Number and Object
JCDO Change Documents for Status Object (Table JSTO)
JCDS Change Documents for System/User Statuses (Table JEST)
JEST Individual Object Status
JSTO Status object information
KANZ Assignment of Sales Order Items – Costing Objects
KEKO Product Costing – Header Data
KEPH Product Costing: Cost Components for Cost of Goods Mfd
KNKO Assignment of Cost Est. Number to Config. Object
KOCLU Cluster for conditions in purchasing and sales
KSSK Allocation Table: Object to Class
NAST Message Status
ONR00 General Object Number
ONRVB Object number index for sales document item
RPSCO Project info database: Costs, revenues, finances
RPSQT Project info database: quantities
SADR Address Management: Company Data
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
SWOR Classification System: Keywords
TPI03 CO Objects: Date of Last Interest Run
TZIN1 Document Header Data from Source Document (PS Int.Calc.)
TZIN2 Interest Document:Segment Int.Indicator & Valuation Category
TZIN3 Interest Document: Currency Type Segment
TZIN4 Interest Document: “Objects Affected” Segment
VAKGU Sales Index: Quotation Validity
VAKPA Sales Index: Orders by Partner Function
VAPMA Sales Index: Order Items by Material
VBAK Sales Document: Header Data
VBAP Sales Document: Item Data
VBEH Schedule line history
VBEP Sales Document: Schedule Line Data
VBEPDG Appendix Table for Dangerous Goods Data
VBEX SD Document: Export Control: Data at Item Level
VBFA Sales Document Flow
VBKD Sales Document: Business Data
VBLB Sales document: Release order data
VBPA Sales Document: Partner
VBPA2 Sales document: Partner (used several times)
VBPA3 Tax Numbers for One-Time Customers
VBSN Change status relating to scheduling agreements
VBUK Sales Document: Header Status and Administrative Data
VBUP Sales Document: Item Status
VBUV Sales Document: Incompletion Log
VEDA Contract Data
VEPVG Delivery Due Index
VKDFS SD Index: Billing Initiator
VLPKM Scheduling agreements by customer material
VPKDLI Sales Pricing Dynamic Items
VPKHEAD Sales Pricing Header Data
VPKSDITEM Sales Pricing Header Data (Specific to SD)
VTRDI Shipment Planning Index
WAPPTV Appointments: Worklist
  1. When you use RV_LIKP archiving object, system archives data from the following tables
Objects in SD Archiving Objects
Deliveries RV_LIKP

 

Table Description
/SPE/CD_DOCFLOW Document Flow for Transportation Cross-Docking
/SPE/CD_PROC_ITM Cross-Docking Process: Item Information
/SPE/INSPECRESC Inspection Outcome: Item Codes
/SPE/INSPECRESH Inspection Outcome: Header
/SPE/INSPECRESP Inspection Outcome: Item
/SPE/RET_CARRSEL Table of allowed carriers for a returns delivery item
/SPE/RETPACKPROP Table for storing Packaging Proposal Information
ADR10 Printer (Business Address Services)
ADR11 SSF (Business Address Services)
ADR12 FTP and URL (Business Address Services)
ADR13 Pager (Business Address Services)
ADR2 Telephone Numbers (Business Address Services)
ADR3 Fax Numbers (Business Address Services)
ADR4 Teletex Numbers (Business Address Services)
ADR5 Telex Numbers (Business Address Services)
ADR6 E-Mail Addresses (Business Address Services)
ADR7 Remote Mail Addresses (SAP – SAP – Communication; BAS)
ADR8 X.400 Numbers (Business Address Services)
ADR9 RFC Destinations (Business Address Services)
ADRCOMC Comm. Data Serial Number Counter (Business Address Services)
ADRCT Address Texts (Business Address Services)
ADRG Assignment of Addresses to Other Address Groups (BAS)
ADRGP Assignment of Persons to Further Person Groups (BAS)
ADRT Communication Data Text (Business Address Services)
ADRU Table for Communication Usages
ADRV Address Where-Used List (Business Address Services)
ADRVP Person Where-Used List (Business Address Services)
CDCLS Cluster structure for change documents
CDHDR Change document header
CDPOS_STR Additional Change Document – Table for STRINGs
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
CMFK Storage Structure for the Error Log Header
CMFP Storage Structure for Errors Collected
DGMSD DG: Dangerous Goods Document Table DGMSD
DLFLD Non-Changeable Delivery Fields
EIKP Foreign Trade: Export/Import Header Data
EIPO Foreign Trade: Export/Import: Item Data
EIUV Foreign Trade: Incompletion Log for Foreign Trade Data
KOCLU Cluster for conditions in purchasing and sales
LEDSPD_FLOW Document Flow for Subsequent Outbound-Delivery Split
LIKP SD Document: Delivery Header Data
LIPS SD document: Delivery: Item data
LIPSDG Appendix Table for Dangerous Goods Data
LIPSPO LIPS Reference Data Purchase Order
LIPSRF LIPS Reference Data
NAST Message Status
OBJK Plant Maintenance Object List
SADR Address Management: Company Data
SER00 General Header Table for Serial Number Management
SER01 Document Header for Serial Numbers for Delivery
SER02 Document Header for Serial Nos for Maint.Contract (SD Order)
SER03 Document Header for Serial Numbers for Goods Movements
SER04 Document Header for Serial Numbers for Inspection Lot
SER05 Document Header for Serial Numbers for PP Order
SER06 Document Header for Serial Numbers for Handling Unit-Content
SER07 Document Header for Serial Numbers in Physical Inventory
SHP_IDX_CRED Outbound Deliveries in Credit Check: Blocked and Released
SHP_IDX_EXIB Inbound Delivery: External Identification
SHP_IDX_EXOB Outbound Delivery: External Identification
SHP_IDX_GDRC Inbound Deliveries: Not Posted for Goods Receipt
SHP_IDX_GDSI Outbound Deliveries: Not Posted for Goods Issue
SHP_IDX_PICK Outbound Deliveries: Not Picked
SHP_IDX_PUTA Inbound Deliveries: Not Putaway
SHP_IDX_ROGR Rough Goods Receipts for Vendor
SHP_IDX_UNCH Outbound Deliveries: Unchecked
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
TSEGE Time Segment Events
TSEGEADR Time Segment Address for Event
TSEGH Time Segment Header
TSEGR Time Segment Relationships Between Events
TVPOD Sales Document: Delivery: POD Data
VBFA Sales Document Flow
VBPA Sales Document: Partner
VBPA3 Tax Numbers for One-Time Customers
VBUK Sales Document: Header Status and Administrative Data
VBUP Sales Document: Item Status
VBUV Sales Document: Incompletion Log
VEPVG Delivery Due Index
VKDFS SD Index: Billing Initiator
VLBL Express Delivery Company’s Data Field
VLKPA SD Index: Deliveries by Partner Functions
VLPKM Scheduling agreements by customer material
VLPMA SD Index: Delivery Items by Material
VTDST Status of deliveries within transportation planning
VTRDI Shipment Planning Index
VTRKH Tracking Data – Header
VTRKP Tracking Data – Item
WAPPTV Appointments: Worklist
  1. When you use SD_VBRK archiving object, system archives data from the following tables
Objects in SD Archiving Objects
Billing Documents SD_VBRK

 

Table Description
ADR10 Printer (Business Address Services)
ADR11 SSF (Business Address Services)
ADR12 FTP and URL (Business Address Services)
ADR13 Pager (Business Address Services)
ADR2 Telephone Numbers (Business Address Services)
ADR3 Fax Numbers (Business Address Services)
ADR4 Teletex Numbers (Business Address Services)
ADR5 Telex Numbers (Business Address Services)
ADR6 E-Mail Addresses (Business Address Services)
ADR7 Remote Mail Addresses (SAP – SAP – Communication; BAS)
ADR8 X.400 Numbers (Business Address Services)
ADR9 RFC Destinations (Business Address Services)
ADRCOMC Comm. Data Serial Number Counter (Business Address Services)
ADRCT Address Texts (Business Address Services)
ADRG Assignment of Addresses to Other Address Groups (BAS)
ADRGP Assignment of Persons to Further Person Groups (BAS)
ADRT Communication Data Text (Business Address Services)
ADRU Table for Communication Usages
ADRV Address Where-Used List (Business Address Services)
ADRVP Person Where-Used List (Business Address Services)
CDCLS Cluster structure for change documents
CDHDR Change document header
CDPOS_STR Additional Change Document – Table for STRINGs
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
CMFK Storage Structure for the Error Log Header
CMFP Storage Structure for Errors Collected
CMPB_ASGN Campaign Assignment
CPED_DEFFORMDOC CPE Formula – Default in Document
CPED_DEFTERMGRP CPE Term – Default for Grouping and General Data in Docume
CPED_FORMCONVIN CPE Formula – Input for Conversion
CPED_FORMCONVOUT CPE Formula – Result of Conversion
CPED_FORMDOC CPE Formula – Grouping and General Result
CPED_FORMINPUT CPE Formula – Changed  Input for General Data
CPED_FORMROUNDIN CPE Formula – Input for Rounding
CPED_KNUMVTOGUID CPE Caller – Mapping KNUMV and Document Item to GUID
CPED_PERIODDTIN CPE Term – Changed Input Data for Period Determination
CPED_PERIODDTOUT CPE Term – Result Data of Period Determination
CPED_TERMCONVIN CPE Term – Input for Conversion
CPED_TERMCONVOUT CPE Term – Result of Conversion
CPED_TERMGRPOUT CPE Term – Changed Grouping and General Term Result
CPED_TERMINPUT CPE Term – Changed  Input for General Data
CPED_TERMOUT CPE Term – General Result
CPED_TERMROUNDIN CPE Term – Input for Rounding
EIKP Foreign Trade: Export/Import Header Data
EIPO Foreign Trade: Export/Import: Item Data
FPLA Billing Plan
FPLT Billing Plan: Dates
FPLTC Payment cards: Transaction data – SD
KOCLU Cluster for conditions in purchasing and sales
NAST Message Status
SADR Address Management: Company Data
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
VAKGU Sales Index: Quotation Validity
VBFA Sales Document Flow
VBOX SD Document: Billing Document: Rebate Index
VBPA Sales Document: Partner
VBPA3 Tax Numbers for One-Time Customers
VBRK Billing Document: Header Data
VBRL Sales Document: Invoice List
VBRP Billing Document: Item Data
VBUK Sales Document: Header Status and Administrative Data
VEPVG Delivery Due Index
VKDFS SD Index: Billing Initiator
VLPKM Scheduling agreements by customer material
VRKPA Sales Index: Bills by Partner Functions
VRPMA SD Index: Billing Items per Material
VTRDI Shipment Planning Index
WAPPTV Appointments: Worklist
  1. When you use WORKITEM archiving object, system archives data from the following tables
Objects in WF Archiving Objects
Work Items from Workflow System WORKITEM

 

Table Description
SWFGPROLEINST Guided Procedures: Role Instance
SWP_HEADER Workflow Instances: Header Data of a Workflow Execution
SWP_NODEWI WF: Work items for nodes in a workflow definition
SWPCMPCONT Component Container of WFM
SWPNODE WFM: Node Properties and Node Hierarchy at Runtime
SWPNODELOG Workflow: Instance Data of Nodes of a Workflow Execution
SWPSTEPLOG Workflow: Instance Data of Steps of a Workflow Execution
SWW_CONT Workflow Runtime: Work Item Data Container
SWW_CONTOB Workflow Runtime: Work Item Data Container (Only Objects)
SWW_WI2OBJ Workflow Runtime: Relation of Work Item to Object
SWWCNTP0 Workflow Container: XML Database (P0)
SWWCNTPADD Workflow Runtime: Persistence for Additional Container (XML)
SWWEI Workflow Runtime: Work Items of Type E (Event Items)
SWWLOGHIST Workflow Runtime: History of a Work Item
SWWLOGPARA Obsolete 4.6/ WIM Log Table: Actions on WIs – Parameters
SWWWIDEADL Workflow Runtime: Deadline Data for Work Items
SWWWIHEAD Workflow Runtime: Header Table for All Work Item Types
SWWWIRET Workflow Runtime: Return Values of Method Call
SWZAI Header Table for all Properties of a Work Queue
SWZAIENTRY Object Table for Work Queues (Entries)
SWZAIRET Return Values of Method Call of a WQ Line
  1. When you use CHANGEDOCU archiving object, system archives data from the following tables
Objects in Document Change Archiving Objects
Change Documents CHANGEDOCU

 

Table Description
CDCLS Cluster structure for change documents
CDHDR Change document header
CDPOS_STR Additional Change Document – Table for STRINGs
CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters
  1. When you use BC_SBAL archiving object, system archives data from the following tables
Objects in Application Log Archiving Objects
Archiving Object for Application Log BC_SBAL

 

Table Description
BAL_INDX Application Log: INDX tables
BALDAT Application Log: Log data
BALHDR Application log: log header
  1. When you use IDOC archiving object, system archives data from the following tables
Objects in Intermediate Documents Archiving Objects
IDoc – Intermediate Document IDOC

 

Table Description
EDI30C IDoc cluster (data records) from 3.0C onwards
EDI40 IDoc data records for 4.0
EDIDC Control record (IDoc)
EDIDS Status Record (IDoc)

Conclusion:

Key points to remember

  • We should only archive line item data (documents) that are older than the residency period in SAP Database.
  • No Balance records are considered for archiving
  • New Credit note cannot be referenced for archived invoice
  • Cannot allocate incoming cash against an archived invoice e.g. Invoice cleared against bad debt write-off outside the residency period
  • If you want to access archived data, you are advised to select very specific and limited range of parameters while entering on the selection screen of report.
  • As now the data is stored on Non-SAP database. This could mean retrieval times are slower.
  • Only documents that are “business-complete” and have exceeded their on-line residence times like Documents that require no further processing will be relocated from SAP database tables to external database like Opentext
    • Business-Completed Data: Data that has no further processing like an Invoice that has been settled and cleared by a payment
  • Once data is Archived to external storage it’s not possible to relocate the archived data back to SAP database tables
  • The archiving document includes following ‘Cleared items’
    • Paid vendor invoices
    • Paid customer invoices
    • GL items that have been cleared
  • Documents cannot be reversed and reset after they have been archived which means once archived no changes possible to the document
  • All clearing documents contain 2 or more documents in the set. If any individual document contained within the set has a contra entry in another account which is not itself cleared, then this individual document will not be archived. For example: customer Line item cleared to inflow, but funds not received from bank. The remaining documents in the set will be archived as they would be business complete.
  • As per the reporting authorization role assigned to business user the Archived data can be accessed via SAP Reports with an additional step on the selection screen

 

Be the first to leave a comment
You must be Logged on to comment or reply to a post.