1. Home
  2. Resources
  3. SAP Tables
  4. FAA_S_BASIC - Basic Data of Asset

SAP Table FAA_S_BASIC

Basic Data of Asset

FAA_S_BASIC (Basic Data of Asset) 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_BASIC to other SAP tables.

FAA_S_BASIC table fields

Field Data element Checktable Datatype Length Decimals
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
BUS_AREA Business Area GSBER CHAR 4 0
COSTCENTER Cost Center KOSTL CHAR 10 0
ACTTYPE Activity Type LSTAR CHAR 6 0
INTERN_ORD Order Number AUFNR CHAR 12 0
MAINT_ORD Maintenance order IAUFN CHAR 12 0
FUND Fund BP_GEBER CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
FUNC_AREA_LONG Functional Area FKBER CHAR 16 0
FUNDS_CTR Funds Center FISTL CHAR 16 0
FUND_APC Fund for APC Account Assignments BP_GEBER2 CHAR 10 0
FUNC_AREA_APC Functional Area for APC Account Assignments FKBER2 CHAR 16 0
GRANT_NBR_APC Grant for APC Account Assignments GM_GRANT_NBR2 CHAR 20 0
FUNDS_CTR_APC Funds Center for APC Account Assignments FISTL2 CHAR 16 0
WBS_ELEMENT_COST WBS Element (Costs) PS_PSP_PNR2 NUMC 8 0
TAXJURCODE Tax Jurisdiction TXJCD CHAR 15 0
RL_EST_KEY Internal Key for Real Estate Object IMKEY CHAR 8 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
INVEST_ORD Investment Order BF_AM_AUFNR AUFK CHAR 12 0
WBS_ELEM WBS Element PS_POSNR PRPS NUMC 8 0
RESP_CCTR Cost center responsible for asset BF_KOSTLV CHAR 10 0
PLANT Plant WERKS_D CHAR 4 0
LOCATION Asset location STORT CHAR 10 0
ROOM Room BF_RAUMNR CHAR 8 0
PLATE_NO License plate no. of vehichle BF_AM_KFZKZ CHAR 15 0
PERSON_NO Personnel Number PERNR_D NUMC 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
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
MAIN_DESCRIPT Asset main number text ANLHTXT CHAR 50 0
SUBNO_OF_MAIN First subnumber assigned FUNTN CHAR 4 0
LAST_SUBNO Last subnumber assigned to this main number LUNTN CHAR 4 0
TO_DATE Date validity ends BF_BDATU DATS 8 0
FROM_DATE Date for beginning of validity BF_ADATU DATS 8 0

FAA_S_BASIC foreign key relationships

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