Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Thanks Mr. Gary McSorley!
It has been done as I was selecting some fields which were not relevant.
Regards
Nitin
| | | ---------------Original Message---------------
From: Tiger100
Sent: Friday, December 09, 2011 12:41 AM
Subject: 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 |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Tiger100
SAP Accounting Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight   _.____.__ |
