Skip to Content

This document will explain archiving of FI documents from configuration to, write, delete and retrival of data. This will be helpful for users to understand basics of SAP Data Archiving.

Problems with Large volume and growth of data:

  • Expensive Storage System
  • Reduced System Performance and Increased Query Time
  • Complex Database Administration i.e. Backups, Client Copy and Upgrades
  • Manpower Productivity Loss

Data Archiving: The Concept

  • Writing Data in Flat Files to External Storage
  • Deleting Data from Online Database
  • Retrieving Achieved Data

FI Documents Data Archiving Example

Archiving Object used: FI_DOCUMNT

Object Description:  The most important object in financial accounting is FI_DOCUMNT. It assumes special status with respect to data growth, data security, and conformity with legal requirements.

Tables Associated:

Table

Description

AGKO

Cleared Accounts

BFIT_A

FI Subsequent BA/PC Adjustment: G/L Account Items

BFIT_A0

FI Subseq.BA/PC Adjustmnt: Zero Bal.Postings for Bus.Area

BFO_A_RA

Versions for Resetting Cleared Items

BFOD_A

FI Subsequent BA/PC Adjustment: Customer Items

BFOD_AB

FI Subseq.BA/PC Adjustmnt: ValuatnDiffrnce in Customer OIs

BFOK_A

FI subsequent BA/PC adjustment: Vendor items

BFOK_AB

FI subseq.BA/PC adjustmnt: Valuatn difference in vendor OIs

BKPF

Accounting Document Header

BSAD

Accounting: Secondary Index for Customers (Cleared Items)

BSAK

Accounting: Secondary Index for Vendors (Cleared Items)

BSAS

Accounting: Secondary Index for G/L Accounts (Cleared Items)

BSBW

Document Valuation Fields

BSE_CLR

Additional Data for Document Segment: Clearing Information

BSE_CLR_ASGMT

  1. Segment Add. Data: Clearing Info with Acct Assignment

BSEG_ADD

Entry View of Accounting Document for Additional Ledgers

BSEGC

Document: Data on Payment Card Payments

BSIM

Secondary Index, Documents for Material

BSIP

Index for Vendor Validation of Double Documents

BSIS

Accounting: Secondary Index for G/L Accounts

BSPL

Split Posting Procedures

BVOR

Intercompany posting procedures

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

ETXDCH

External tax document: header info

ETXDCI

External tax document: line item info

ETXDCJ

  1. tax document: tax rates and amounts by Jurisdict. level

FAGL_BSBW_HISTRY

Valuation History for Documents

FAGL_SPLINFO

Splittling Information of Open Items

FAGL_SPLINFO_VAL

Splitting Information of Open Item Values

FAGLFLEXA

General Ledger: Actual Line Items

FIGLDOC

G/L accounting: Subsequent derivations

RF048

  1. Subseq.BA/PC Adjustmnt: Index/Distributn Vector (Calculate)

RFBLG

Cluster for accounting document

STXB

SAPscript: Texts in non-SAPscript format

STXH

STXD SAPscript text file header

STXL

STXD SAPscript text file lines

TTXI

External tax interface: index file

TTXY

External tax interface: tax information

WITH_ITEM

Witholding tax info per W/tax type and FI line item

AOBJ Configuration:Archiving Object configuration is done in AOBJ T. Code. Specific configuration is done with respect to the archiving object FI_DOCUMNT.

Picture1.png                       

Maximum file size set as 100 MB and Maximum number of Data Objects as 10.

Document lifetime configuration:

The document type life period can be maintained using OBR8 & OBR7.

Picture2.png

Picture3.png

 

Here, we have maintained 2196 days i.e. 6 yrs. That means past 2196 days data from current date will not be available for archiving.

SARI configuration

The Archive Information System (transaction SARI) will allow configuring archive information structure. It is only possible to access archived data if such an info structure exists and has been filled.

  1. a. Info set Name

SAP_FI_DOC_001 will have to be used for FI_Document object. As this info structure already exists we just need to select it and activate it.

Picture4.png     

  1. b. Info Set activation

In order to able to use an info structure we need to first activate it. Only after an info structure has been activated can it be filled with data from the archive and evaluated. However activate info structures can no longer be modified.

      Picture5.png

SARA Configuartion

  1. 1) To Fiscal Year/Period : 1995 01 to 1998 12

  1. Variant Configuration

Picture6.png

Picture7.png

Picture8.png

Click on Maintain button.

For example in selection only one document number is given. However during actual implementation actual fiscal year and period range will be provided

                Picture9.png

Note:

“Complete” in detail log and “List and Application Log” in Log Output will be selected to see detailed log output of write job.

Picture10.png 

Enter description of variant and save it.

  1. Write Mode

We will first run write job with test mode variant and then will run with production mode variant.

  Picture11.png

Select immediate for Start date selection and save it.

Select desired printer to print spool, and hit the green tick mark.

Click on execute button and a job will be scheduled.

Picture12.png

  1. Delete mode

The delete program reads the archived documents in the archive file including the corresponding table entries, and deletes the corresponding records from the database however FI secondary indices are only marked for deletion they are deleted by post processing program.

Picture13.png     

Select Delete Tab.

Picture14.png

Maintain archive selection, start date and Spool Parameters. Select the session name.

Picture15.png

Picture16.png

Click on execute button, a job will be scheduled. See the status of job by clicking on job button.

SARI Read Mode

During the delete phase of data archiving, all active info structure belonging to an archiving object are automatically filled with data from respective archive file. On basis of the defined infostructure , the archive information system filters the data from the data records in the archive and inserts it into the generated database table together with the achieve file key and the offset of the business object.  These entries will serve as a basis for subsequent search.

  1. Info set Read

Picture17.png

Click on Archive Explorer and give Archive infostructure name.

     Picture18.png

Fill company code, document number and fiscal year selection fields.

  Picture19.png

Click on execute and see the document.

Picture20.png

Standard Report/Transaction code to fetch data from archived file:

T – Code

Description

FB03

Display Document: Initial Screen

FBL1n, FBL3n

Reports

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply