Preparatory Know-How for SAP Data Archiving

[sanjay_prasad5]

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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

11. 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

12. 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

13. 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

14. 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

15. 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

16. 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

17. 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

18. 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

19. 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

 

[Loraine]

Do you have the plan this project?

[sean491]

We are migrating to local hybrid cloud.. Do we just copy and paste existing archive in the new cloud dasd space? Would SAP still be able to access the data in the new hardware location ?