FAAT_MD

Fixed Asset Master: Time Independent Data | #masterdata | Component: Master Data
Column Name Description
CLIENT Client
COMP_CODE FK Company Code
ASSET_NO Main Asset Number
ASSET_SUBNO Asset Subnumber
Column Name Description
💲 Original Acquisition Value Currency (ORIGINAL_ACQ_VALUE_CURR):
ORIGINAL_ACQ_VALUE Original Acquisition Value
Column Name Description
📏 Area Unit (SURFACE_AREA_UNIT):
SURFACE_AREA Surface Area
Column Name Description
ORIGINAL_ACQ_DATE Original Acquisition Date of AuC/ Transferred Asset
INVENTORY_DATE Last Inventory Date
ASSESSMENT_DATE Date of last notice of assessment
LAND_REGISTER_OF Land Register of
LAND_REGISTER_ENTRY Land Register Entry on
CONVEYANCE_DATE Date of conveyance
LEASE_AGREEMENT_DATE Leasing agreement date
LEASE_NOTICE_DATE Leasing agreement notice date
LEASE_START_DATE Lease start date
LEGACY_TRANSFER_DATE Legacy Data Transfer Date
PURCHASE_ORDER_DATE Asset Purchase Order Date
LAST_REORG_DATE Date of Last Reorganization
Column Name Description
ASSET_ACQUIRED_USED Asset acquired used Show values
INVENTORY_INDICATOR Inventory Indicator Show values
REAL_ESTATE_ASSET Indicator: Real Estate Show values
LEASE_PERIODS Length of lease in periods Show values
Column Name Description Domain name
SCREEN_LAYOUT Layout for Asset Master Data
DESCRIPTION Asset Description TEXT50
ADD_DESCRIPTION Additional Asset Description TEXT50
SERIAL_NUMBER Serial number GERNR
INVENTORY_NUMBER Inventory Number INVNR_ANLA
MANUFACTURER Manufacturer of Asset TEXT30
ORIGINAL_ASSET Original Asset That Was Transferred ANLN1
ORIGINAL_SUBASSET Original Asset That Was Transferred ANLN2
ORIGINAL_ACQ_YEAR Fiscal Year of Original Acquisition GJAHR
INHOUSE_PROD_PERCENT In-house production percentage PRZ32
ASSET_TYPE_NAME Asset Type Name TYPBZ_ANLA
INVESTMENT_WBS_ORIGIN WBS element investment project PS_POSNR
INVESTMENT_IO_ORIGIN Investment Order AUFNR
INVENTORY_NOTE Supplementary Inventory Specifications INVZU_ANLA
ASSET_SUPER_NO Asset Super Number ANLUE
LAND_TAX_OFFICE Local Tax Office TEXT25
ASSESSMENT_TAX_NUMBER Tax Number of the Notice of Assessment EHWNR_ANLA
LAND_MUNICIPALITY Municipality TEXT25
LAND_REGISTER_ENTRY_NUMBER Land Register Entry: Sequence Number GRLFD_ANLA
LAND_REGISTER_VOLUME Land Register Volume GRBND_ANLA
LAND_REGISTER_PAGE Land Register Page GRBLT_ANLA
LAND_REGISTER_MAP_NO Land Register Map Number CHAR4
LAND_PLOT_NUMBER Plot Number CHAR10
LEASE_AGREEMENT_NO Leasing agreement number CHAR15
LEASE_YEARS Length of Lease in Years JARAF
LEASE_DATA_TEXT Leasing data text TEXT50
LEGACY_COMP_CODE Legacy Fixed Asset Company Code FAA_MD_LDT_COMP_CODE
LEGACY_ASSET_NO Legacy Main Asset Number FAA_MD_LDT_ASSET_NO
LEGACY_ASSET_SUBNO Legacy Asset Subnumber FAA_MD_LDT_ASSET_SUBNO
LEGACY_TRANSFER_SEQ_NO Legacy Data Transfer - sequence number NUMC5
OBJECT_NR Object number J_OBJNR
CREATION_USER Name of Person Responsible for Creating the Object USNAM
CREATION_DATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LASTCHANGE_USER Name of Person Who Changed Object USNAM
LASTCHANGE_DATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
DUMMY_FAA_MD_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Base Unit of Measure
  • FAAT_MD.CLIENT == T006.MANDT
  • FAAT_MD.BASE_UNIT == T006.MSEHI
Reason for Environmental Investment
  • FAAT_MD.CLIENT == T087K.MANDT
  • FAAT_MD.ENVIRONMENTAL_INVESTMENT == T087K.UMWKZ
Reason for Investment
  • FAAT_MD.CLIENT == T087I.MANDT
  • FAAT_MD.INVEST_REASON == T087I.IZWEK
Leasing company
  • FAAT_MD.CLIENT == LFA1.MANDT
  • FAAT_MD.LEASE_COMPANY == LFA1.LIFNR
Leasing type
  • FAAT_MD.CLIENT == T083L.MANDT
  • FAAT_MD.LEASE_TYPE == T083L.LEART
Original Acquisition Value Currency
  • FAAT_MD.CLIENT == TCURC.MANDT
  • FAAT_MD.ORIGINAL_ACQ_VALUE_CURR == TCURC.WAERS
Asset's Country/Region of Origin
  • Asset's Country/Region of Origin
  • Client
  • FAAT_MD.ORIGIN_COUNTRY == T005.LAND1
  • FAAT_MD.CLIENT == T005.MANDT
Property Indicator
  • Property Indicator
  • Client
  • FAAT_MD.PROPERTY_IND == T097.EIGKZ
  • FAAT_MD.CLIENT == T097.MANDT
Property classification key
  • Property classification key
  • Client
  • FAAT_MD.PROPERTY_KEY == T092.VMGLI
  • FAAT_MD.CLIENT == T092.MANDT
Account number of vendor (other key word)
  • FAAT_MD.CLIENT == LFA1.MANDT
  • FAAT_MD.SUPPLIER_NO == LFA1.LIFNR
Area Unit
  • FAAT_MD.CLIENT == T006.MANDT
  • FAAT_MD.SURFACE_AREA_UNIT == T006.MSEHI
Company ID of Trading Partner
  • FAAT_MD.CLIENT == T880.MANDT
  • FAAT_MD.TRADE_ID == T880.RCOMP