SAP table IFIXASSET (Generated Table for View)

SAP table IFIXASSET has 4 primary key fields being MANDT,COMPANYCODE,MASTERFIXEDASSET,FIXEDASSET.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
COMPANYCODE Company Code CHAR 4 0 FAAV_COMP_CODE BUKRS
MASTERFIXEDASSET Main Asset Number CHAR 12 0 ANLH ANLN1
FIXEDASSET Asset Subnumber CHAR 4 0 ANLN2
FIXEDASSETEXTERNALID Asset Number CHAR 17 0 FIS_FIXEDASSET_EXT_ID
ASSETCLASS Asset Class CHAR 8 0 FAAV_ASSET_CLASS ANLKL
ASSETSERIALNUMBER Serial number CHAR 18 0 AM_SERNR
QUANTITY Quantity QUAN 13 3 AM_MENGE
BASEUNIT Base Unit of Measure UNIT 3 0 T006 MEINS
INVENTORY Inventory Number CHAR 25 0 INVNR_ANLA
FIXEDASSETDESCRIPTION Asset Description CHAR 50 0 TXA50_ANLT
ASSETADDITIONALDESCRIPTION Additional Asset Description CHAR 50 0 TXA50_MORE
CURRENCY Currency Key CUKY 5 0 TCURC WAERS
ORIGLACQNAMTINCOCODECRCY Original Acquisition Value CURR 23 2 URWRT
PARTNERCOMPANY Company ID of Trading Partner CHAR 6 0 T880 RASSC
ASSETMANUFACTURERNAME Manufacturer of Asset CHAR 30 0 HERST
INHOUSEPRODNPERCENT In-house production percentage DEC 5 2 ANTEI
ASSETSUPPLIERNAME Name of asset supplier CHAR 30 0 LIEFE
INVENTORYNOTE Supplementary Inventory Specifications CHAR 15 0 INVZU_ANLA
GROUP1ASSETEVALUATIONKEY Evaluation group 1 CHAR 4 0 T087 ORD41
GROUP2ASSETEVALUATIONKEY Evaluation Group 2 CHAR 4 0 T087 ORD42
GROUP3ASSETEVALUATIONKEY Evaluation Group 3 CHAR 4 0 T087 ORD43
GROUP4ASSETEVALUATIONKEY Evaluation group 4 CHAR 4 0 T087 ORD44
GROUP5ASSETEVALUATIONKEY Evaluation Group 5 CHAR 8 0 T087G GDLGRP
ASSETACCOUNTDETERMINATION Account Determination CHAR 8 0 FAAV_ACCOUNT_DET KTOGR
HASHISTORY Indicator: Historical management NUMC 1 0 ANEQK
0 Asset managed without history
1 Asset managed with history
ASSETCAPITALIZATIONDATE Asset Capitalization Date DATS 8 0 AKTIVD
FIRSTACQUISITIONFISCALYEAR Fiscal Year in Which First Acquisition Was Posted NUMC 4 0 DZUJAHR
FIRSTACQUISITIONFISCALPERIOD Period in Which First Acquisition Was Posted NUMC 3 0 DZUPER
ASSETDEACTIVATIONDATE Deactivation Date DATS 8 0 DEAKT
PLANNEDRETIREMENTDATE Planned Retirement Date DATS 8 0 GPLAB
FIXEDASSETORDERDATE Asset Purchase Order Date DATS 8 0 BSTDT
ORIGINALMASTERFIXEDASSET Original Asset That Was Transferred CHAR 12 0 AIBN1
FIXEDASSETGROUP Asset Super Number CHAR 12 0 T087U ANLUE
INVESTMENTREASON Reason for Investment CHAR 2 0 T087I IZWEK
ASSETISREALESTATE Indicator: Real Estate NUMC 1 0 AIMMO
0 Other asset without real estate management
1 Real estate - property or buildings
AREASIZEUNIT Area Unit UNIT 3 0 T006 FEINS
INVESTMENTORDER Investment Order CHAR 12 0 AM_AUFNR
INVESTMENTPROJECTWBSELEMENT WBS element investment project NUMC 8 0 PRPS AM_POSNR
INVENTORYISCOUNTED Inventory Indicator CHAR 1 0 INKEN
LASTINVENTORYDATE Last Inventory Date DATS 8 0 IVDAT_ANLA
ASSETSYNCHRONIZATIONRULE Change Asset Master Record from Equipment Master CHAR 1 0 AAPM_ACT_CHANGE_PM
ORIGINALACQUISITIONFISCALYEAR Fiscal Year of Original Acquisition NUMC 4 0 URJHR
ASSETTYPENAME Asset Type Name CHAR 15 0 TYPBZ_ANLA
SUPPLIER Account number of vendor (other key word) CHAR 10 0 LFA1 AM_LIFNR
ASSETCOUNTRYOFORIGIN Asset's Country/Region of Origin CHAR 3 0 T005 AM_LAND1
NOTICEOFASSESSMENTTAXID Tax Number of the Notice of Assessment CHAR 16 0 EHWNR_ANLA
LASTASSESSMENTNOTICEDATE Date of last notice of assessment DATS 8 0 EHWZU_ANLA
ENVRNMTLINVESTMENTREASON Reason for Environmental Investment CHAR 5 0 T087K AM_UMWKZ
LASTCHANGEDATE Changed On DATS 8 0 FIS_AEDAT_ANLA
FIXEDASSETFINDATACMPLTNS 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)
ACCOUNTISMARKEDFORDELETION Indicator: Account Marked for Deletion? CHAR 1 0 XLOEV
ACCOUNTISBLOCKEDFORPOSTING Indicator: Asset Locked to Acquisition Postings CHAR 1 0 XSPEB_ANLA
ACQUISITIONVALUEDATE Asset Value Date of the First Posting DATS 8 0 DZUGDAT
ORIGINALFIXEDASSETVALUEDATE Original Acquisition Date of AuC/ Transferred Asset DATS 8 0 AIBDT
ASSETUNDERCONSTISINVMTMSR Asset under Construction for Investment Measures CHAR 1 0 IM_XINVM
LASTRETIREMENTVALUEDATE Asset Value Date for the Last Retirement DATS 8 0 ABGDAT
LASTCHANGEDBYUSER Name of Person Who Changed Object CHAR 12 0 AENAM
FIXEDASSETPROPERTYTYPE Property Indicator CHAR 1 0 T097 EIGKZ
CREATIONDATE Date on which the record was created DATS 8 0 ERDAT
CREATEDBYUSER Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
MANUALDEPRECIATIONREASON Reason for Manual Valuation of Net Assets CHAR 3 0 T098 GRUND
LASTREORGANIZATIONDATE Date of Last Reorganization DATS 8 0 FAA_LAST_REORG
LEGACYDATATRANSFERDATE Legacy Data Transfer Date DATS 8 0 FAA_LDT_DATE
ISGROUPASSET Indicator: Asset is a group asset CHAR 1 0 XANLGR_1
ISLINEITEMSETTLED Asset under construct. with line item settlement CHAR 1 0 OPVWA
ORIGINALFIXEDASSET Original Asset That Was Transferred CHAR 4 0 AIBN2
MASTERFIXEDASSETSEARCHTERM Search Term for Matchcode Search CHAR 30 0 MCOA1
ASSETSTATUSATPURCHASE Asset Status at Purchase: New, Used or Unknown CHAR 1 0 FIS_ASSET_PURCHASED_NEW_OR_USD
N New
X Used
Y Unknown
ASSETISACQUIREDUSED Asset acquired used CHAR 1 0 XAFABCH
ISMAINASSET Indicator for Main Asset CHAR 1 0 FAA_MD_XMAIN
ASSETLIFECYCLESTATUS Lifecycle Status CHAR 1 0 FAA_MD_LC_STATUS
1 Created
2 Deleted
3 Acquired
4 Capitalized
5 Deactivated
6 Archivable
7 Archived and Deletable
8 Archived and Deleted
9 In Migration
ASSETCOMPLETENESSSTATUS Completeness Status CHAR 1 0 FAA_MD_COMPL_STATUS
0 Complete
1 Incomplete Postable
2 Incomplete
ASSETUNDERCONSTRUCTIONSTATUS Asset Under Construction Status CHAR 1 0 FAA_MD_AUC_STATUS
0 No AuC or Summary Management of AuC
1 Line Item Settlement
2 Investment Measure
ASSETCREATIONVALIDITYDATE Validity Date from Asset Class DATS 8 0 FAA_MD_VALIDITY_DATE
CREATIONDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
LASTCHANGEDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
ASSETSCREENLAYOUT Layout for Asset Master Data CHAR 20 0 FAA_LAYOUT
ORIGINALACQUISITIONAMOUNT Original Acquisition Value CURR 23 2 URWRT
ORIGINALACQUISITIONCURRENCY Original Acquisition Value Currency CUKY 5 0 FAA_MD_ORG_ACQ_CURR
PROPERTYCLASS Property classification key CHAR 4 0 T092 VMGLI
LOCALTAXOFFICE Local Tax Office CHAR 25 0 FIAMT
MUNICIPALITY Municipality CHAR 25 0 ORT01_ANLA
LANDREGISTERDATE Land Register of DATS 8 0 GRUVO_ANLA
LANDREGISTERENTRYSEQUENCE Land Register Entry: Sequence Number CHAR 4 0 GRLFD_ANLA
LANDREGISTERENTRYDATE Land Register Entry on DATS 8 0 GREIN_ANLA
LANDREGISTERVOLUME Land Register Volume CHAR 5 0 GRBND_ANLA
LANDREGISTERPAGE Land Register Page CHAR 5 0 GRBLT_ANLA
LANDREGISTERMAP Land Register Map Number CHAR 4 0 FLURK_ANLA
LANDPLOT Plot Number CHAR 10 0 FLURN_ANLA
CONVEYANCEDATE Date of conveyance DATS 8 0 AUFLA_ANLA
AREASIZE Surface Area QUAN 13 3 GRUFL
LEASESUPPLIER Leasing company CHAR 10 0 LFA1 LEAFI
LEASEAGREEMENT Leasing agreement number CHAR 15 0 LVTNR
LEASEAGREEMENTDATE Leasing agreement date DATS 8 0 LVDAT
LEASETERMENDDATE Leasing agreement notice date DATS 8 0 LKDAT
LEASETERMSTARTDATE Lease start date DATS 8 0 LEABG
LEASEDURATIONINFISCALYEARS Length of Lease in Years NUMC 3 0 LEJAR
LEASEDURATIONINFISCALPERIODS Length of lease in periods NUMC 3 0 LEPER
LEASETYPE Leasing type CHAR 2 0 T083L LEART
LEASEDASSETNOTE Leasing data text CHAR 50 0 LETXT
LEGACYASSET Legacy Asset Number CHAR 16 0 FAA_LEGACYASSET
LEGACYFIXEDASSETCOMPANYCODE Legacy Fixed Asset Company Code CHAR 80 0 FAA_MD_LDT_COMP_CODE
LEGACYMASTERFIXEDASSET Legacy Main Asset Number CHAR 80 0 FAA_MD_LDT_ASSET_NO
LEGACYFIXEDASSET Legacy Asset Subnumber CHAR 5 0 FAA_MD_LDT_ASSET_SUBNO
LEGACYDATATRANSFERSEQUENCE Legacy Data Transfer - sequence number NUMC 5 0 FAA_LDT_SEQNO
ASSETISFORPOSTCAPITALIZATION Indicator for Asset for Post-Cap. CHAR 1 0 FAA_MD_XPOSTCAP
ASSETAUTHORIZATIONCONTEXT Asset Authorization Context CHAR 10 0 FAA_AUTHCNTXT
CLASSIC Classic Asset Accounting
NEW Redesigned Asset Accounting
OBJECTINTERNALID Object number CHAR 22 0 ONR00 J_OBJNR

