1. Home
  2. Resources
  3. SAP Tables
  4. FAA_S_DB_ASSET_DATA - Time-Independent Asset Master Data (ANLA)

SAP Table FAA_S_DB_ASSET_DATA

Time-Independent Asset Master Data (ANLA)

FAA_S_DB_ASSET_DATA (Time-Independent Asset Master Data (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 FAA_S_DB_ASSET_DATA to other SAP tables.

FAA_S_DB_ASSET_DATA table fields

Field Data element Checktable Datatype Length Decimals
ASSET_ID GUID That Uniquely Identifies an Asset FAA_ASSET_ID CHAR 32 0
ORGUNIT Leading Organizational Unit for Asset Accounting FAA_ORG_CA CHAR 4 0
ASSET Main Asset Number ANLN1 CHAR 12 0
SUBNUMBER Asset Subnumber ANLN2 CHAR 4 0
ASSETCLASS Asset class BF_ANLKL CHAR 8 0
DESCRIPT Asset Description BF_TXA50 CHAR 50 0
DESCRIPT2 Additional asset description TXA50_MORE CHAR 50 0
SERIAL_NO Serial number BF_AM_SERNR CHAR 18 0
INVENT_NO Inventory number BF_INVNR_ANLA CHAR 25 0
ACCT_DETRM Account determination BF_KTOGR CHAR 8 0
QUANTITY Quantity MENGE_D QUAN 13 3
BASE_UOM Base Unit of Measure MEINS UNIT 3 0
CAP_DATE Asset capitalization date BF_AKTIVD DATS 8 0
DEACT_DATE Deactivation date BF_DEAKT DATS 8 0
INITIAL_ACQ Asset value date of the first posting BF_ZUGDAT DATS 8 0
INITIAL_ACQ_YR Fiscal year in which first acquisition was posted BF_ZUJAHR NUMC 4 0
INITIAL_ACQ_PRD Period in which first acquisition was posted BF_ZUPER NUMC 3 0
PLRET_DATE Planned retirement date BF_GPLAB DATS 8 0
LAST_RET_DATE Asset value date for the last retirement ABGDAT DATS 8 0
PO_DATE Asset purchase order date BF_BSTDT DATS 8 0
CAP_KEY Results Analysis Key ABGR_SCHL CHAR 6 0
LAST_REV_DATE Date of last revaluation AM_LRVDAT DATS 8 0
EVALGROUP1 Evaluation Group 1 BF_ORD41 CHAR 4 0
EVALGROUP2 Evaluation Group 2 BF_ORD42 CHAR 4 0
EVALGROUP3 Evaluation Group 3 BF_ORD43 CHAR 4 0
EVALGROUP4 Evaluation Group 4 BF_ORD44 CHAR 4 0
EVALGROUP5 Sort Key 5 BF_GDLGRP CHAR 8 0
INV_REASON Reason for investment BF_IZWEK CHAR 2 0
ENVIR_INVEST Reason for environmental investment BF_AM_UMWKZ CHAR 5 0
ASSETSUPNO Asset super number BF_ANLUE CHAR 12 0
VENDOR_NO Account number of vendor (other key word) BF_AM_LIFNR LFA1 CHAR 10 0
VENDOR Name of asset supplier BF_LIEFE CHAR 30 0
MANUFACTURER Manufacturer of asset BF_HERST CHAR 30 0
PURCH_NEW Indicator: Asset purchased new XNEU_AM CHAR 1 0
X Yes
NULL No
TRADE_ID Company ID of trading partner BF_RASSC T880 CHAR 6 0
COUNTRY Asset's country of origin BF_AM_LAND1 T005 CHAR 3 0
TYPE_NAME Asset type name BF_TYPBZ_ANLA CHAR 15 0
ORIG_ASSET Original asset that was transferred BF_AIBN1 CHAR 12 0
ORIG_ASSET_SUBNO Original asset that was transferred BF_AIBN2 CHAR 4 0
ORIG_ACQ_DATE Original acquisition date of AuC/ transferred asset BF_AIBDT DATS 8 0
ORIG_ACQ_YR Fiscal year of original acquisition BF_URJHR NUMC 4 0
ORIG_VALUE Original acquisition value BF_URWRT DEC 23 4
CURRENCY Currency Key WAERS TCURC CUKY 5 0
INHOUSE_PROD_PRC In-house production percentage BF_ANTEI DEC 5 2
INVEST_ORD Investment Order BF_AM_AUFNR AUFK CHAR 12 0
WBS_ELEM WBS Element PS_POSNR PRPS NUMC 8 0
INVNTRY_DATE Last inventory date BF_IVDAT_ANLA DATS 8 0
INVNTRY_NOTE Supplementary inventory specifications BF_INVZU_ANLA CHAR 15 0
COMPANY_LS Leasing company BF_LEAFI CHAR 10 0
AGRMNT_NO_LS Leasing agreement number BF_LVTNR CHAR 15 0
AGRMNTDATE_LS Leasing agreement date BF_LVDAT DATS 8 0
NOTICEDATE_LS Leasing agreement notice date BF_LKDAT DATS 8 0
START_DATE_LS Lease start date BF_LEABG DATS 8 0
LNGTH_YRS_LS Length of lease in years BF_LEJAR NUMC 3 0
LNGTH_PRDS_LS Length of lease in periods BF_LEPER NUMC 3 0
TYPE_LS Leasing type BF_LEART CHAR 2 0
BASE_VALUE_LS Leasing base value as new LBASW CURR 13 2
PURCHPRICE_LS Leased asset purchase price LKAUF CURR 13 2
TEXT_LS Leasing data text BF_LETXT CHAR 50 0
NO_PAYMNTS_LS Number of lease payments BF_LEANZ DEC 5 0
CYCLE_LS Lease payment cycle BF_LRYTH NUMC 3 0
IN_ADVANCE_LS Advance payments BF_LVORS CHAR 1 0
X Yes
NULL No
PAYMENT_LS Periodic lease payment paid to leasing company/lessor LEGEB CURR 13 2
INTEREST_LS Leasing interest rate (capital lease) BF_LZINS DEC 7 4
VALUE_LS Present value of lease LBARW CURR 13 2
CURRENCY_LS Currency Key WAERS CUKY 5 0
CLASS_KEY_NW Property classification key BF_VMGLI CHAR 4 0
PROP_IND_NW Property indicator BF_EIGKZ CHAR 1 0
MAN_PV_REASON_NW Reason for manual valuation of net assets BF_GRUND CHAR 3 0
MAN_PROP_VAL_NW Manual net worth tax value WRTMA CURR 13 2
CURRENCY_NW Currency Key WAERS TCURC CUKY 5 0
HAS_MAN_PV_NW Manual net worth tax value BF_XVRMW CHAR 1 0
X Yes
NULL No
TAX_OFFICE_RE Local tax office BF_FIAMT CHAR 25 0
TAX_NO_RE Tax number of the notice of assessment BF_EHWNR_ANLA CHAR 16 0
ASSMNT_NTCDT_RE Date of last notice of assessment BF_EHWZU_ANLA DATS 8 0
MUNICIPALITY_RE Municipality BF_ORT01_ANLA CHAR 25 0
LNDREG_DT_RE Land Register of BF_GRUVO_ANLA DATS 8 0
LNDREG_ENTRDT_RE Land register entry on BF_GREIN_ANLA DATS 8 0
LNDREG_VOL_RE Land register volume BF_GRBND_ANLA CHAR 5 0
LNDREG_PG_RE Land register page BF_GRBLT_ANLA CHAR 5 0
LNDREG_NO_RE Land register entry: Sequence number BF_GRLFD_ANLA CHAR 4 0
LNDREG_MAPNO_RE Land register map number BF_FLURK_ANLA CHAR 4 0
LNDREG_PLOTNO_RE Plot number BF_FLURN_ANLA CHAR 10 0
CONVEYANCE_DT_RE Date of conveyance BF_AUFLA_ANLA DATS 8 0
AREA_RE Surface area BF_GRUFL QUAN 13 3
AREA_UOM_RE Area unit BF_FEINS UNIT 3 0
COMPLETENESS 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)
HISTORY Asset is managed historically XHIST_AM CHAR 1 0
X Yes
NULL No
IS_GROUP_ASSET Indicator: Asset is a group asset XANLGR_1 CHAR 1 0
X Yes
NULL No
IS_INVSTMNT_MSR Asset under Construction for Investment Measures IM_XINVM CHAR 1 0
X Yes
NULL No
LINE_ITEM_SETTL Asset under construct. with line item settlement OPVWA CHAR 1 0
X Yes
NULL No
IGNORE_MEMVAL Indicator: Ignore memo value XERWRT CHAR 1 0
X Yes
NULL No
PLND_FOR_DELETN Indicator: Account marked for deletion? XLOEV CHAR 1 0
X Yes
NULL No
LOCKED_FOR_PSTNG Indicator: Asset Locked to Acquisition Postings XSPEB_ANLA CHAR 1 0
X Yes
NULL No
IS_REAL_ESTATE Indicator: real estate AIMMO NUMC 1 0
0 Other asset without real estate management
1 Real estate - property or buildings
INCL_IN_INV_LIST Inventory indicator BF_INKEN CHAR 1 0
X Yes
NULL No
HAS_TDDP Asset Has Time-Dependent Valuation Parameters in ANLBZA HAS_TDDP CHAR 1 0
X TRUE
NULL FALSE
CREATION_DATE Date on Which Record Was Created ERDAT DATS 8 0
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
CHANGE_DATE Changed on AEDAT_ANLA DATS 8 0
CHANGED_BY Name of Person Who Changed Object AENAM CHAR 12 0
SCR_LAYOUT_CRTN Screen layout for Asset Accounting FELEI CHAR 4 0
CHANGE_VIEW0 Change date: View 0 XV0DT DATS 8 0
VIEW_USED_BY0 Name of person in charge, who changed View0 XV0NM CHAR 12 0
CHANGE_VIEW1 Change date: View 0 XV0DT DATS 8 0
VIEW_USED_BY1 Name of person in charge, who changed View0 XV0NM CHAR 12 0
CHANGE_VIEW2 Change date: View 0 XV0DT DATS 8 0
VIEW_USED_BY2 Name of person in charge, who changed View0 XV0NM CHAR 12 0
CHANGE_VIEW3 Change date: View 0 XV0DT DATS 8 0
VIEW_USED_BY3 Name of person in charge, who changed View0 XV0NM CHAR 12 0
CHANGE_VIEW4 Change date: View 0 XV0DT DATS 8 0
VIEW_USED_BY4 Name of person in charge, who changed View0 XV0NM CHAR 12 0
CHANGE_VIEW5 Change date: View 0 XV0DT DATS 8 0
VIEW_USED_BY5 Name of person in charge, who changed View0 XV0NM CHAR 12 0
CHANGE_VIEW6 Change date: View 0 XV0DT DATS 8 0
VIEW_USED_BY6 Name of person in charge, who changed View0 XV0NM CHAR 12 0

FAA_S_DB_ASSET_DATA foreign key relationships

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