FAA_MD_MIG

Migration View for New Master Data | view: FAAVMDMIG | Extraction: Not supported | Component: Master Data
Tables used: ANLAT001
Column Name Description
comp_code FK Company Code
asset_no FK Main Asset Number
asset_subno Asset Subnumber
Column Name Description
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 null
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
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 null
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
asset_acquired_used null
investment_io_origin Investment Order AUFNR
inventory_note Supplementary Inventory Specifications INVZU_ANLA
property_key null
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 null
legacy_asset_no null
legacy_asset_subno null
legacy_transfer_seq_no Legacy Data Transfer - sequence number NUMC5
creation_user Name of Person Responsible for Creating the Object USNAM
creation_datetime null
lastchange_user Name of Person Who Changed Object USNAM
lastchange_datetime null
Master Data Relations Join Conditions
Asset Super Number
  • Asset Super Number
  • Client
  • FAA_MD_MIG.ASSET_SUPER_NO == T087U.ANLUE
  • FAA_MD_MIG.MANDT == T087U.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FAA_MD_MIG.MANDT == T006.MANDT
  • FAA_MD_MIG.BASE_UNIT == T006.MSEHI
Reason for Environmental Investment
  • Client
  • Reason for Environmental Investment
  • FAA_MD_MIG.MANDT == T087K.MANDT
  • FAA_MD_MIG.ENVIRONMENTAL_INVESTMENT == T087K.UMWKZ
Reason for Investment
  • Reason for Investment
  • Client
  • FAA_MD_MIG.INVEST_REASON == T087I.IZWEK
  • FAA_MD_MIG.MANDT == T087I.MANDT
Leasing company
  • Client
  • Leasing company
  • FAA_MD_MIG.MANDT == LFA1.MANDT
  • FAA_MD_MIG.LEASE_COMPANY == LFA1.LIFNR
Leasing type
  • Client
  • Leasing type
  • FAA_MD_MIG.MANDT == T083L.MANDT
  • FAA_MD_MIG.LEASE_TYPE == T083L.LEART
Currency Key
  • Client
  • Currency Key
  • FAA_MD_MIG.MANDT == TCURC.MANDT
  • FAA_MD_MIG.ORIGINAL_ACQ_VALUE_CURR == TCURC.WAERS
Asset's Country/Region of Origin
  • Client
  • Asset's Country/Region of Origin
  • FAA_MD_MIG.MANDT == T005.MANDT
  • FAA_MD_MIG.ORIGIN_COUNTRY == T005.LAND1
Property Indicator
  • Client
  • Property Indicator
  • FAA_MD_MIG.MANDT == T097.MANDT
  • FAA_MD_MIG.PROPERTY_IND == T097.EIGKZ
Account number of vendor (other key word)
  • Account number of vendor (other key word)
  • Client
  • FAA_MD_MIG.SUPPLIER_NO == LFA1.LIFNR
  • FAA_MD_MIG.MANDT == LFA1.MANDT
Area Unit
  • Client
  • Area Unit
  • FAA_MD_MIG.MANDT == T006.MANDT
  • FAA_MD_MIG.SURFACE_AREA_UNIT == T006.MSEHI
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FAA_MD_MIG.MANDT == T880.MANDT
  • FAA_MD_MIG.TRADE_ID == T880.RCOMP