1. Home
  2. Resources
  3. SAP Tables
  4. ANTS - Substructure of Asset Master Record (ANLA)

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
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
0 Asset is complete
1 Asset is incomplete, but can be posted
2 Asset is incomplete and cannot be posted (dep., retmt)
3 Asset is incomplete (cst ctr, int.order, activ.type missing)
4 Asset is incomplete (investment account assignment missing)
XLOEV Indicator: Account marked for deletion? XLOEV CHAR 1 0
X Yes
NULL No
XSPEB Indicator: Is Account Blocked for Posting? XSPEB CHAR 1 0
X Yes
NULL No
BEGRU Authorization Group BRGRU CHAR 4 0
ANLTP Asset Category ANLTP NUMC 1 0
0 Capitalized asset
1 Leased asset
2 Financial asset
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
X Yes
NULL No
ANUPD Indicator: Type of change to table ANUPD CHAR 1 0
D Delete
I Insert
U Update
NULL No changes
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
X Yes
NULL No
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
X Yes
NULL No
OBJNR Object number J_OBJNR CHAR 22 0
LEANZ Number of lease payments LEANZ DEC 5 0
LVORS Advance payments LVORS CHAR 1 0
X Yes
NULL No
LZINS Leasing interest rate (capital lease) LZINS DEC 7 4
LRYTH Lease payment cycle LRYTH NUMC 3 0
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
0
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
AIMMO Indicator: real estate AIMMO NUMC 1 0
0 Other asset without real estate management
1 Real estate - property or buildings
XFWBE Checkbox XFELD CHAR 1 0
X Yes
NULL No
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
XERWRT Indicator: Ignore memo value XERWRT CHAR 1 0
X Yes
NULL No
XANLGR Indicator: asset class managed as group asset XANLGR CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
XINVM Asset under Construction for Investment Measures IM_XINVM CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X TRUE
NULL FALSE
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 ANLN1 ANLH Main asset number ANLN1
ANTS ANLN1 ANTS MANDT ANLH Main asset number MANDT
ANTS ANLN1 ANTS BUKRS ANLH Main asset number BUKRS
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 ANLN2 ANTS MANDT ANLA Asset Master Record Segment MANDT
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 MANDT TGSB Business Areas MANDT
ANTS GSBER ANTS GSBER TGSB Business Areas GSBER
ANTS HKONT ANTS HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
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 KOSTL ANTS AIBDT CSKS Cost Center Master Data DATBI
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 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 SYST MANDT FAGL_SEGM Master Data for Segments MANDT
ANTS SEGMENT ANTS SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
ANTS TXJCD ANTS TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
ANTS TXJCD ANTS MANDT TTXJ Check Table for Tax Jurisdiction MANDT
ANTS TXJCD RA02S KALSM TTXJ Check Table for Tax Jurisdiction KALSM