SAP FI TABLES

FI Tables

AGKO	Cleared Accounts
ANAR	Asset Types
ANAT	Asset type text
ANEK	Document Header Asset Posting
ANEP	Asset Line Items
ANEV	Asset downpymt settlement
ANKT	Asset classes- Description
ANLA	Asset Master Record Segment
ANLB	Depreciation terms
ANLC	Asset Value Fields
ANLH	Main asset number
AT02T	Transaction Activity Category- Description
AT02A	Transaction Code for Menu TIMN
AT10	Transaction type
AT10T	Name of Transaction Type
BKDF	Document Header Supplement for Recurring Entry
BKORM	Accounting Correspondence Requests
BKPF	Accounting Document Header
BLPK	Document log header
BLPP	Document log item
BLPR	Document Log Index and Planned Order (Backflush)
BNKA	Bank master record
BP000	Business Partner Master (General Data)
BPBK	Doc.Header Controlling Obj.
BPEG	Line Item Total 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.
BPJA	Totals Record for Annual Total Controlling Obj.
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)
BSEC	One-Time Account Data Document Segment
BSEG	Accounting Document Segment
BSID	Accounting- Secondary Index for Customers
BSIK	Accounting- Secondary Index for Vendors
BSIM	Secondary Index, Documents for Material
BSIS	Accounting- Secondary Index for G/L Accounts
CEPC	Profit Center Master Data Table
CEPCT	Texts for Profit Center Master Data
COBRA	Settlement Rule for Order Settlement
COBRB	Distribution Rules Settlement Rule Order Settlement
COKA	CO Object- Control Data for Cost Elements
COSP	CO Object- Cost Totals for External Postings
COSS	CO Object- Cost Totals for Internal Postings
CRCO	Assignment of Work Center to Cost Center
CSKA	Cost Elements (Data Dependent on Chart of Accounts)
CSKB	Cost Elements (Data Dependent on Controlling Area)
CSLA	Activity master
FEBEP	Electronic Bank Statement Line Items
FPLA	Billing Plan
FPLT	Billing Plan- Dates
GLPCT	EC-PCA- Totals Table
KNA1	General Data in Customer Master
KOMK	Pricing Communication Header
MAHNV	Management Records for the Dunning Program
REGUT	TemSe - Administration Data
SKA1	G/L Account Master (Chart of Accounts)
SKAT	G/L Account Master Record (Chart of Accounts- Description)
SKB1	G/L account master (company code)
T003T	Document Type Texts
T007S	Tax Code Names
T087J	Text
TAPRFT	Text tab. for investment profile
TKA01	Controlling Areas
TKA09	Basic Settings for Versions
TKVS	CO Versions
TZB0T	Flow types text table
TZPAT	Financial Assets Management product type texts
VBSEGS	Document Segment for G/L Accounts Document Parking
VTBFHA	Transaction
VTBFHAPO	Transaction Flow
VTBFHAZU	Transaction Activity
VTBFINKO	Transaction Condition
VTIDERI	Master Data Listed Options and Futures
VTIFHA	Underlying transaction
VTIFHAPO	Underlying transaction flows
VTIFHAZU	Underlying transaction status table
VTIOF	Options Additional Data
VWPANLA	Asset master for securities

SAP FICO ASSETS MANAGEMENT Issue - 47

Issue No.: 47
The user is configuring the depreciation key. He has a unique requirement for calculating depreciation for the month of acquisition as well as retirement. Here is the requirement:If the asset is purchased from the 1st to the 15th of a month, the depreciation should be calculated for the full month. If the assets are purchased after the 15th of a month, then no depreciation for the month of purchase is calculated. However, depreciation should be calculated for the full month for subsequent months.

The start date and end date of depreciation are controlled through the period control method. You are assigning a calendar here to control how depreciation will be calculated for the acquisition month.
See your configuration by using transaction code OAVH (menu path: IMG → Financial Accounting → Asset Accounting → Depreciation → Valuation Methods → Period Control → Define Calendar Assignments).

SAP FICO ASSETS MANAGEMENT Issue - 46

Issue No.: 46
In January 2008, a user noticed that assets purchased in 2007 were not recorded in the books of account. In the meantime, the user closed the books of account for 2007. Now the user wants to disclose this asset in his books of account from January 2008. 

This issue can be handled in two different ways, depending upon user requirements, i.e., from which date the user wants to calculate depreciation expenses.

1. If the user wants to calculate depreciation from January 2008, then post the asset acquisition using transaction code F-90 with reference to a vendor or using transaction code F-91 through a clearing account.

2. If the user wants to charge depreciation starting from the original purchase date, then post the acquisition through transaction code ABNAN. Then enter that date, 07/01/2007 in this example, in the Orig. val.dat field as shown in

Figure Using transaction code ABNAN

SAP FICO ASSETS MANAGEMENT Issue -45

Issue No.: 45
The user wants to attach JPG pictures of assets to the asset master record. How can he do this?

You can attach JPG pictures to an asset master. From the asset master record menu, choose System → Services for Object → Create Attachment.

SAP FICO ASSETS MANAGEMENT Issue - 44

Issue No.: 44
The user acquired his first set of assets in the month of February 2008 and is trying to run depreciation starting from February. While running depreciation, the system returns the following message: "According to the posting cycle, you should post period 001 next. Either enter period 001, which corresponds to the posting cycle, or request an unplanned posting run explicitly for this parameter."

If your posting cycle is monthly, then your SAP solution expects depreciation to run for every period in sequential order. So, you can't run February until you have completed the January depreciation run. Since you have acquired assets in the month of February, you are not running depreciation for the month of January. However, SAP R/3 is expecting you to run depreciation for January also. To overcome this, you have to do one of the following:
(1) run depreciation for the month of  January and then the month of February or
(2) select the unplanned posting run for February. The unplanned run lets you skip over periods (in instances like this).

SAP FICO ASSETS MANAGEMENT Issue - 30

Issue No.: 30
After the depreciation run, the user changed the capitalized date and the depreciation start date in the asset master. After making changes in the asset master, the user once again ran depreciation in "repeat run" mode. But changes made to the asset master did not hit depreciation, and the difference value is appearing as a planned value when checked in T-code AW01N.

If you are making any changes in the asset master that affect depreciation that is already posted, you must follow this procedure:
1. Recalculate depreciation using T-code AFAR.
2. Repeat the depreciation run using T-code AFAB.

SAP FICO ASSETS MANAGEMENT Issue - 29

Issue No.: 29
The user wants to transfer an asset from one asset class to another asset class. A depreciation expense of the new asset class is assigned to another account determination. The user wants to transfer APC, accumulated depreciation, and depreciation expenses to G/L accounts that are assigned to the new asset class. Transaction code ABUMN has fields for ACP and accumulated depreciation. The user is wondering how depreciation expenses will be transferred from the old accounts to the new account.

Through transaction code ABUMN, you can reclassify assets. In the reclassification process, you can only transfer APC and accumulated costs to a new asset class with immediate effect. Depreciation expenses will be transferred to the new G/L when you run depreciation. However, during the depreciation run, you can't transfer previous depreciation expenses that were already charged to the cost center. But you can transfer current-year depreciation to the new depreciation expenses account. While entering the transaction in transaction code ABUMN, enter in the value date field the date on which you want to transfer your expenses to the new account.