SAP Table

IFIXASSET Generated Table for View

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

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

/ Fields

IFIXASSET columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 MANDT
KeyCOMPANYCODE Company Code CHAR 4 0 FAAV_COMP_CODE BUKRS
KeyMASTERFIXEDASSET Main Asset Number CHAR 12 0 ANLH ANLN1
KeyFIXEDASSET 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
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
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
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
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
ASSETCOMPLETENESSSTATUS Completeness Status CHAR 1 0 FAA_MD_COMPL_STATUS
ASSETUNDERCONSTRUCTIONSTATUS Asset Under Construction Status CHAR 1 0 FAA_MD_AUC_STATUS
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
OBJECTINTERNALID Object number CHAR 22 0 ONR00 J_OBJNR
/ Relationships

IFIXASSET foreign keys.

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