Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Balance Sheet Report

Former Member

‎2007 Jun 26 5:45 AM

0 Likes
660

Hi

I developed one report to get all the open balances by giving company code,

fiscal year period and cost center profit center etc

I retrieved the data using BSIS and BSEG tables

But ASSET related GL Account Balances are not getting because

any of the parameters like profit center cost center are not stored in BSIS and BSEG Tables

Any one can give me the idea to retrive the ASSET Related balances from which tables

Thanks in advance

venkat

Hi

I developed one report to get all the open balances by giving company code,

fiscal year period and cost center profit center etc

I retrieved the data using BSIS and BSEG tables

But ASSET related GL Account Balances are not getting because

any of the parameters like profit center cost center are not stored in BSIS and BSEG Tables

Any one can give me the idea to retrive the ASSET Related balances from which tables

Thanks in advance

venkat

Reply
3 REPLIES 3
Read only

Former Member

‎2007 Jun 26 6:43 AM

0 Likes
572

Hi,

you can retrieve asset related fields by using following table in your code

ANAR -

Asset Types

ANAT -

Asset type text

ANEP -

Asset Line Items

ANEV -

Asset downpymt settlement

ANKT -

Asset classes- Description

ANLA -

Asset Master Record Segment

******please reward points if the information is helpful to you*******

Read only

Former Member

‎2007 Jun 26 6:49 AM

0 Likes
572

check ANEP for asset transactions & ANLC for asset values

raj

Read only

Former Member

‎2007 Jun 26 6:56 AM

0 Likes
572

Check the tables like ^

ANAR Asset Types

ANAT Asset type text

ANEA Asset Line Items for Proportional Values

ANEK Document Header Asset Posting

ANEP Asset Line Items

ANEV Asset downpymt settlement

ANGA Asset catalog general data

ANGB Asset catalog deprec. area

ANGT Asset catalog text table

ANIA Depr. simulation for invest. projects

ANIB Investment projects depr. simulation depr. areas

ANKA Asset classes: general data

ANKAZ Asset class: extension for technical fields

ANKB Asset class: depreciation area

ANKL Generation table for generating asset classes from accounts

ANKLAY Asset class: Assignment of tab layouts

ANKLAYP Asset class: Assignment of tab layouts

ANKP Asset classes: Fld Cont Dpndnt on Chart of Depreciation

ANKT Asset classes: Description

ANKV Asset classes: insurance types

ANLA Asset Master Record Segment

ANLB Depreciation terms

ANLBZW Asset-specific base values

ANLC Asset Value Fields

ANLE Asset Origin by Line Item

ANLH Main asset number

ANLI Link table for investment measure -> AuC

ANLK Asset Origin by Cost Element

ANLP Asset Periodic Values

ANLQ Period values from dep. posting run per posting level

ANLT Asset Texts

ANLU Asset Master Record: User Fields

ANLV Insurance data

ANLW Insurable values (year dependent)

ANLX Asset Master Record Segment

ANLZ Time-Dependent Asset Allocations

If useful reward.

Regards