SAP Table TXW_ANLA

Asset master data

TXW_ANLA (Asset master data) 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 TXW_ANLA to other SAP tables.

TXW_ANLA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
AIBDT Original acquisition date of AuC/ transferred asset AIBDT DATS 8 0
AIBN1 Original asset that was transferred AIBN1 CHAR 12 0
AIBN2 Original asset that was transferred AIBN2 CHAR 4 0
AKTIV Asset capitalization date AKTIVD DATS 8 0
ANLKL Asset Class ANLKL CHAR 8 0
EIGKZ Property indicator EIGKZ CHAR 1 0
GDLGRP Evaluation group 5 GDLGRP CHAR 8 0
KTOGR Account determination KTOGR CHAR 8 0
MEINS Base Unit of Measure MEINS UNIT 3 0
MENGE Total quantity TXW_QUANT CHAR 16 0
OBJNR Object number (forecast) OBJNR CHAR 18 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
POSNR WBS element investment project AM_POSNR NUMC 8 0
POSID WBS element investment project (external representation) TXW_AMPSID CHAR 24 0
TXA50 Asset description TXA50_ANLT CHAR 50 0
TXT50 Asset description TXA50_ANLT CHAR 50 0
TYPBZ Manufacturer model number TYPBZ CHAR 20 0
URJHR Fiscal year of original acquisition URJHR NUMC 4 0
URWRT Original Acquisition Value TXW_URWRT CHAR 16 0
VBUND Company ID of trading partner RASSC CHAR 6 0
XAFABCH Asset acquired used XAFABCH CHAR 1 0
X Yes
NULL No
XANLGR Indicator: Asset is a group asset XANLGR_1 CHAR 1 0
X Yes
NULL No
ZUGDT Asset value date of the first posting DZUGDAT DATS 8 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
EAUFN Investment Order AM_AUFNR CHAR 12 0
DEAKT Deactivation date DEAKT DATS 8 0
VMGLI Property classification key VMGLI CHAR 4 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
INVNR Inventory number INVNR CHAR 25 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0