FAA_ASSETS4

Asset S4 | view: FAAVASSETS4 | Extraction: Not supported | Component: Master Data
Tables used: FAAT_MDFAAT_MD_ROOTT001
Column Name Description
companycode FK Company Code
masterfixedasset Main Asset Number
fixedasset Asset Subnumber
Column Name Description
💲 Original Acquisition Value Currency (originalacquisitioncurrency):
originalacquisitionamount Original Acquisition Value
Column Name Description
📏 Area Unit (areasizeunit):
areasize Surface Area
Column Name Description
fixedassetorderdate Asset Purchase Order Date
lastinventorydate Last Inventory Date
lastassessmentnoticedate Date of last notice of assessment
lastchangedate Changed On
originalfixedassetvaluedate Original Acquisition Date of AuC/ Transferred Asset
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 for Historical Management Show values
assetisrealestate Indicator: Real Estate Show values
inventoryiscounted Inventory Indicator Show values
fixedassetfindatacmpltns Completeness Status Show values
accountisblockedforposting Indicator: Blocked Against Acquisition Postings Show values
assetstatusatpurchase Asset acquired used 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
Column Name Description Domain name
fixedassetexternalid null
assetserialnumber Serial number GERNR
quantity null
inventory Inventory Number INVNR_ANLA
fixedassetdescription Asset Description TEXT50
assetadditionaldescription Additional Asset Description TEXT50
origlacqnamtincocodecrcy null
assetmanufacturername Manufacturer of Asset TEXT30
inhouseprodnpercent In-house production percentage PRZ32
assetsuppliername null
inventorynote Supplementary Inventory Specifications INVZU_ANLA
group1assetevaluationkey null
group2assetevaluationkey null
group3assetevaluationkey null
group4assetevaluationkey null
group5assetevaluationkey null
assetcapitalizationdate null
firstacquisitionfiscalyear null
firstacquisitionfiscalperiod null
assetdeactivationdate null
plannedretirementdate null
originalmasterfixedasset Original Asset That Was Transferred ANLN1
fixedassetgroup Asset Super Number ANLUE
investmentorder Investment Order AUFNR
investmentprojectwbselement WBS element investment project PS_POSNR
assetsynchronizationrule null
originalacquisitionfiscalyear Fiscal Year of Original Acquisition GJAHR
assettypename Asset Type Name TYPBZ_ANLA
noticeofassessmenttaxid Tax Number of the Notice of Assessment EHWNR_ANLA
accountismarkedfordeletion null
acquisitionvaluedate null
assetunderconstisinvmtmsr null
lastretirementvaluedate null
lastchangedbyuser Name of Person Who Changed Object USNAM
createdbyuser Name of Person Responsible for Creating the Object USNAM
manualdepreciationreason null
isgroupasset null
islineitemsettled null
originalfixedasset Original Asset That Was Transferred ANLN2
masterfixedassetsearchterm Asset Description TEXT50
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 Main Asset Number FAA_MD_LDT_ASSET_NO
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
  • Client
  • Area Unit
  • FAA_ASSETS4.MANDT == T006.MANDT
  • FAA_ASSETS4.AREASIZEUNIT == T006.MSEHI
Asset's Country/Region of Origin
  • Client
  • Asset's Country/Region of Origin
  • FAA_ASSETS4.MANDT == T005.MANDT
  • FAA_ASSETS4.ASSETCOUNTRYOFORIGIN == T005.LAND1
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FAA_ASSETS4.MANDT == T006.MANDT
  • FAA_ASSETS4.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • FAA_ASSETS4.MANDT == TCURC.MANDT
  • FAA_ASSETS4.CURRENCY == TCURC.WAERS
Reason for Environmental Investment
  • Client
  • Reason for Environmental Investment
  • FAA_ASSETS4.MANDT == T087K.MANDT
  • FAA_ASSETS4.ENVRNMTLINVESTMENTREASON == T087K.UMWKZ
Property Indicator
  • Client
  • Property Indicator
  • FAA_ASSETS4.MANDT == T097.MANDT
  • FAA_ASSETS4.FIXEDASSETPROPERTYTYPE == T097.EIGKZ
Reason for Investment
  • Client
  • Reason for Investment
  • FAA_ASSETS4.MANDT == T087I.MANDT
  • FAA_ASSETS4.INVESTMENTREASON == T087I.IZWEK
Leasing company
  • Client
  • Leasing company
  • FAA_ASSETS4.MANDT == LFA1.MANDT
  • FAA_ASSETS4.LEASESUPPLIER == LFA1.LIFNR
Leasing type
  • Client
  • Leasing type
  • FAA_ASSETS4.MANDT == T083L.MANDT
  • FAA_ASSETS4.LEASETYPE == T083L.LEART
Original Acquisition Value Currency
  • Client
  • Original Acquisition Value Currency
  • FAA_ASSETS4.MANDT == TCURC.MANDT
  • FAA_ASSETS4.ORIGINALACQUISITIONCURRENCY == TCURC.WAERS
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FAA_ASSETS4.MANDT == T880.MANDT
  • FAA_ASSETS4.PARTNERCOMPANY == T880.RCOMP
Property classification key
  • Client
  • Property classification key
  • FAA_ASSETS4.MANDT == T092.MANDT
  • FAA_ASSETS4.PROPERTYCLASS == T092.VMGLI
Account number of vendor (other key word)
  • Client
  • Account number of vendor (other key word)
  • FAA_ASSETS4.MANDT == LFA1.MANDT
  • FAA_ASSETS4.SUPPLIER == LFA1.LIFNR