SAP Table ANTS
Substructure of Asset Master Record (ANLA)
ANTS (Substructure of Asset Master Record (ANLA)) 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 ANTS to other SAP tables.
ANTS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||
|
ANLN1
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||||||||
|
ANLN2
Asset Subnumber
|
ANLN2 | ANLA |
CHAR
|
4 | 0 | |||||||||||||
|
ANLKL
Asset Class
|
ANLKL | ANKA |
CHAR
|
8 | 0 | |||||||||||||
|
ANEQS
Completeness indicator for the asset
|
ANEQS |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XLOEV
Indicator: Account marked for deletion?
|
XLOEV |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XSPEB
Indicator: Is Account Blocked for Posting?
|
XSPEB |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BEGRU
Authorization Group
|
BRGRU |
CHAR
|
4 | 0 | ||||||||||||||
|
ANLTP
Asset Category
|
ANLTP |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||||
|
KTOGR
Account determination
|
KTOGR | T095A |
CHAR
|
8 | 0 | |||||||||||||
|
ZUGDT
Asset value date of the first posting
|
DZUGDAT |
DATS
|
8 | 0 | ||||||||||||||
|
ZUPER
Period in which first acquisition was posted
|
DZUPER |
NUMC
|
3 | 0 | ||||||||||||||
|
ZUJHR
Asset acquisition year (currently not used)
|
DZUJHR |
NUMC
|
4 | 0 | ||||||||||||||
|
AKTIV
Asset capitalization date
|
AKTIVD |
DATS
|
8 | 0 | ||||||||||||||
|
DEAKT
Deactivation date
|
DEAKT |
DATS
|
8 | 0 | ||||||||||||||
|
ABGDT
Asset value date for the last retirement
|
ABGDAT |
DATS
|
8 | 0 | ||||||||||||||
|
AIBDT
Original acquisition date of AuC/ transferred asset
|
AIBDT |
DATS
|
8 | 0 | ||||||||||||||
|
KOSTL
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||||||||
|
LSTAR
Activity Type
|
LSTAR |
CHAR
|
6 | 0 | ||||||||||||||
|
EAUFN
Investment order
|
EAUFN | AUFK |
CHAR
|
12 | 0 | |||||||||||||
|
POSNR
WBS element investment project
|
AM_POSNR |
NUMC
|
8 | 0 | ||||||||||||||
|
PROJN
Old: Project number : No longer used --> PS_POSNR
|
PROJN |
CHAR
|
16 | 0 | ||||||||||||||
|
KOSTLV
Cost center responsible for asset
|
KOSTLV |
CHAR
|
10 | 0 | ||||||||||||||
|
STORT
Asset location
|
STORT |
CHAR
|
10 | 0 | ||||||||||||||
|
RAUMN
Room
|
RAUMNR |
CHAR
|
8 | 0 | ||||||||||||||
|
IAUFN
Maintenance order
|
IAUFN |
CHAR
|
12 | 0 | ||||||||||||||
|
IPSNR
WBS element - maintenance project
|
AM_IPSNR |
NUMC
|
8 | 0 | ||||||||||||||
|
INVNR
Inventory number
|
INVNR |
CHAR
|
25 | 0 | ||||||||||||||
|
SERNR
Serial number
|
AM_SERNR |
CHAR
|
18 | 0 | ||||||||||||||
|
HERST
Manufacturer of asset
|
HERST |
CHAR
|
30 | 0 | ||||||||||||||
|
MEINS
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
MENGE
Quantity
|
MENGE_D |
QUAN
|
13 | 3 | ||||||||||||||
|
MENGA
Quantity
|
MENGE_D |
QUAN
|
13 | 3 | ||||||||||||||
|
TXT50
Asset description
|
TXA50_ANLT |
CHAR
|
50 | 0 | ||||||||||||||
|
XMARK
Checkbox
|
XFELD |
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 | ||||||||||||||
|
GKONT
Offsetting Account Number
|
GKONT |
CHAR
|
10 | 0 | ||||||||||||||
|
HKONT
General Ledger Account
|
HKONT | SKA1 |
CHAR
|
10 | 0 | |||||||||||||
|
XAABG
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VBUND
Company ID of trading partner
|
RASSC |
CHAR
|
6 | 0 | ||||||||||||||
|
PBUKR
Partner Company Code
|
PBUKR |
CHAR
|
4 | 0 | ||||||||||||||
|
AIBN1
Original asset that was transferred
|
AIBN1 |
CHAR
|
12 | 0 | ||||||||||||||
|
AIBN2
Original asset that was transferred
|
AIBN2 |
CHAR
|
4 | 0 | ||||||||||||||
|
XOPVW
Indicator: Open item management?
|
XOPVW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OBJNR
Object number
|
J_OBJNR |
CHAR
|
22 | 0 | ||||||||||||||
|
LEANZ
Number of lease payments
|
LEANZ |
DEC
|
5 | 0 | ||||||||||||||
|
LVORS
Advance payments
|
LVORS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LZINS
Leasing interest rate (capital lease)
|
LZINS |
DEC
|
7 | 4 | ||||||||||||||
|
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 | ||||||||||||||
|
LEJAR
Length of lease in years
|
LEJAR |
NUMC
|
3 | 0 | ||||||||||||||
|
LEPER
Length of lease in periods
|
LEPER |
NUMC
|
3 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||
|
AIMMO
Indicator: real estate
|
AIMMO |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XFWBE
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR |
CHAR
|
10 | 0 | ||||||||||||||
|
XERWRT
Indicator: Ignore memo value
|
XERWRT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XANLGR
Indicator: asset class managed as group asset
|
XANLGR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ANLN1_ABG
Asset number for gain/loss account assgmt. for retirement
|
ANLN1_ABG |
CHAR
|
12 | 0 | ||||||||||||||
|
ANLN2_ABG
Asset subnumber for gain/loss account assignment retirement
|
ANLN2_ABG |
CHAR
|
4 | 0 | ||||||||||||||
|
XAKZU
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XINVM
Asset under Construction for Investment Measures
|
IM_XINVM |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
CAUFN
Internal order
|
CAUFN |
CHAR
|
12 | 0 | ||||||||||||||
|
LRVDAT
Date of last revaluation
|
AM_LRVDAT |
DATS
|
8 | 0 | ||||||||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||||||||
|
GEBER
Fund
|
BP_GEBER |
CHAR
|
10 | 0 | ||||||||||||||
|
FIPOS
Commitment Item
|
FIPOS |
CHAR
|
14 | 0 | ||||||||||||||
|
ORD41
Evaluation group 1
|
ORD41 |
CHAR
|
4 | 0 | ||||||||||||||
|
ORD42
Evaluation group 2
|
ORD42 |
CHAR
|
4 | 0 | ||||||||||||||
|
ORD43
Evaluation group 3
|
ORD43 |
CHAR
|
4 | 0 | ||||||||||||||
|
ORD44
Evaluation group 4
|
ORD44 |
CHAR
|
4 | 0 | ||||||||||||||
|
ANLUE
Asset super number
|
ANLUE |
CHAR
|
12 | 0 | ||||||||||||||
|
GDLGRP
Evaluation group 5
|
GDLGRP |
CHAR
|
8 | 0 | ||||||||||||||
|
ABGSL
Results Analysis Key
|
ABGR_SCHL |
CHAR
|
6 | 0 | ||||||||||||||
|
ABART
Indicator: Line item settlement of inv. measure
|
IM_ABART |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||||||||
|
GEBER2
Fund for APC Account Assignments
|
BP_GEBER2 |
CHAR
|
10 | 0 | ||||||||||||||
|
FKBER2
Functional Area for APC Account Assignments
|
FKBER2 |
CHAR
|
16 | 0 | ||||||||||||||
|
GRANT_NBR2
Grant for APC Account Assignments
|
GM_GRANT_NBR2 |
CHAR
|
20 | 0 | ||||||||||||||
|
FISTL2
Funds Center for APC Account Assignments
|
FISTL2 |
CHAR
|
16 | 0 | ||||||||||||||
|
IMKEY
Internal Key for Real Estate Object
|
IMKEY |
CHAR
|
8 | 0 | ||||||||||||||
|
PS_PSP_PNR2
WBS Element (Costs)
|
PS_PSP_PNR2 |
NUMC
|
8 | 0 | ||||||||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||||||||
|
BUDGET_PD2
Budget Period for APC Account Assignments
|
FM_BUDGET_PERIOD2 |
CHAR
|
10 | 0 | ||||||||||||||
|
SEGMENT
Segment for Segmental Reporting
|
FB_SEGMENT | FAGL_SEGM |
CHAR
|
10 | 0 | |||||||||||||
|
PRCTR
Profit Center
|
PRCTR |
CHAR
|
10 | 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 | ||||||||||||||
ANTS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ANTS | ANLKL | ANTS | MANDT |
ANKA
Asset classes: general data
|
MANDT |
| ANTS | ANLKL | ANTS | ANLKL |
ANKA
Asset classes: general data
|
ANLKL |
| ANTS | ANLN1 | ANTS | MANDT |
ANLH
Main asset number
|
MANDT |
| ANTS | ANLN1 | ANTS | BUKRS |
ANLH
Main asset number
|
BUKRS |
| ANTS | ANLN1 | ANTS | ANLN1 |
ANLH
Main asset number
|
ANLN1 |
| ANTS | ANLN2 | ANTS | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| ANTS | ANLN2 | ANTS | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| ANTS | ANLN2 | ANTS | ANLN1 |
ANLA
Asset Master Record Segment
|
ANLN1 |
| ANTS | ANLN2 | ANTS | ANLN2 |
ANLA
Asset Master Record Segment
|
ANLN2 |
| ANTS | BUKRS | ANTS | MANDT |
T001
Company Codes
|
MANDT |
| ANTS | BUKRS | ANTS | BUKRS |
T001
Company Codes
|
BUKRS |
| ANTS | EAUFN | ANTS | MANDT |
AUFK
Order master data
|
MANDT |
| ANTS | EAUFN | ANTS | EAUFN |
AUFK
Order master data
|
AUFNR |
| ANTS | GSBER | ANTS | GSBER |
TGSB
Business Areas
|
GSBER |
| ANTS | GSBER | ANTS | MANDT |
TGSB
Business Areas
|
MANDT |
| ANTS | HKONT | ANTS | MANDT |
SKA1
G/L Account Master (Chart of Accounts)
|
MANDT |
| ANTS | HKONT | T001 | KTOPL |
SKA1
G/L Account Master (Chart of Accounts)
|
KTOPL |
| ANTS | HKONT | ANTS | HKONT |
SKA1
G/L Account Master (Chart of Accounts)
|
SAKNR |
| ANTS | KOSTL | ANTS | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| ANTS | KOSTL | T001 | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| ANTS | KOSTL | ANTS | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| ANTS | KOSTL | ANTS | AIBDT |
CSKS
Cost Center Master Data
|
DATBI |
| ANTS | KTOGR | ANTS | MANDT |
T095A
Account allocation
|
MANDT |
| ANTS | KTOGR | ANTS | KTOGR |
T095A
Account allocation
|
KTOGR |
| ANTS | MEINS | ANTS | MANDT |
T006
Units of Measurement
|
MANDT |
| ANTS | MEINS | ANTS | MEINS |
T006
Units of Measurement
|
MSEHI |
| ANTS | SEGMENT | ANTS | SEGMENT |
FAGL_SEGM
Master Data for Segments
|
SEGMENT |
| ANTS | SEGMENT | SYST | MANDT |
FAGL_SEGM
Master Data for Segments
|
MANDT |
| ANTS | TXJCD | ANTS | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| ANTS | TXJCD | RA02S | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| ANTS | TXJCD | ANTS | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |