SAP table FAA_S_DB_ASSET_DATA (Time-Independent Asset Master Data (ANLA))

Field Description Data Type Length Decimals Checktable Data Element
ASSET_ID GUID That Uniquely Identifies an Asset CHAR 32 0 FAA_ASSET_ID
ORGUNIT Leading Organizational Unit for Asset Accounting CHAR 4 0 * FAA_ORG_CA
ASSET Main Asset Number CHAR 12 0 * ANLN1
SUBNUMBER Asset Subnumber CHAR 4 0 * ANLN2
ASSET_CLASS Asset class CHAR 8 0 * BF_ANLKL
DESCRIPT Asset Description CHAR 50 0 BF_TXA50
DESCRIPT2 Additional Asset Description CHAR 50 0 TXA50_MORE
SERIAL_NO Serial Number CHAR 18 0 BF_AM_SERNR
INVENT_NO Inventory number CHAR 25 0 BF_INVNR_ANLA
LANGUAGE Language Key LANG 1 0 SPRAS
ACCT_DETRM Account Determination CHAR 8 0 * BF_KTOGR
QUANTITY Quantity QUAN 13 3 MENGE_D
BASE_UOM Base Unit of Measure UNIT 3 0 * MEINS
CAP_DATE Asset capitalization date DATS 8 0 BF_AKTIVD
DEACT_DATE Deactivation Date DATS 8 0 BF_DEAKT
INITIAL_ACQ Asset Value Date of the First Posting DATS 8 0 BF_ZUGDAT
INITIAL_ACQ_YR Fiscal Year in Which First Acquisition Was Posted NUMC 4 0 BF_ZUJAHR
INITIAL_ACQ_PRD Period in Which First Acquisition Was Posted NUMC 3 0 BF_ZUPER
PLRET_DATE Planned Retirement Date DATS 8 0 BF_GPLAB
LAST_RET_DATE Asset Value Date for the Last Retirement DATS 8 0 ABGDAT
PO_DATE Asset Purchase Order Date DATS 8 0 BF_BSTDT
CAP_KEY Results Analysis Key CHAR 6 0 * ABGR_SCHL
LAST_REV_DATE Date of Last Revaluation DATS 8 0 AM_LRVDAT
EVALGROUP1 Evaluation Group 1 CHAR 4 0 BF_ORD41
EVALGROUP2 Evaluation Group 2 CHAR 4 0 BF_ORD42
EVALGROUP3 Evaluation Group 3 CHAR 4 0 BF_ORD43
EVALGROUP4 Evaluation Group 4 CHAR 4 0 BF_ORD44
EVALGROUP5 Sort Key 5 CHAR 8 0 BF_GDLGRP
INV_REASON Reason for Investment CHAR 2 0 BF_IZWEK
ENVIR_INVEST Reason for Environmental Investment CHAR 5 0 BF_AM_UMWKZ
ASSETSUPNO Asset super number CHAR 12 0 BF_ANLUE
VENDOR_NO Account Number of Supplier (Other Key Word) CHAR 10 0 LFA1 BF_AM_LIFNR
VENDOR Name of Asset Supplier CHAR 30 0 BF_LIEFE
MANUFACTURER Manufacturer of Asset CHAR 30 0 BF_HERST
PURCH_NEW Indicator: Asset purchased new CHAR 1 0 XNEU_AM
TRADE_ID Company ID of trading partner CHAR 6 0 T880 BF_RASSC
COUNTRY Asset's Country/Region of Origin CHAR 3 0 T005 BF_AM_LAND1
TYPE_NAME Asset Type Name CHAR 15 0 BF_TYPBZ_ANLA
ORIG_ASSET Original Asset That Was Transferred CHAR 12 0 BF_AIBN1
ORIG_ASSET_SUBNO Original Asset That Was Transferred CHAR 4 0 BF_AIBN2
ORIG_ACQ_DATE Original Acquisition Date of AuC/ Transferred Asset DATS 8 0 BF_AIBDT
ORIG_ACQ_YR Fiscal Year of Original Acquisition NUMC 4 0 BF_URJHR
ORIG_VALUE Original Acquisition Value (31 digits) DEC 31 8 BF_URWRT_31
CURRENCY Currency Key CUKY 5 0 TCURC WAERS
INHOUSE_PROD_PRC In-House Production Percentage DEC 5 2 BF_ANTEI
INVEST_ORD Investment Order CHAR 12 0 AUFK BF_AM_AUFNR
WBS_ELEM WBS Element NUMC 8 0 PRPS PS_POSNR
INVNTRY_DATE Last Inventory Date DATS 8 0 BF_IVDAT_ANLA
INVNTRY_NOTE Supplementary Inventory Specifications CHAR 15 0 BF_INVZU_ANLA
COMPANY_LS Leasing Company CHAR 10 0 * BF_LEAFI
AGRMNT_NO_LS Leasing Agreement Number CHAR 15 0 BF_LVTNR
AGRMNTDATE_LS Leasing Agreement Date DATS 8 0 BF_LVDAT
NOTICEDATE_LS Leasing Agreement Notice Date DATS 8 0 BF_LKDAT
START_DATE_LS Lease Start Date DATS 8 0 BF_LEABG
LNGTH_YRS_LS Length of Lease in Years NUMC 3 0 BF_LEJAR
LNGTH_PRDS_LS Length of Lease in Periods NUMC 3 0 BF_LEPER
TYPE_LS Leasing Type CHAR 2 0 BF_LEART
BASE_VALUE_LS Leasing base value as new CURR 23 2 LBASW
PURCHPRICE_LS Leased asset purchase price CURR 23 2 LKAUF
TEXT_LS Leasing Data Text CHAR 50 0 BF_LETXT
NO_PAYMNTS_LS Number of Lease Payments DEC 5 0 BF_LEANZ
CYCLE_LS Lease Payment Cycle NUMC 3 0 BF_LRYTH
IN_ADVANCE_LS Advance Payments CHAR 1 0 BF_LVORS
PAYMENT_LS Periodic lease payment paid to leasing company/lessor CURR 23 2 LEGEB
INTEREST_LS Leasing Interest Rate (Capital Lease) DEC 7 4 BF_LZINS
VALUE_LS Present value of lease CURR 23 2 LBARW
CURRENCY_LS Currency Key CUKY 5 0 * WAERS
CLASS_KEY_NW Property Classification Key CHAR 4 0 BF_VMGLI
PROP_IND_NW Property Indicator CHAR 1 0 BF_EIGKZ
MAN_PV_REASON_NW Reason for Manual Valuation of Net Assets CHAR 3 0 BF_GRUND
MAN_PROP_VAL_NW Manual net worth tax value CURR 23 2 WRTMA
CURRENCY_NW Currency Key CUKY 5 0 TCURC WAERS
HAS_MAN_PV_NW Manual Net Worth Tax Value CHAR 1 0 BF_XVRMW
TAX_OFFICE_RE Local Tax Office CHAR 25 0 BF_FIAMT
TAX_NO_RE Tax Number of the Notice of Assessment CHAR 16 0 BF_EHWNR_ANLA
ASSMNT_NTCDT_RE Date of Last Notice of Assessment DATS 8 0 BF_EHWZU_ANLA
MUNICIPALITY_RE Municipality CHAR 25 0 BF_ORT01_ANLA
LNDREG_DT_RE Land Register Of DATS 8 0 BF_GRUVO_ANLA
LNDREG_ENTRDT_RE Land Register Entry On DATS 8 0 BF_GREIN_ANLA
LNDREG_VOL_RE Land Register Volume CHAR 5 0 BF_GRBND_ANLA
LNDREG_PG_RE Land Register Page CHAR 5 0 BF_GRBLT_ANLA
LNDREG_NO_RE Land Register Entry: Sequence Number CHAR 4 0 BF_GRLFD_ANLA
LNDREG_MAPNO_RE Land Register Map Number CHAR 4 0 BF_FLURK_ANLA
LNDREG_PLOTNO_RE Plot Number CHAR 10 0 BF_FLURN_ANLA
CONVEYANCE_DT_RE Date of Conveyance DATS 8 0 BF_AUFLA_ANLA
AREA_RE Surface Area QUAN 13 3 BF_GRUFL
AREA_UOM_RE Area Unit UNIT 3 0 * BF_FEINS
COMPLETENESS 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)
HISTORY Asset is managed historically CHAR 1 0 XHIST_AM
IS_GROUP_ASSET Indicator: Asset is a group asset CHAR 1 0 XANLGR_1
IS_INVSTMNT_MSR Asset under Construction for Investment Measures CHAR 1 0 IM_XINVM
LINE_ITEM_SETTL Asset under construct. with line item settlement CHAR 1 0 OPVWA
IGNORE_MEMVAL Indicator: Ignore memo value CHAR 1 0 XERWRT
PLND_FOR_DELETN Indicator: Account Marked for Deletion? CHAR 1 0 XLOEV
LOCKED_FOR_PSTNG Indicator: Asset Locked to Acquisition Postings CHAR 1 0 XSPEB_ANLA
IS_REAL_ESTATE Indicator: Real Estate NUMC 1 0 AIMMO
0 Other asset without real estate management
1 Real estate - property or buildings
INCL_IN_INV_LIST Inventory Indicator CHAR 1 0 BF_INKEN
HAS_TDDP Asset Has Time-Dependent Valuation Parameters in ANLBZA CHAR 1 0 HAS_TDDP
CREATION_DATE Date on which the record was created DATS 8 0 ERDAT
CREATED_BY Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CHANGE_DATE Changed On DATS 8 0 AEDAT_ANLA
CHANGED_BY Name of Person Who Changed Object CHAR 12 0 AENAM
SCR_LAYOUT_CRTN Screen Layout for Asset Accounting CHAR 4 0 * FELEI
CHANGE_VIEW0 Change date: View 0 DATS 8 0 XV0DT
VIEW_USED_BY0 Name of person in charge, who changed View0 CHAR 12 0 XV0NM
CHANGE_VIEW1 Change date: View 0 DATS 8 0 XV0DT
VIEW_USED_BY1 Name of person in charge, who changed View0 CHAR 12 0 XV0NM
CHANGE_VIEW2 Change date: View 0 DATS 8 0 XV0DT
VIEW_USED_BY2 Name of person in charge, who changed View0 CHAR 12 0 XV0NM
CHANGE_VIEW3 Change date: View 0 DATS 8 0 XV0DT
VIEW_USED_BY3 Name of person in charge, who changed View0 CHAR 12 0 XV0NM
CHANGE_VIEW4 Change date: View 0 DATS 8 0 XV0DT
VIEW_USED_BY4 Name of person in charge, who changed View0 CHAR 12 0 XV0NM
CHANGE_VIEW5 Change date: View 0 DATS 8 0 XV0DT
VIEW_USED_BY5 Name of person in charge, who changed View0 CHAR 12 0 XV0NM
CHANGE_VIEW6 Change date: View 0 DATS 8 0 XV0DT
VIEW_USED_BY6 Name of person in charge, who changed View0 CHAR 12 0 XV0NM

