Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

re: query report

hi experts,

i want to prepare a query in sq01 for following fields.

asset class, desc of asset, retirement (cost of disposal value) , depr retired, ret book value, disposal amount, gain or loss the same sequence i can see in s_alr_87012052 but i want to see only disposal but in this report i can see write off & disposal.

so if anybody have detail steps how to create a query let me know.

the tables for this query is

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.

ANKA Asset classes: general data

ANKAZ Asset class: extension for technical field

ANKB Asset class: depreciation area

ANKL Generation table for generating asset clas

ANKLAY Asset class: Assignment of tab layouts

ANKLAYP Asset class: Assignment of tab layouts

ANKP Asset classes: Fld Cont Dpndnt on Chart of

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

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 po

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

thanks in advance,


Former Member


Go to SQ00

Click on Quick Viewer

Give your query name


Select Description

Select Logical Database

Give your logical data base.

Select your list fields and selection fields

Save it.

Execute it.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question