Skip to Content
author's profile photo Former Member
Former Member

Error in the SAP query for Assets?

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 10:22 AM

    Thanks !!!!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.