FAA_S_DB_ASSET_DATA foreign key relationships

Table Field Check Table Check Field
0 FAA_S_DB_ASSET_DATA COUNTRY T005 Countries MANDT
0 FAA_S_DB_ASSET_DATA COUNTRY T005 Countries LAND1
1 FAA_S_DB_ASSET_DATA CURRENCY TCURC Currency Codes WAERS
0 FAA_S_DB_ASSET_DATA CURRENCY_NW TCURC Currency Codes MANDT
0 FAA_S_DB_ASSET_DATA CURRENCY_NW TCURC Currency Codes WAERS
1 FAA_S_DB_ASSET_DATA INVEST_ORD AUFK Order master data AUFNR
0 FAA_S_DB_ASSET_DATA TRADE_ID T880 Global Company Data (for KONS Ledger) MANDT
0 FAA_S_DB_ASSET_DATA TRADE_ID T880 Global Company Data (for KONS Ledger) RCOMP
1 FAA_S_DB_ASSET_DATA VENDOR_NO LFA1 Supplier Master (General Section) MANDT
1 FAA_S_DB_ASSET_DATA VENDOR_NO LFA1 Supplier Master (General Section) LIFNR
0 FAA_S_DB_ASSET_DATA WBS_ELEM PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 FAA_S_DB_ASSET_DATA WBS_ELEM PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR