I_FixedAsset

Fixed Asset | view: IFIXASSET | ATTR | Extraction: Full or Incremental | Component: Information System
Tables used: ANLA, FAAT_MD, FAAT_MD_ROOT, T001
Column Name Description
CompanyCode FK Company Code
MasterFixedAsset FK Main Asset Number
FixedAsset Asset Subnumber
Column Name Description
💲 Currency Key (Currency):
OriglAcqnAmtInCoCodeCrcy Original Acquisition Value
💲 Original Acquisition Value Currency (OriginalAcquisitionCurrency):
OriginalAcquisitionAmount Original Acquisition Value
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
📏 Area Unit (AreaSizeUnit):
AreaSize Surface Area
Column Name Description
AssetCapitalizationDate Asset Capitalization Date
AssetDeactivationDate Deactivation Date
PlannedRetirementDate Planned Retirement Date
FixedAssetOrderDate Asset Purchase Order Date
LastInventoryDate Last Inventory Date
LastAssessmentNoticeDate Date of last notice of assessment
LastChangeDate Changed On
AcquisitionValueDate Asset Value Date of the First Posting
OriginalFixedAssetValueDate Original Acquisition Date of AuC/ Transferred Asset
LastRetirementValueDate Asset Value Date for the Last Retirement
CreationDate Date on which the record was created
LastReorganizationDate Date of Last Reorganization
LegacyDataTransferDate Legacy Data Transfer Date
AssetCreationValidityDate Validity Date from Asset Class
LandRegisterDate Land Register of
LandRegisterEntryDate Land Register Entry on
ConveyanceDate Date of conveyance
LeaseAgreementDate Leasing agreement date
LeaseTermEndDate Leasing agreement notice date
LeaseTermStartDate Lease start date
Column Name Description
HasHistory Indicator: Historical management Show values
AssetIsRealEstate Indicator: Real Estate Show values
InventoryIsCounted Inventory Indicator Show values
AssetSynchronizationRule Change Asset Master Record from Equipment Master Show values
FixedAssetFinDataCmpltns Completeness indicator for the asset Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
AccountIsBlockedForPosting Indicator: Asset Locked to Acquisition Postings Show values
AssetUnderConstIsInvmtMsr Asset under Construction for Investment Measures Show values
IsGroupAsset Indicator: Asset is a group asset Show values
IsLineItemSettled Asset under construct. with line item settlement Show values
AssetStatusAtPurchase Asset Status at Purchase: New, Used or Unknown Show values
AssetIsAcquiredUsed Asset acquired used Show values
IsMainAsset Indicator for Main Asset Show values
AssetLifecycleStatus Lifecycle Status Show values
AssetCompletenessStatus Completeness Status Show values
AssetUnderConstructionStatus Asset Under Construction Status Show values
LeaseDurationInFiscalPeriods Length of lease in periods Show values
AssetIsForPostCapitalization Indicator for Asset for Post-Cap. Show values
AssetAuthorizationContext Asset Authorization Context Show values
Column Name Description Domain name
FixedAssetExternalID Asset Number CHAR17
AssetSerialNumber Serial number GERNR
Inventory Inventory Number INVNR_ANLA
FixedAssetDescription Asset Description TEXT50
AssetAdditionalDescription Additional Asset Description TEXT50
AssetManufacturerName Manufacturer of Asset TEXT30
InHouseProdnPercent In-house production percentage PRZ32
AssetSupplierName Name of asset supplier TEXT30
InventoryNote Supplementary Inventory Specifications INVZU_ANLA
FirstAcquisitionFiscalYear Fiscal Year in Which First Acquisition Was Posted GJAHR
FirstAcquisitionFiscalPeriod Period in Which First Acquisition Was Posted POPER
OriginalMasterFixedAsset Original Asset That Was Transferred ANLN1
InvestmentOrder Investment Order AUFNR
OriginalAcquisitionFiscalYear Fiscal Year of Original Acquisition GJAHR
AssetTypeName Asset Type Name TYPBZ_ANLA
NoticeOfAssessmentTaxID Tax Number of the Notice of Assessment EHWNR_ANLA
LastChangedByUser Name of Person Who Changed Object USNAM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
OriginalFixedAsset Original Asset That Was Transferred ANLN2
MasterFixedAssetSearchTerm Search Term for Matchcode Search CHAR30
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
AssetScreenLayout Layout for Asset Master Data
LocalTaxOffice Local Tax Office TEXT25
Municipality Municipality TEXT25
LandRegisterEntrySequence Land Register Entry: Sequence Number GRLFD_ANLA
LandRegisterVolume Land Register Volume GRBND_ANLA
LandRegisterPage Land Register Page GRBLT_ANLA
LandRegisterMap Land Register Map Number CHAR4
LandPlot Plot Number CHAR10
LeaseAgreement Leasing agreement number CHAR15
LeaseDurationInFiscalYears Length of Lease in Years JARAF
LeasedAssetNote Leasing data text TEXT50
LegacyAsset Legacy Asset Number
LegacyFixedAssetCompanyCode Legacy Fixed Asset Company Code FAA_MD_LDT_COMP_CODE
LegacyMasterFixedAsset Legacy Main Asset Number FAA_MD_LDT_ASSET_NO
LegacyFixedAsset Legacy Asset Subnumber FAA_MD_LDT_ASSET_SUBNO
LegacyDataTransferSequence Legacy Data Transfer - sequence number NUMC5
Master Data Relations Join Conditions
Area Unit
  • Area Unit
  • Client
  • I_FIXEDASSET.AREASIZEUNIT == T006.MSEHI
  • I_FIXEDASSET.MANDT == T006.MANDT
