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.
Source: TXW_ANLA (Asset master data)
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 |
Possible values
|
||||||
XANLGR | Indicator: Asset is a group asset | XANLGR_1 | CHAR | 1 | 0 |
Possible values
|
||||||
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 |