SAP Table ANLA
Asset Master Record Segment
ANLA (Asset Master Record Segment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ANLA to other SAP tables.
ANLA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T093C |
CHAR
|
4 | 0 | |||||||||||||
|
ANLN1
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||||||||
|
ANLN2
Asset Subnumber
|
ANLN2 |
CHAR
|
4 | 0 | ||||||||||||||
|
ANLKL
Asset Class
|
ANLKL | ANKA |
CHAR
|
8 | 0 | |||||||||||||
|
GEGST
Technical asset number
|
GEGST |
CHAR
|
8 | 0 | ||||||||||||||
|
ANLAR
Asset types
|
ANLAR |
CHAR
|
5 | 0 | ||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||||
|
AEDAT
Changed on
|
AEDAT_ANLA |
DATS
|
8 | 0 | ||||||||||||||
|
XLOEV
Indicator: Account marked for deletion?
|
XLOEV |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XSPEB
Indicator: Asset Locked to Acquisition Postings
|
XSPEB_ANLA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
FELEI
Screen layout for Asset Accounting
|
FELEI |
CHAR
|
4 | 0 | ||||||||||||||
|
KTOGR
Account determination
|
KTOGR | T095A |
CHAR
|
8 | 0 | |||||||||||||
|
XOPVW
Asset under construct. with line item settlement
|
OPVWA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ANLTP
Asset Category
|
ANLTP |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ZUJHR
Fiscal year in which first acquisition was posted
|
DZUJAHR |
NUMC
|
4 | 0 | ||||||||||||||
|
ZUPER
Period in which first acquisition was posted
|
DZUPER |
NUMC
|
3 | 0 | ||||||||||||||
|
ZUGDT
Asset value date of the first posting
|
DZUGDAT |
DATS
|
8 | 0 | ||||||||||||||
|
AKTIV
Asset capitalization date
|
AKTIVD |
DATS
|
8 | 0 | ||||||||||||||
|
ABGDT
Asset value date for the last retirement
|
ABGDAT |
DATS
|
8 | 0 | ||||||||||||||
|
DEAKT
Deactivation date
|
DEAKT |
DATS
|
8 | 0 | ||||||||||||||
|
GPLAB
Planned retirement date
|
GPLAB |
DATS
|
8 | 0 | ||||||||||||||
|
BSTDT
Asset purchase order date
|
BSTDT |
DATS
|
8 | 0 | ||||||||||||||
|
ORD41
Evaluation group 1
|
ORD41 | T087 |
CHAR
|
4 | 0 | |||||||||||||
|
ORD42
Evaluation group 2
|
ORD42 | T087 |
CHAR
|
4 | 0 | |||||||||||||
|
ORD43
Evaluation group 3
|
ORD43 | T087 |
CHAR
|
4 | 0 | |||||||||||||
|
ORD44
Evaluation group 4
|
ORD44 | T087 |
CHAR
|
4 | 0 | |||||||||||||
|
ANLUE
Asset super number
|
ANLUE | T087U |
CHAR
|
12 | 0 | |||||||||||||
|
ZUAWA
Key for sorting according to assignment numbers
|
DZUAWA | TZUN |
CHAR
|
3 | 0 | |||||||||||||
|
ANEQK
Indicator: Historical management
|
ANEQK |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ANEQS
Completeness indicator for the asset
|
ANEQS |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LIFNR
Account number of vendor (other key word)
|
AM_LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||
|
LAND1
Asset's country of origin
|
AM_LAND1 | T005 |
CHAR
|
3 | 0 | |||||||||||||
|
LIEFE
Name of asset supplier
|
LIEFE |
CHAR
|
30 | 0 | ||||||||||||||
|
HERST
Manufacturer of asset
|
HERST |
CHAR
|
30 | 0 | ||||||||||||||
|
EIGKZ
Property indicator
|
EIGKZ | T097 |
CHAR
|
1 | 0 | |||||||||||||
|
AIBN1
Original asset that was transferred
|
AIBN1 |
CHAR
|
12 | 0 | ||||||||||||||
|
AIBN2
Original asset that was transferred
|
AIBN2 |
CHAR
|
4 | 0 | ||||||||||||||
|
AIBDT
Original acquisition date of AuC/ transferred asset
|
AIBDT |
DATS
|
8 | 0 | ||||||||||||||
|
URJHR
Fiscal year of original acquisition
|
URJHR |
NUMC
|
4 | 0 | ||||||||||||||
|
URWRT
Original acquisition value
|
URWRT |
CURR
|
13 | 2 | ||||||||||||||
|
ANTEI
In-house production percentage
|
ANTEI |
DEC
|
5 | 2 | ||||||||||||||
|
PROJN
Old: Project number : No longer used --> PS_POSNR
|
PROJN |
CHAR
|
16 | 0 | ||||||||||||||
|
EAUFN
Investment Order
|
AM_AUFNR |
CHAR
|
12 | 0 | ||||||||||||||
|
MEINS
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
MENGE
Quantity
|
AM_MENGE |
QUAN
|
13 | 3 | ||||||||||||||
|
TYPBZ
Asset type name
|
TYPBZ_ANLA |
CHAR
|
15 | 0 | ||||||||||||||
|
IZWEK
Reason for investment
|
IZWEK | T087I |
CHAR
|
2 | 0 | |||||||||||||
|
INKEN
Inventory indicator
|
INKEN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
IVDAT
Last inventory date
|
IVDAT_ANLA |
DATS
|
8 | 0 | ||||||||||||||
|
INVZU
Supplementary inventory specifications
|
INVZU_ANLA |
CHAR
|
15 | 0 | ||||||||||||||
|
VMGLI
Property classification key
|
VMGLI | T092 |
CHAR
|
4 | 0 | |||||||||||||
|
XVRMW
Manual net worth tax value
|
XVRMW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
WRTMA
Manual net worth tax value
|
WRTMA |
CURR
|
13 | 2 | ||||||||||||||
|
EHWRT
Assessed value
|
EHWRT |
CURR
|
13 | 2 | ||||||||||||||
|
AUFLA
Date of conveyance
|
AUFLA_ANLA |
DATS
|
8 | 0 | ||||||||||||||
|
EHWZU
Date of last notice of assessment
|
EHWZU_ANLA |
DATS
|
8 | 0 | ||||||||||||||
|
EHWNR
Tax number of the notice of assessment
|
EHWNR_ANLA |
CHAR
|
16 | 0 | ||||||||||||||
|
GRUVO
Land Register of
|
GRUVO_ANLA |
DATS
|
8 | 0 | ||||||||||||||
|
GREIN
Land register entry on
|
GREIN_ANLA |
DATS
|
8 | 0 | ||||||||||||||
|
GRBND
Land register volume
|
GRBND_ANLA |
CHAR
|
5 | 0 | ||||||||||||||
|
GRBLT
Land register page
|
GRBLT_ANLA |
CHAR
|
5 | 0 | ||||||||||||||
|
GRLFD
Land register entry: Sequence number
|
GRLFD_ANLA |
CHAR
|
4 | 0 | ||||||||||||||
|
FLURK
Land register map number
|
FLURK_ANLA |
CHAR
|
4 | 0 | ||||||||||||||
|
FLURN
Plot number
|
FLURN_ANLA |
CHAR
|
10 | 0 | ||||||||||||||
|
FIAMT
Local tax office
|
FIAMT |
CHAR
|
25 | 0 | ||||||||||||||
|
STADT
Municipality
|
ORT01_ANLA |
CHAR
|
25 | 0 | ||||||||||||||
|
GRUND
Reason for manual valuation of net assets
|
GRUND | T098 |
CHAR
|
3 | 0 | |||||||||||||
|
FEINS
Area unit
|
FEINS | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
GRUFL
Surface area
|
GRUFL |
QUAN
|
13 | 3 | ||||||||||||||
|
INVNR
Inventory number
|
INVNR_ANLA |
CHAR
|
25 | 0 | ||||||||||||||
|
VBUND
Company ID of trading partner
|
RASSC | T880 |
CHAR
|
6 | 0 | |||||||||||||
|
SPRAS
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||
|
TXT50
Asset description
|
TXA50_ANLT |
CHAR
|
50 | 0 | ||||||||||||||
|
TXA50
Additional asset description
|
TXA50_MORE |
CHAR
|
50 | 0 | ||||||||||||||
|
XLTXID
Indicator: Long text active
|
XLTXID |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XVERID
Long text indicator:Property values
|
XVERID |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XTCHID
Indicator: Technical view long text
|
XTCHID |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XKALID
Indicator: Long text active
|
XKALID |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XHERID
Indicator: Long text for manufacturer/origin
|
XHERID |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XLEAID
Indicator: Leasing data long text
|
XLEAID |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LEAFI
Leasing company
|
LEAFI | LFA1 |
CHAR
|
10 | 0 | |||||||||||||
|
LVDAT
Leasing agreement date
|
LVDAT |
DATS
|
8 | 0 | ||||||||||||||
|
LKDAT
Leasing agreement notice date
|
LKDAT |
DATS
|
8 | 0 | ||||||||||||||
|
LEABG
Lease start date
|
LEABG |
DATS
|
8 | 0 | ||||||||||||||
|
LEJAR
Length of lease in years
|
LEJAR |
NUMC
|
3 | 0 | ||||||||||||||
|
LEPER
Length of lease in periods
|
LEPER |
NUMC
|
3 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LRYTH
Lease payment cycle
|
LRYTH |
NUMC
|
3 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LEGEB
Periodic lease payment paid to leasing company/lessor
|
LEGEB |
CURR
|
13 | 2 | ||||||||||||||
|
LBASW
Leasing base value as new
|
LBASW |
CURR
|
13 | 2 | ||||||||||||||
|
LKAUF
Leased asset purchase price
|
LKAUF |
CURR
|
13 | 2 | ||||||||||||||
|
LMZIN
Leasing monthly interest rate (Capital Lease)
|
LMZIN |
DEC
|
7 | 4 | ||||||||||||||
|
LZINS
Leasing interest rate (capital lease)
|
LZINS |
DEC
|
7 | 4 | ||||||||||||||
|
LTZBW
Posting date of the last lease payment
|
LTZBW |
DATS
|
8 | 0 | ||||||||||||||
|
LKUZA
Total of posted leasing payments
|
LKUZA |
CURR
|
13 | 2 | ||||||||||||||
|
LKUZI
Total leasing interest posted
|
LKUZI |
CURR
|
13 | 2 | ||||||||||||||
|
LLAVB
Total of long-term leasing liability
|
LLAVB |
CURR
|
13 | 2 | ||||||||||||||
|
LEANZ
Number of lease payments
|
LEANZ |
DEC
|
5 | 0 | ||||||||||||||
|
LVTNR
Leasing agreement number
|
LVTNR |
CHAR
|
15 | 0 | ||||||||||||||
|
LETXT
Leasing data text
|
LETXT |
CHAR
|
50 | 0 | ||||||||||||||
|
XAKTIV
Indicator: Capitalize fixed asset
|
XAKTIV |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ANUPD
Indicator: Type of change to table
|
ANUPD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LBLNR
No. of last document with which posting to asset was made
|
LBLNR |
CHAR
|
10 | 0 | ||||||||||||||
|
XV0DT
Change date: View 0
|
XV0DT |
DATS
|
8 | 0 | ||||||||||||||
|
XV0NM
Name of person in charge, who changed View0
|
XV0NM |
CHAR
|
12 | 0 | ||||||||||||||
|
XV1DT
Change date: View 1
|
XV1DT |
DATS
|
8 | 0 | ||||||||||||||
|
XV1NM
Name of person in charge, who changed view 1
|
XV1NM |
CHAR
|
12 | 0 | ||||||||||||||
|
XV2DT
Change date: View 2
|
XV2DT |
DATS
|
8 | 0 | ||||||||||||||
|
XV2NM
Name of the person in charge, who changed view 2
|
XV2NM |
CHAR
|
12 | 0 | ||||||||||||||
|
XV3DT
Change date: View 3
|
XV3DT |
DATS
|
8 | 0 | ||||||||||||||
|
XV3NM
Name of the person in charge, who changed view 3
|
XV3NM |
CHAR
|
12 | 0 | ||||||||||||||
|
XV4DT
Change date: View 4
|
XV4DT |
DATS
|
8 | 0 | ||||||||||||||
|
XV4NM
Name of the person in charge, who changed view 4
|
XV4NM |
CHAR
|
12 | 0 | ||||||||||||||
|
XV5DT
Change date:View 5
|
XV5DT |
DATS
|
8 | 0 | ||||||||||||||
|
XV5NM
Name of the person in charge who changed view 5
|
XV5NM |
CHAR
|
12 | 0 | ||||||||||||||
|
XV6DT
Change date:View 6
|
XV6DT |
DATS
|
8 | 0 | ||||||||||||||
|
XV6NM
Name of the person in charge who changed view 6
|
XV6NM |
CHAR
|
12 | 0 | ||||||||||||||
|
AIMMO
Indicator: real estate
|
AIMMO |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||||
|
LEART
Leasing type
|
LEART | T083L |
CHAR
|
2 | 0 | |||||||||||||
|
LVORS
Advance payments
|
LVORS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
GDLGRP
Evaluation group 5
|
GDLGRP | T087G |
CHAR
|
8 | 0 | |||||||||||||
|
POSNR
WBS element investment project
|
AM_POSNR | PRPS |
NUMC
|
8 | 0 | |||||||||||||
|
XERWRT
Indicator: Ignore memo value
|
XERWRT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XAFABCH
Asset acquired used
|
XAFABCH |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XANLGR
Indicator: Asset is a group asset
|
XANLGR_1 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MCOA1
Search term for matchcode search
|
MCOA1 |
CHAR
|
30 | 0 | ||||||||||||||
|
XINVM
Asset under Construction for Investment Measures
|
IM_XINVM |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
SERNR
Serial number
|
AM_SERNR |
CHAR
|
18 | 0 | ||||||||||||||
|
UMWKZ
Reason for environmental investment
|
AM_UMWKZ | T087K |
CHAR
|
5 | 0 | |||||||||||||
|
LRVDAT
Date of last revaluation
|
AM_LRVDAT |
DATS
|
8 | 0 | ||||||||||||||
|
ACT_CHANGE_PM
Change Asset Master Record from Equipment Master
|
AAPM_ACT_CHANGE_PM |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
HAS_TDDP
Asset Has Time-Dependent Valuation Parameters in ANLBZA
|
HAS_TDDP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LAST_REORG_DATE
Date of Last Reorganization
|
FAA_LAST_REORG |
DATS
|
8 | 0 | ||||||||||||||
ANLA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ANLA | ANLKL | ANLA | MANDT |
ANKA
Asset classes: general data
|
MANDT |
| ANLA | ANLKL | ANLA | ANLKL |
ANKA
Asset classes: general data
|
ANLKL |
| ANLA | ANLN1 | ANLA | MANDT |
ANLH
Main asset number
|
MANDT |
| ANLA | ANLN1 | ANLA | BUKRS |
ANLH
Main asset number
|
BUKRS |
| ANLA | ANLN1 | ANLA | ANLN1 |
ANLH
Main asset number
|
ANLN1 |
| ANLA | ANLUE | ANLA | MANDT |
T087U
Asset group number / asset group
|
MANDT |
| ANLA | ANLUE | ANLA | ANLUE |
T087U
Asset group number / asset group
|
ANLUE |
| ANLA | BUKRS | ANLA | MANDT |
T093C
Company codes in Asset Accounting
|
MANDT |
| ANLA | BUKRS | ANLA | BUKRS |
T093C
Company codes in Asset Accounting
|
BUKRS |
| ANLA | EIGKZ | ANLA | MANDT |
T097
Property indicator
|
MANDT |
| ANLA | EIGKZ | ANLA | EIGKZ |
T097
Property indicator
|
EIGKZ |
| ANLA | FEINS | ANLA | MANDT |
T006
Units of Measurement
|
MANDT |
| ANLA | FEINS | ANLA | FEINS |
T006
Units of Measurement
|
MSEHI |
| ANLA | GDLGRP | ANLA | MANDT |
T087G
Evaluation group 8 places
|
MANDT |
| ANLA | GDLGRP | ANLA | GDLGRP |
T087G
Evaluation group 8 places
|
GDLGRP |
| ANLA | GRUND | ANLA | MANDT |
T098
Basis manual property evaluation
|
MANDT |
| ANLA | GRUND | ANLA | GRUND |
T098
Basis manual property evaluation
|
GRUND |
| ANLA | IZWEK | ANLA | MANDT |
T087I
Reason for investment
|
MANDT |
| ANLA | IZWEK | ANLA | IZWEK |
T087I
Reason for investment
|
IZWEK |
| ANLA | KTOGR | ANLA | MANDT |
T095A
Account allocation
|
MANDT |
| ANLA | KTOGR | ANLA | KTOGR |
T095A
Account allocation
|
KTOGR |
| ANLA | LAND1 | ANLA | MANDT |
T005
Countries
|
MANDT |
| ANLA | LAND1 | ANLA | LAND1 |
T005
Countries
|
LAND1 |
| ANLA | LEAFI | ANLA | LEAFI |
LFA1
Vendor Master (General Section)
|
LIFNR |
| ANLA | LEAFI | ANLA | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| ANLA | LEART | ANLA | MANDT |
T083L
Leasing types
|
MANDT |
| ANLA | LEART | ANLA | LEART |
T083L
Leasing types
|
LEART |
| ANLA | LIFNR | ANLA | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| ANLA | LIFNR | ANLA | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| ANLA | MEINS | ANLA | MANDT |
T006
Units of Measurement
|
MANDT |
| ANLA | MEINS | ANLA | MEINS |
T006
Units of Measurement
|
MSEHI |
| ANLA | OBJNR | ANLA | MANDT |
ONR00
General Object Number
|
MANDT |
| ANLA | OBJNR | ANLA | OBJNR |
ONR00
General Object Number
|
OBJNR |
| ANLA | ORD41 | ANLA | MANDT |
T087
Evaluation groups
|
MANDT |
| ANLA | ORD41 | '1' |
T087
Evaluation groups
|
ORDNR | |
| ANLA | ORD41 | ANLA | ORD41 |
T087
Evaluation groups
|
ORD4X |
| ANLA | ORD42 | ANLA | ORD42 |
T087
Evaluation groups
|
ORD4X |
| ANLA | ORD42 | ANLA | MANDT |
T087
Evaluation groups
|
MANDT |
| ANLA | ORD42 | '2' |
T087
Evaluation groups
|
ORDNR | |
| ANLA | ORD43 | ANLA | MANDT |
T087
Evaluation groups
|
MANDT |
| ANLA | ORD43 | '3' |
T087
Evaluation groups
|
ORDNR | |
| ANLA | ORD43 | ANLA | ORD43 |
T087
Evaluation groups
|
ORD4X |
| ANLA | ORD44 | '4' |
T087
Evaluation groups
|
ORDNR | |
| ANLA | ORD44 | ANLA | ORD44 |
T087
Evaluation groups
|
ORD4X |
| ANLA | ORD44 | ANLA | MANDT |
T087
Evaluation groups
|
MANDT |
| ANLA | POSNR | ANLA | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| ANLA | POSNR | ANLA | POSNR |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| ANLA | SPRAS | ANLA | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| ANLA | UMWKZ | ANLA | MANDT |
T087K
Reason for investment protecting the environment
|
MANDT |
| ANLA | UMWKZ | ANLA | UMWKZ |
T087K
Reason for investment protecting the environment
|
UMWKZ |
| ANLA | VBUND | ANLA | MANDT |
T880
Global Company Data (for KONS Ledger)
|
MANDT |
| ANLA | VBUND | ANLA | VBUND |
T880
Global Company Data (for KONS Ledger)
|
RCOMP |
| ANLA | VMGLI | ANLA | VMGLI |
T092
Property classification key
|
VMGLI |
| ANLA | VMGLI | ANLA | MANDT |
T092
Property classification key
|
MANDT |
| ANLA | ZUAWA | ANLA | ZUAWA |
TZUN
Rules for 'Allocation' Field Layout
|
ZUAWA |