Tech2know

A few days ago I discussed about Archiving procedure and SAP Archiving Objects.

In this post I would be discussing about what data gets archived through SAP Archiving Object FI_DOCUMNT. This is an archiving object which helps in archiving financial data (FI documents) from SAP R/3 system. A number of times, people have confusion as which data gets archived when archiving object FI_DOCUMNT is used. So, following is the explanation. Here when I say Archiving/Archived, it means both write and delete phase.

FI Tables from which data gets archived

BKPF	Accounting Document Header
BSEG	Accounting Document Segment
BSEG_ADD	Entry View of Accounting Document for Additional Ledgers
BSET	Tax Data Document Segment
BVOR	Intercompany posting procedures
BSEC	One-Time Account Data Document Segment
BSED	Bill of Exchange Fields Document Segment
BSEGC	Bill of Exchange Fields Document Segment
WITH_ITEM	Withholding tax info per W/tax type and FI line item
TTXY	External tax interface: tax information
TTXI	External tax interface: index file
BSE_CLR	Additional Data for Document Segment: Clearing Information
BSE_CLR_ASGMNT	Doc. Segment Add. Data: Clearing Info with Acct Assignment
AGKO	Cleared Accounts
ETXDCH	External tax document: header info
ETXDCI	External tax document: line item info
ETXDCJ	Ext. tax document: tax rates and amounts by Jurisdict. level
BSBW	Document Valuation Fields

If New G/L is Active then in addition of above tables, data from following tables also gets archived

FAGL_SPLINFO	Splitting Information of Open Items
FAGL_SPLINFO_VAL	Splitting Information of Open Item Values
FAGL_BSBW_HISTRY	Valuation History for Documents
FAGLFLEXA	General Ledger: Actual Line Items

Now coming to secondary index tables. Below are the same :

BSIS	Accounting: Secondary Index for G/L Accounts
BSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)
BSIK	Accounting: Secondary Index for Vendors
BSAK	Accounting: Secondary Index for Vendors (Cleared Items)
BSID	Accounting: Secondary Index for Customers
BSAD	Accounting: Secondary Index for Customers (Cleared Items)

Secondary index tables stores data of BSEG only but segregated according to account. For example, if an FI document consists of 3 lines with one customer line and two G/L account lines then the one customer line is also populated in BSID and the other two G/L account lines are populated in BSIS at the time of posting of the FI document. Of course, BSEG also contains all these 3 lines.

Note : Secondary index tables are populated with the line items only if the account in the line item is Line item display enabled.

It is now clear that secondary index tables contains redundant data only. And this data is also contained in BSEG. In the first table above I have already mentioned that data from BSEG gets archived and hence there is no need to archive data from secondary indexes.

So, what happens to data in secondary index tables during archiving?

Well, first of all I would like to mention very clearly that from the above 6 secondary index tables only 4 are considered during archiving and these are BSIS, BSAS, BSAK and BSAD. The other two tables,BSIK and BSID, are excluded because we can archive only cleared items and these two tables contains open vendor and customer items. Now answering the question, during archiving a flag XARCH is set for the archived items. All these secondary index tables have this XARCH flag.

Please share your thoughts through comments.

The easiest way to stay informed about everything on Tech2know is to go for at lease one of below options :

Subscribe to my RSS feed / Subscribe by E Mail / Follow me on twitter /Become a fan on Facebook.

Stay tuned for more.

Related posts:

1. SAP Archiving – SAP AS or Archive Information System For FI_DOCUMNT
2. SAP Archiving – Why XARCH Flag is Set in Secondary Indexes during Archiving FI Documents
3. SAP Archiving – Find Tables Included in Archiving Objects
4. SAP Archiving – Important Customizing for Archiving Object FI_DOCUMNT
5. SAP Archiving Objects