SAP table ANTS (Substructure of Asset Master Record (ANLA))

SAP table ANTS has 4 primary key fields being MANDT,BUKRS,ANLN1,ANLN2.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
ANLKL Asset Class CHAR 8 0 ANKA ANLKL
ANEQS Completeness indicator for the asset NUMC 1 0 ANEQS
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? CHAR 1 0 XLOEV
XSPEB Indicator: Is Account Blocked for Posting? CHAR 1 0 XSPEB
BEGRU Authorization Group CHAR 4 0 BRGRU
ANLTP Asset Category NUMC 1 0 ANLTP
0 Capitalized asset
1 Leased asset
2 Financial asset
GSBER Business Area CHAR 4 0 TGSB GSBER
KTOGR Account Determination CHAR 8 0 T095A KTOGR
ZUGDT Asset Value Date of the First Posting DATS 8 0 DZUGDAT
ZUPER Period in Which First Acquisition Was Posted NUMC 3 0 DZUPER
ZUJHR Asset Acquisition Year (Currently Not Used) NUMC 4 0 DZUJHR
AKTIV Asset Capitalization Date DATS 8 0 AKTIVD
DEAKT Deactivation Date DATS 8 0 DEAKT
ABGDT Asset Value Date for the Last Retirement DATS 8 0 ABGDAT
AIBDT Original Acquisition Date of AuC/ Transferred Asset DATS 8 0 AIBDT
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
LSTAR Activity Type CHAR 6 0 LSTAR
EAUFN Investment Order CHAR 12 0 AUFK EAUFN
POSNR WBS element investment project NUMC 8 0 AM_POSNR
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
KOSTLV Cost Center Responsible for Asset CHAR 10 0 KOSTLV
STORT Asset location CHAR 10 0 STORT
RAUMN Room CHAR 8 0 RAUMNR
IAUFN Maintenance Order CHAR 12 0 IAUFN
IPSNR WBS Element - Maintenance Project NUMC 8 0 AM_IPSNR
INVNR Inventory number CHAR 25 0 INVNR
SERNR Serial number CHAR 18 0 AM_SERNR
HERST Manufacturer of Asset CHAR 30 0 HERST
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MENGE Quantity QUAN 13 3 MENGE_D
MENGA Quantity QUAN 13 3 MENGE_D
TXT50 Asset Description CHAR 50 0 TXA50_ANLT
XMARK Checkbox CHAR 1 0 XFELD
No
X Yes
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
LBLNR No. of Last Document with Which Posting to Asset Was Made CHAR 10 0 LBLNR
GKONT Offsetting Account Number CHAR 10 0 GKONT
HKONT General Ledger Account CHAR 10 0 SKA1 HKONT
XAABG Checkbox CHAR 1 0 XFELD
No
X Yes
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
PBUKR Partner Company Code CHAR 4 0 PBUKR
AIBN1 Original Asset That Was Transferred CHAR 12 0 AIBN1
AIBN2 Original Asset That Was Transferred CHAR 4 0 AIBN2
XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
OBJNR Object number CHAR 22 0 J_OBJNR
LEANZ Number of Lease Payments DEC 5 0 LEANZ
LVORS Advance payments CHAR 1 0 LVORS
LZINS Leasing Interest Rate (Capital Lease) DEC 7 4 LZINS
LRYTH Lease payment cycle NUMC 3 0 LRYTH
LEGEB Periodic lease payment paid to leasing company/lessor CURR 23 2 LEGEB
LBASW Leasing base value as new CURR 23 2 LBASW
LEJAR Length of Lease in Years NUMC 3 0 LEJAR
LEPER Length of lease in periods NUMC 3 0 LEPER
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
AIMMO Indicator: Real Estate NUMC 1 0 AIMMO
0 Other asset without real estate management
1 Real estate - property or buildings
XFWBE Checkbox CHAR 1 0 XFELD
No
X Yes
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
XERWRT Indicator: Ignore memo value CHAR 1 0 XERWRT
XANLGR Indicator: asset class managed as group asset CHAR 1 0 XANLGR
ANLN1_ABG Asset number for gain/loss account assgmt. for retirement CHAR 12 0 ANLN1_ABG
ANLN2_ABG Asset subnumber for gain/loss account assignment retirement CHAR 4 0 ANLN2_ABG
XAKZU Checkbox CHAR 1 0 XFELD
No
X Yes
XINVM Asset under Construction for Investment Measures CHAR 1 0 IM_XINVM
CAUFN Internal Order CHAR 12 0 CAUFN
LRVDAT Date of Last Revaluation DATS 8 0 AM_LRVDAT
FISTL Funds Center CHAR 16 0 FISTL
GEBER Fund CHAR 10 0 BP_GEBER
FIPOS Commitment Item CHAR 14 0 FIPOS
ORD41 Evaluation group 1 CHAR 4 0 ORD41
ORD42 Evaluation Group 2 CHAR 4 0 ORD42
ORD43 Evaluation Group 3 CHAR 4 0 ORD43
ORD44 Evaluation group 4 CHAR 4 0 ORD44
ANLUE Asset Super Number CHAR 12 0 ANLUE
GDLGRP Evaluation Group 5 CHAR 8 0 GDLGRP
ABGSL Results Analysis Key CHAR 6 0 ABGR_SCHL
ABART Indicator: Line item settlement of inv. measure CHAR 1 0 IM_ABART
FKBER Functional Area CHAR 16 0 * FKBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
GEBER2 Fund for APC Account Assignments CHAR 10 0 * BP_GEBER2
FKBER2 Functional Area for APC Account Assignments CHAR 16 0 * FKBER2
GRANT_NBR2 Grant for APC Account Assignments CHAR 20 0 * GM_GRANT_NBR2
FISTL2 Funds Center for APC Account Assignments CHAR 16 0 * FISTL2
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
PS_PSP_PNR2 WBS Element (Costs) NUMC 8 0 * PS_PSP_PNR2
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
BUDGET_PD2 Budget Period for APC Account Assignments CHAR 10 0 * FM_BUDGET_PERIOD2
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
PRCTR Profit Center CHAR 10 0 PRCTR
HAS_TDDP Asset Has Time-Dependent Valuation Parameters in ANLBZA CHAR 1 0 HAS_TDDP
LAST_REORG_DATE Date of Last Reorganization DATS 8 0 FAA_LAST_REORG
LDT_DATE Legacy Data Transfer Date DATS 8 0 FAA_LDT_DATE

