Error in the SAP query for Assets?

[Former Member]

Hi,

I am trying to make 2 queries related to the assets but it is not selecting the data may I know why and where I am doing wrong.

I have joined the tables ANLA, ANLC, ANLP and ANLB.

Fields that have been selected are as follows:

Asset Subnumber ANLA-ANLN2

Asset Class ANLA-ANLKL

Asset description ANLA-TXT50

Company Code ANLA-BUKRS

Serial number ANLA-SERNR

Main Asset Number ANLA-ANLN1

Asset Subnumber ANLA-ANLN2

Asset Class ANLA-ANLKL

Asset description ANLA-TXT50

Company Code ANLA-BUKRS

Serial number ANLA-SERNR

Main Asset Number ANLA-ANLN1

Fiscal Year ANLC-GJAHR

Ordinary depreciation posted in the current year ANLC-NAFAG

Planned ordinary depreciation for the year ANLC-NAFAP

Accumulated ordinary depreciation ANLC-KNAFA

Cumulative acquisition and production costs ANLC-KANSW

Asset Subnumber ANLA-ANLN2

Asset Class ANLA-ANLKL

Asset description ANLA-TXT50

Company Code ANLA-BUKRS

Serial number ANLA-SERNR

Main Asset Number ANLA-ANLN1

Fiscal Year ANLC-GJAHR

Ordinary depreciation posted in the current year ANLC-NAFAG

Planned ordinary depreciation for the year ANLC-NAFAP

Accumulated ordinary depreciation ANLC-KNAFA

Cumulative acquisition and production costs ANLC-KANSW

Transactions for the year affecting asset values ANLP-ANSWL

Planned ordinary depreciation for the year ANLP-NAFAP

Ordinary depreciation posted in the current year ANLP-NAFAG

Ordinary depreciation to be posted ANLP-NAFAZ

Asset acquisition year (currently not used) ANLP-ZUJHR

Depreciation calculation period ANLP-PERAF

Original useful life in years ANLB-NDURJ

Depreciation key ANLB-AFASL

Please tell me where SAP query is no working and what shall I do to make it work.

Thanks and regards

Nitin

[Former Member]

Thanks !!!!