Asset Accounting Tables

[Former Member]

Hi,

I am new to asset accounting and I am looking to find the fields in SAP tables for the following descriptions. If anybody has any idea please let me know the tables and the fields that will be suitable.

<u><b>Asset Accounting</b></u>

Entity

Division

Asset Number

Asset Description

Asset Location Identifier

Purchase Price / Depreciable Basis

Acquisition Date)

Date Placed into Service

Asset Life for book purposes

MACRS Classification

Depreciation taken for period (Tax)

Method of Depreciation (Tax)

Accumulated Depreciation (Tax)

Conventions Used (1/2yr, 1/4yr, etc. - Tax)

Any field that identifies the intended function of the asset (e.g. Tooling used in Production)

Nature of the Asset (Real Property)

Date of Asset Retirement

[Former Member]

Check with below Tables :

ANKA Asset Classes: General Data ANLKL

ANKP Asset Classes: Fld Cont Dpndnt on Chart ANLKL / AFAPL

of Depreciation

ANKT Asset Classes: Description SPRAS / ANLKL

ANKV Asset Classes: Insurance Types ANLKL / VRSLFD

ANLA Asset Master Record Segment BUKRS / ANLN1 / ANLN2

ANLB Depreciation Terms BUKRS / ANLN1 / ANLN2 / AFABE

/ BDATU

ANLT Asset Texts SPRAS / BUKRS / ANLN1 / ANLN2

ANLU Asset Master Record User Fields .INCLUDE / BUKRS / ANLN1 / ANLN2

ANLW Insurable Values (Year Dependent) BUKRS / ANLN1 / ANLN2 / VRSLFD /

GJAHR

ANLX Asset Master Record Segment BUKRS / ANLN1 / ANLN2

ANLZ Time Dependent Asset Allocations BUKRS / ANLN1 / ANLN2 / BDATU

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

ANAR Asset Types ANLAR

ANAT Asset Type Text SPRAS / ANLAR

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

Asset Accounting

ANEK Document Header Asset Posting BUKRS / ANLN1 / ANLN2 / GJAHR /

LNRAN

ANEP Asset Line Items BUKRS / ANLN1 / ANLN2 / GJAHR /

LNRAN / AFABE

ANEV Asset Downpymt Settlement BUKRS / ANLN1 / ANLN2 / GJAHR /

LNRANS

ANKB Asset Class: Depreciation Area ANLKL / AFAPL / AFABE / BDATU

ANLC Asset value Fields BUKRS / ANLN1 / ANLN2 / GJAHR /

AFABE

ANLH Main Asset Number BUKRS / ANLN1

ANLP Asset Periodic Values BUKRS / GJAHR / PERAF / AFBNR /

ANLN1 / ANLN2 / AFABER

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

GB03 Validation / Substitution User VALUSER

GB92 Substitutions SUBSTID

GB93 Validation VALID

Thanks

Seshu

[Former Member]

check finance tables...

Finance 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

Reward Points

[Former Member]

Hi

Check the tables starting with AN* in se11

Most of the Asset related are AN* with 4 letters.

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

Thx for all. But, i have the vast list of all the tables. But, I am looking for specific Tables and the fields in it which are suitable for above requirement..

[Former Member]

You get all the fields from this tables :

ANLA

ANLH

ANLT

ANKB

ANLP

Check the LDB - ADA In SE36 Transaction or Transaction S_ALR_87011978 to get more information

Thanks

Seshu

[Former Member]

Hi,

To find the table names inwhich these fields are being used. Go for below mentioned procedure:

Go to Tcode - SE84.

Now expend the node ABAP Dictionary.

Now expend the node FIELDS.

Now double click on TABLE FIELDS.

On the right hand side you will have one window. Here provide the short description & execute.

It will display all the table names & fields.

Reward points if helpful answer.

Ashvender

[mahmcma]

These are tables most commonly used in Fixed Asset module.

ANLA - Asset Master Record Segment

ANLB - Depreciation terms

ANLC - Asset Value Fields

ANLP Asset Periodic Values

ANLT Asset Texts

ANLU Asset Master Record User Fields

ANLW Insurable Values (Year Dependent)

ANLX Asset Master Record Segment

ANLZ Time Dependent Asset Allocations

ANEK - Document Header Asset Posting

ANEP - Asset Line Items

ANLH - Main asset number

ANEV - Asset downpymt settlement

ANKA Asset Classes: General Data

ANKP Asset Classes: Fld Cont Dpndnt on Chart of Depreciation

ANKT Asset Classes: Description

ANKV Asset Classes: Insurance Types

ANAR Asset Types

ANAT - Asset type text

[mahmcma]

These are tables most commonly used in Fixed Asset module.

ANLA - Asset Master Record Segment

ANLB - Depreciation terms

ANLC - Asset Value Fields

ANLP Asset Periodic Values

ANLT Asset Texts

ANLU Asset Master Record User Fields

ANLW Insurable Values (Year Dependent)

ANLX Asset Master Record Segment

ANLZ Time Dependent Asset Allocations

ANEK - Document Header Asset Posting

ANEP - Asset Line Items

ANLH - Main asset number

ANEV - Asset downpymt settlement

ANKA Asset Classes: General Data

ANKP Asset Classes: Fld Cont Dpndnt on Chart of Depreciation

ANKT Asset Classes: Description

ANKV Asset Classes: Insurance Types

ANAR Asset Types

ANAT - Asset type text