ANTS foreign key relationships

Table Field Check Table Check Field
0 ANTS ANLKL ANKA Asset classes: general data ANLKL
1 ANTS ANLN1 ANLH Main asset number BUKRS
1 ANTS ANLN1 ANLH Main asset number ANLN1
0 ANTS ANLN2 ANLA Asset Master Record Segment BUKRS
0 ANTS ANLN2 ANLA Asset Master Record Segment ANLN1
0 ANTS ANLN2 ANLA Asset Master Record Segment ANLN2
1 ANTS BUKRS T001 Company Codes BUKRS
0 ANTS EAUFN AUFK Order master data AUFNR
1 ANTS GSBER TGSB Business Areas MANDT
1 ANTS GSBER TGSB Business Areas GSBER
0 ANTS HKONT SKA1 G/L Account Master (Chart of Accounts) MANDT
0 ANTS HKONT SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 ANTS HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 ANTS KOSTL CSKS Cost Center Master Record MANDT
1 ANTS KOSTL CSKS Cost Center Master Record KOKRS
1 ANTS KOSTL CSKS Cost Center Master Record KOSTL
1 ANTS KOSTL CSKS Cost Center Master Record DATBI
0 ANTS KTOGR T095A Account allocation MANDT
0 ANTS KTOGR T095A Account allocation KTOGR
1 ANTS MEINS T006 Units of Measurement MANDT
1 ANTS MEINS T006 Units of Measurement MSEHI
0 ANTS SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 ANTS TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 ANTS TXJCD TTXJ Check Table for Tax Jurisdiction KALSM