Asset Subledger Balance Table

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, Baz, darkduck

Post Reply
pacers37
Posts: 44
Joined: Thu Aug 25, 2005 8:56 am

Asset Subledger Balance Table

Post by pacers37 » Sun Jan 21, 2007 1:19 pm

Hi All,

Any one has idea on sub-ledger asset balance table like BSIK & BSID which is for customers & vendors.

Thanks,
Pacers.

Biker
Posts: 980
Joined: Mon Oct 21, 2002 7:19 am
Location: Here, obviously

Post by Biker » Mon Jan 22, 2007 1:07 am

There is no such table per se.
The one carrying values in subledger is ANLP.
Bike®
If you can't join them, beat them!

pacers37
Posts: 44
Joined: Thu Aug 25, 2005 8:56 am

Subledger balances

Post by pacers37 » Fri Jan 26, 2007 12:48 pm

Extract from the table ANLC (Asset Value Fields) then we need to extract from the table ANLA (Asset Master Record Segment) by Company Code, Asset Number and Asset Sub-Number these are the unique combination to get the Account Determination because G/L accounts are assigned at asset class level .We have to use this account determination in the table T095 (Balance Sheet Account for Depreciation Areas) to get the G/L Account #.

I have a Question :
Which are the fields which values to pick from ANLC and wt values hit the GL # and wt type of accts.How to get the grooss amount
Because we are trying to extract from Asset accounting and do the reconciliation in exterval soft ware.Asset balances should tie the G/L Account .

Post Reply