on 04-28-2009 5:32 AM
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,
kk.
Hello,
You cannot join all these tables.
SAP has provided for logical database for assets in SQ00, use the same.
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.