table and field name for asset master and transaction data

[Former Member]

Hi Gurus

Can you tell me in what table and the field name for the following asset related data:

Acquisition value (for example asset #30033530 would be $1,278.82)

Accumulated depreciation

Current NBV

Thanks in advance

Satya

[Former Member · Accepted solution]

Hi,

Ket for the below is - Table Name - Field Name

Acquisition value:

Cumulative acquisition value at FY start (w/o inv.support) : ANLCV-BEST_GJA

Asset acquisition value at end of fiscal year: ANLCV-GJE_KANSW

Accumulated depreciation:

Accumulated ordinary depreciation: ANLCV-KNAFA

Accumulated depreciation at fiscal year start: ANLCV-AFA_GJA

Current NBV:

Book value at fiscal year end: ANLCV-BCHWRT_GJE

Hope this helps.

Please assign points as a way to say thanks.

Regards,

[former_member197269]

Please refer below link:

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

Hope this helps

Please assign points as way to say thanks

[Former Member]

Hi There

I checked those tables.I need the field ( table ) for following fields.

Acquisition value (for example asset #30033530 would be $1,278.82)

Accumulated depreciation

Current NBV

When I check the F1 and tech details, it shows the structure etc.

Any help appreciated as we are migrating some old legacy data.

Thanks

satya