Important Tables in SAP FI & CO ( Controlling )

SAP Asset Accounting Tables

 

FI-AA-AA (AA) – Asset Accounting: Basic Functions – Master Data

 

Table Name : ANKA

Table Purpose : Asset Classes: General Data

Fields : ANLKL

 

Table Name : ANKP

Table Purpose : Asset Classes: Fld Cont Dpndnt on Chart of Depreciation

Fields:

  • ANLKL
  • AFAPL

 

Table Name : ANKT

Table Purpose : Asset Classes: Description

Fields:

  • SPRAS
  • ANLKL

 

Table Name : ANKV

Table Purpose : Asset Classes: Insurance Types

Fields:

  • ANLKL
  • VRSLFD

 

Table Name : ANLA

Table Purpose : Asset Master Record Segment

Fields:

  • BUKRS
  • ANLN1
  • ANLN2

 

Table Name : ANLB

Table Purpose : Depreciation Terms

Fields:

  • BUKRS
  • ANLN1
  • ANLN2
  • AFABE
  • BDATU

 

Table Name : ANLT

Table Purpose : Asset Texts

Fields:

  • SPRAS
  • BUKRS
  • ANLN1
  • ANLN2

 

 

Table Name : ANLU

Table Purpose : Asset Master Record User Fields

Fields:

  • .INCLUDE
  • BUKRS
  • ANLN1
  • ANLN2

 

Table Name : ANLW

Table Purpose : Insurable Values (Year Dependent)

Fields:

  • BUKRS
  • ANLN1
  • ANLN2
  • VRSLFD
  • GJAHR

 

Table Name : ANLX

Table Purpose : Asset Master Record Segment

Fields:

  • BUKRS
  • ANLN1
  • ANLN2

 

Table Name : ANLZ

Table Purpose : Time Dependent Asset Allocations

Fields:

  • BUKRS
  • ANLN1
  • ANLN2
  • BDATU

 

FI-AA-AA (AA2)   Asset Accounting: Basic Functions – Master Data 2.0

 

Table Name : ANAR

Table Purpose : Asset Types

Fields:

  • ANLAR

 

Table Name : ANAT

Table Purpose : Asset Type Text

Fields:

  • SPRAS
  • ANLAR

 

FI-AA-AA (AB) – Asset Accounting: Basic Functions – Asset Accounting

 

Table Name : ANEK

Table Purpose : Document Header Asset Posting

Fields:

  • BUKRS
  • ANLN1
  • ANLN2
  • GJAHR
  • LNRAN

 

Table Name : ANEP

Table Purpose : Asset Line Items

Fields:

  • BUKRS
  • ANLN1
  • ANLN2
  • GJAHR
  • LNRAN
  • AFABE

 

Table Name : ANEV

Table Purpose : Asset Downpymt Settlement

Fields:

  • BUKRS
  • ANLN1
  • ANLN2
  • GJAHR
  • LNRANS

 

Table Name : ANKB

Table Purpose : Asset Class: Depreciation Area

Fields:

  • ANLKL
  • AFAPL
  • AFABE
  • BDATU

 

Table Name : ANLC

Table Purpose : Asset value Fields

Fields:

  • BUKRS
  • ANLN1
  • ANLN2
  • GJAHR
  • AFABE

 

Table Name : ANLH

Table Purpose : Main Asset Number

Fields:

  • BUKRS
  • ANLN1

 

Table Name : ANLP

Table Purpose : Asset Periodic Values

Fields:

  • BUKRS
  • GJAHR
  • PERAF
  • AFBNR
  • ANLN1
  • ANLN2
  • AFABER

 

FI-SL-VSR (GVAL) Special Purpose Ledger: Validation, Substitution and Rules

 

Table Name : GB03

Table Purpose : Validation / Substitution User

Fields:

  • VALUSER

 

Table Name : GB92

Table Purpose : Substitutions

Fields:

  • SUBSTID

 

Table Name : GB93

Table Purpose : Validation

Fields:

  • VALID