IFIXASSET foreign key relationships

Table Field Check Table Check Field
0 IFIXASSET AREASIZEUNIT T006 Units of Measurement MANDT
0 IFIXASSET AREASIZEUNIT T006 Units of Measurement MSEHI
1 IFIXASSET ASSETACCOUNTDETERMINATION FAAV_ACCOUNT_DET Generated Table for View MANDT
0 IFIXASSET ASSETCLASS FAAV_ASSET_CLASS Generated Table for View MANDT
1 IFIXASSET ASSETCOUNTRYOFORIGIN T005 Countries MANDT
1 IFIXASSET ASSETCOUNTRYOFORIGIN T005 Countries LAND1
0 IFIXASSET BASEUNIT T006 Units of Measurement MANDT
0 IFIXASSET BASEUNIT T006 Units of Measurement MSEHI
1 IFIXASSET CURRENCY TCURC Currency Codes WAERS
0 IFIXASSET ENVRNMTLINVESTMENTREASON T087K Reason for investment protecting the environment MANDT
1 IFIXASSET FIXEDASSETGROUP T087U Asset group number / asset group MANDT
1 IFIXASSET FIXEDASSETGROUP T087U Asset group number / asset group ANLUE
0 IFIXASSET FIXEDASSETPROPERTYTYPE T097 Property indicator MANDT
0 IFIXASSET FIXEDASSETPROPERTYTYPE T097 Property indicator EIGKZ
1 IFIXASSET GROUP1ASSETEVALUATIONKEY T087 Evaluation groups MANDT
1 IFIXASSET GROUP1ASSETEVALUATIONKEY T087 Evaluation groups ORDNR
1 IFIXASSET GROUP1ASSETEVALUATIONKEY T087 Evaluation groups ORD4X
0 IFIXASSET GROUP2ASSETEVALUATIONKEY T087 Evaluation groups MANDT
0 IFIXASSET GROUP2ASSETEVALUATIONKEY T087 Evaluation groups ORDNR
0 IFIXASSET GROUP2ASSETEVALUATIONKEY T087 Evaluation groups ORD4X
1 IFIXASSET GROUP3ASSETEVALUATIONKEY T087 Evaluation groups MANDT
1 IFIXASSET GROUP3ASSETEVALUATIONKEY T087 Evaluation groups ORDNR
1 IFIXASSET GROUP3ASSETEVALUATIONKEY T087 Evaluation groups ORD4X
0 IFIXASSET GROUP4ASSETEVALUATIONKEY T087 Evaluation groups MANDT
0 IFIXASSET GROUP4ASSETEVALUATIONKEY T087 Evaluation groups ORDNR
0 IFIXASSET GROUP4ASSETEVALUATIONKEY T087 Evaluation groups ORD4X
1 IFIXASSET GROUP5ASSETEVALUATIONKEY T087G Evaluation group 8 places MANDT
0 IFIXASSET INVESTMENTPROJECTWBSELEMENT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 IFIXASSET INVESTMENTPROJECTWBSELEMENT PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 IFIXASSET INVESTMENTREASON T087I Reason for investment MANDT
1 IFIXASSET INVESTMENTREASON T087I Reason for investment IZWEK
0 IFIXASSET LEASESUPPLIER LFA1 Supplier Master (General Section) MANDT
0 IFIXASSET LEASESUPPLIER LFA1 Supplier Master (General Section) LIFNR
1 IFIXASSET LEASETYPE T083L Leasing types MANDT
1 IFIXASSET LEASETYPE T083L Leasing types LEART
0 IFIXASSET MANUALDEPRECIATIONREASON T098 Basis manual property evaluation MANDT
1 IFIXASSET MASTERFIXEDASSET ANLH Main asset number BUKRS
1 IFIXASSET MASTERFIXEDASSET ANLH Main asset number ANLN1
0 IFIXASSET OBJECTINTERNALID ONR00 General Object Number MANDT
0 IFIXASSET OBJECTINTERNALID ONR00 General Object Number OBJNR
1 IFIXASSET PARTNERCOMPANY T880 Global Company Data (for KONS Ledger) MANDT
1 IFIXASSET PARTNERCOMPANY T880 Global Company Data (for KONS Ledger) RCOMP
0 IFIXASSET PROPERTYCLASS T092 Property classification key MANDT
1 IFIXASSET SUPPLIER LFA1 Supplier Master (General Section) MANDT
1 IFIXASSET SUPPLIER LFA1 Supplier Master (General Section) LIFNR