Asset's Country/Region of Origin
  • Asset's Country/Region of Origin
  • Client
  • I_FIXEDASSET.ASSETCOUNTRYOFORIGIN == T005.LAND1
  • I_FIXEDASSET.MANDT == T005.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_FIXEDASSET.BASEUNIT == T006.MSEHI
  • I_FIXEDASSET.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • I_FIXEDASSET.CURRENCY == TCURC.WAERS
  • I_FIXEDASSET.MANDT == TCURC.MANDT
Reason for Environmental Investment
  • Reason for Environmental Investment
  • Client
  • I_FIXEDASSET.ENVRNMTLINVESTMENTREASON == T087K.UMWKZ
  • I_FIXEDASSET.MANDT == T087K.MANDT
Asset Super Number
  • Asset Super Number
  • Client
  • I_FIXEDASSET.FIXEDASSETGROUP == T087U.ANLUE
  • I_FIXEDASSET.MANDT == T087U.MANDT
Property Indicator
  • Property Indicator
  • Client
  • I_FIXEDASSET.FIXEDASSETPROPERTYTYPE == T097.EIGKZ
  • I_FIXEDASSET.MANDT == T097.MANDT
Evaluation Group 1
  • ?
  • Evaluation group 1
  • Client
  • I_FIXEDASSET.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSET.GROUP1ASSETEVALUATIONKEY == T087.ORD4X
  • I_FIXEDASSET.MANDT == T087.MANDT
Evaluation Group 2
  • ?
  • Evaluation Group 2
  • Client
  • I_FIXEDASSET.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSET.GROUP2ASSETEVALUATIONKEY == T087.ORD4X
  • I_FIXEDASSET.MANDT == T087.MANDT
Evaluation Group 3
  • ?
  • Evaluation Group 3
  • Client
  • I_FIXEDASSET.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSET.GROUP3ASSETEVALUATIONKEY == T087.ORD4X
  • I_FIXEDASSET.MANDT == T087.MANDT
Evaluation group 4
  • ?
  • Evaluation group 4
  • Client
  • I_FIXEDASSET.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSET.GROUP4ASSETEVALUATIONKEY == T087.ORD4X
  • I_FIXEDASSET.MANDT == T087.MANDT
Guideline group
  • Evaluation Group 5
  • Client
  • I_FIXEDASSET.GROUP5ASSETEVALUATIONKEY == T087G.GDLGRP
  • I_FIXEDASSET.MANDT == T087G.MANDT
Reason for Investment
  • Reason for Investment
  • Client
  • I_FIXEDASSET.INVESTMENTREASON == T087I.IZWEK
  • I_FIXEDASSET.MANDT == T087I.MANDT
Leasing company
  • Leasing company
  • Client
  • I_FIXEDASSET.LEASESUPPLIER == LFA1.LIFNR
  • I_FIXEDASSET.MANDT == LFA1.MANDT
Leasing type
  • Leasing type
  • Client
  • I_FIXEDASSET.LEASETYPE == T083L.LEART
  • I_FIXEDASSET.MANDT == T083L.MANDT
Reason for Manual Valuation of Net Assets
  • Reason for Manual Valuation of Net Assets
  • Client
  • I_FIXEDASSET.MANUALDEPRECIATIONREASON == T098.GRUND
  • I_FIXEDASSET.MANDT == T098.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_FIXEDASSET.PARTNERCOMPANY == T880.RCOMP
  • I_FIXEDASSET.MANDT == T880.MANDT
Property classification
  • Property classification key
  • Client
  • I_FIXEDASSET.PROPERTYCLASS == T092.VMGLI
  • I_FIXEDASSET.MANDT == T092.MANDT
Account number of vendor (other key word)
  • Account number of vendor (other key word)
  • Client
  • I_FIXEDASSET.SUPPLIER == LFA1.LIFNR
  • I_FIXEDASSET.MANDT == LFA1.MANDT