gl planning budgeting

7/27/2019 GL Planning Budgeting

1/11

SAP Data Archiving Process:Archiving Object FI_DOCUMNT

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


2/11

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


3/11

AOBJ Confi guration:Archiving Object configuration is done in AOBJ T. Code. Specific configuration is

done with respect to the archiving object FI_DOCUMNT.

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

Document li fetime conf iguration:

The document type life period can be maintained using OBR8 & OBR7.
http://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273904/Picture2.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273903/Picture1.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273904/Picture2.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273903/Picture1.png


4/11

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 confi guration

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.

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

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

SARA Confi guarti on

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

a. Variant Configuration
http://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273940/Picture5.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273939/Picture4.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273938/Picture3.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273940/Picture5.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273939/Picture4.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273938/Picture3.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273940/Picture5.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273939/Picture4.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273938/Picture3.png


5/11

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


6/11

Note:

Complete in detail log and List and Application Log in Log Output will be selected to see detailed log output of

write job.
http://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273944/Picture9.png


7/11

Enter description of variant and save it.

a. Write Mode

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

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.


8/11

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

Select Delete Tab.


9/11

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

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.

a. Info set Read


10/11

Click on Archive Explorer and give Archive infostructure name.

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

Click on execute and see the document.

Standard Report/Tr ansaction code to fetch data from archived fi le:
http://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273963/Picture20.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273962/Picture19.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273958/Picture18.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273957/Picture17.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273963/Picture20.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273962/Picture19.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273958/Picture18.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273957/Picture17.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273963/Picture20.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273962/Picture19.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273958/Picture18.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273957/Picture17.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273963/Picture20.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273962/Picture19.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273958/Picture18.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-46052-3-273957/Picture17.png


11/11

TCode Description

FB03 Display Document: Initial Screen

FBL1n, FBL3n Reports