FAAT_MD

Transparent Table Application Table
72 Fields 7 CDS Views

Fixed Asset Master: Time Independent Data

FAAT_MD is an SAP database table in S/4HANA. Fixed Asset Master: Time Independent Data. It contains 72 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_Asset view from EXTENSION Fixed Asset Master Data - Extension
FAA_ASSETS4 view left_outer Unit Test View for Asset
FAA_ES_ASSET_MD view left_outer Fixed Asset Master Data for Enterprise Search
FAA_UPA_MIG_BALANCE01 view_entity inner Asset balance cube 01
I_FixedAssetInLegacySystemVH view from BASIC Maintained Legacy Asset Value Help
I_FxdAstCoCodeInLegacySystemVH view_entity from BASIC Legacy Company Code
I_MstrFxdAstInLegacySystemVH view_entity from BASIC Legacy Master Fixed Asset

Fields (72)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY comp_code BUKRS Company Code
KEY asset_no ANLN1 Asset
KEY asset_subno ANLN2 Sub-number
asset_class ANLKL Asset Class
screen_layout FAA_LAYOUT Master Data Layout
gl_account_det KTOGR Account Determ.
description TXA50_ANLT Description
add_description TXA50_MORE Description (2)
serial_number AM_SERNR Serial number
inventory_number INVNR_ANLA Inventory No.
supplier_no AM_LIFNR Vendor
origin_country AM_LAND1 Origin C/R
manufacturer HERST Manufacturer
original_asset AIBN1 Original Asset
original_subasset AIBN2 Asset Sub-No. AuC
original_acq_date AIBDT Acq.Orig.Ast.On
original_acq_year URJHR Org. Acq. Year
original_acq_value URWRT Original Value
original_acq_value_curr FAA_MD_ORG_ACQ_CURR Orig Acq Crcy
inhouse_prod_percent ANTEI In-H.Prod.Perc.
asset_type_name TYPBZ_ANLA Type Name
trade_id RASSC Trading Partner
asset_acquired_used XAFABCH Used indicator
investment_wbs_origin AM_POSNR WBS Element
investment_io_origin AM_AUFNR Inv. Order
inventory_date IVDAT_ANLA Last Inventory
inventory_note INVZU_ANLA Inventory Note
inventory_indicator INKEN Inventory Ind.
invest_reason IZWEK Invest. Reason
environmental_investment AM_UMWKZ Envir. Invest.
asset_super_no ANLUE Asset Super No.
property_key VMGLI Prop.classif.
property_ind EIGKZ Property Indic.
land_tax_office FIAMT Tax Office
assessment_tax_number EHWNR_ANLA Assmt Tax No.
assessment_date EHWZU_ANLA Notice on
land_municipality ORT01_ANLA Municipality
land_register_of GRUVO_ANLA Land Regist. of
land_register_entry_number GRLFD_ANLA LandRegEntSeqNo
land_register_entry GREIN_ANLA Entry by
land_register_volume GRBND_ANLA Lnd Reg. Volume
land_register_page GRBLT_ANLA Land Reg. Page
land_register_map_no FLURK_ANLA Ld.Reg.Map.No
land_plot_number FLURN_ANLA Plot No.
conveyance_date AUFLA_ANLA Conveyance
surface_area GRUFL Area
surface_area_unit FEINS Area Unit
real_estate_asset AIMMO Connection to SAP Real Estate Management
lease_company LEAFI Lessor
lease_agreement_no LVTNR Agreement no.
lease_agreement_date LVDAT Agreement Date
lease_notice_date LKDAT Notice date
lease_start_date LEABG Leas.start date
lease_years LEJAR Lease Length
lease_periods LEPER Periods
lease_type LEART Type
lease_data_text LETXT Suppl. text
legacy_comp_code FAA_MD_LDT_COMP_CODE Legacy Comp. Code
legacy_asset_no FAA_MD_LDT_ASSET_NO Legacy Main No.
legacy_asset_subno FAA_MD_LDT_ASSET_SUBNO Legacy Subnumber
legacy_transfer_date FAA_LDT_DATE Transfer Date
legacy_transfer_seq_no FAA_LDT_SEQNO Sequence Number
base_unit MEINS Base Unit
purchase_order_date BSTDT Ordered On
last_reorg_date FAA_LAST_REORG Reorganization Date
object_nr J_OBJNR Object number
creation_user ERNAM Created By
creation_datetime TIMESTAMP Time Stamp
lastchange_user AENAM Changed By
lastchange_datetime TIMESTAMP Time Stamp
dummy_faa_md_eew_ps CFD_DUMMY Dummy

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Fixed Asset Master: Time Independent Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_MD (
    CLIENT,                      -- Client [MANDT]
    COMP_CODE,                   -- Company Code [BUKRS]
    ASSET_NO,                    -- Asset [ANLN1]
    ASSET_SUBNO,                 -- Sub-number [ANLN2]
    ASSET_CLASS,                 -- Asset Class [ANLKL]
    SCREEN_LAYOUT,               -- Master Data Layout [FAA_LAYOUT]
    GL_ACCOUNT_DET,              -- Account Determ. [KTOGR]
    DESCRIPTION,                 -- Description [TXA50_ANLT]
    ADD_DESCRIPTION,             -- Description (2) [TXA50_MORE]
    SERIAL_NUMBER,               -- Serial number [AM_SERNR]
    INVENTORY_NUMBER,            -- Inventory No. [INVNR_ANLA]
    SUPPLIER_NO,                 -- Vendor [AM_LIFNR]
    ORIGIN_COUNTRY,              -- Origin C/R [AM_LAND1]
    MANUFACTURER,                -- Manufacturer [HERST]
    ORIGINAL_ASSET,              -- Original Asset [AIBN1]
    ORIGINAL_SUBASSET,           -- Asset Sub-No. AuC [AIBN2]
    ORIGINAL_ACQ_DATE,           -- Acq.Orig.Ast.On [AIBDT]
    ORIGINAL_ACQ_YEAR,           -- Org. Acq. Year [URJHR]
    ORIGINAL_ACQ_VALUE,          -- Original Value [URWRT]
    ORIGINAL_ACQ_VALUE_CURR,     -- Orig Acq Crcy [FAA_MD_ORG_ACQ_CURR]
    INHOUSE_PROD_PERCENT,        -- In-H.Prod.Perc. [ANTEI]
    ASSET_TYPE_NAME,             -- Type Name [TYPBZ_ANLA]
    TRADE_ID,                    -- Trading Partner [RASSC]
    ASSET_ACQUIRED_USED,         -- Used indicator [XAFABCH]
    INVESTMENT_WBS_ORIGIN,       -- WBS Element [AM_POSNR]
    INVESTMENT_IO_ORIGIN,        -- Inv. Order [AM_AUFNR]
    INVENTORY_DATE,              -- Last Inventory [IVDAT_ANLA]
    INVENTORY_NOTE,              -- Inventory Note [INVZU_ANLA]
    INVENTORY_INDICATOR,         -- Inventory Ind. [INKEN]
    INVEST_REASON,               -- Invest. Reason [IZWEK]
    ENVIRONMENTAL_INVESTMENT,    -- Envir. Invest. [AM_UMWKZ]
    ASSET_SUPER_NO,              -- Asset Super No. [ANLUE]
    PROPERTY_KEY,                -- Prop.classif. [VMGLI]
    PROPERTY_IND,                -- Property Indic. [EIGKZ]
    LAND_TAX_OFFICE,             -- Tax Office [FIAMT]
    ASSESSMENT_TAX_NUMBER,       -- Assmt Tax No. [EHWNR_ANLA]
    ASSESSMENT_DATE,             -- Notice on [EHWZU_ANLA]
    LAND_MUNICIPALITY,           -- Municipality [ORT01_ANLA]
    LAND_REGISTER_OF,            -- Land Regist. of [GRUVO_ANLA]
    LAND_REGISTER_ENTRY_NUMBER,  -- LandRegEntSeqNo [GRLFD_ANLA]
    LAND_REGISTER_ENTRY,         -- Entry by [GREIN_ANLA]
    LAND_REGISTER_VOLUME,        -- Lnd Reg. Volume [GRBND_ANLA]
    LAND_REGISTER_PAGE,          -- Land Reg. Page [GRBLT_ANLA]
    LAND_REGISTER_MAP_NO,        -- Ld.Reg.Map.No [FLURK_ANLA]
    LAND_PLOT_NUMBER,            -- Plot No. [FLURN_ANLA]
    CONVEYANCE_DATE,             -- Conveyance [AUFLA_ANLA]
    SURFACE_AREA,                -- Area [GRUFL]
    SURFACE_AREA_UNIT,           -- Area Unit [FEINS]
    REAL_ESTATE_ASSET,           -- Connection to SAP Real Estate Management [AIMMO]
    LEASE_COMPANY,               -- Lessor [LEAFI]
    LEASE_AGREEMENT_NO,          -- Agreement no. [LVTNR]
    LEASE_AGREEMENT_DATE,        -- Agreement Date [LVDAT]
    LEASE_NOTICE_DATE,           -- Notice date [LKDAT]
    LEASE_START_DATE,            -- Leas.start date [LEABG]
    LEASE_YEARS,                 -- Lease Length [LEJAR]
    LEASE_PERIODS,               -- Periods [LEPER]
    LEASE_TYPE,                  -- Type [LEART]
    LEASE_DATA_TEXT,             -- Suppl. text [LETXT]
    LEGACY_COMP_CODE,            -- Legacy Comp. Code [FAA_MD_LDT_COMP_CODE]
    LEGACY_ASSET_NO,             -- Legacy Main No. [FAA_MD_LDT_ASSET_NO]
    LEGACY_ASSET_SUBNO,          -- Legacy Subnumber [FAA_MD_LDT_ASSET_SUBNO]
    LEGACY_TRANSFER_DATE,        -- Transfer Date [FAA_LDT_DATE]
    LEGACY_TRANSFER_SEQ_NO,      -- Sequence Number [FAA_LDT_SEQNO]
    BASE_UNIT,                   -- Base Unit [MEINS]
    PURCHASE_ORDER_DATE,         -- Ordered On [BSTDT]
    LAST_REORG_DATE,             -- Reorganization Date [FAA_LAST_REORG]
    OBJECT_NR,                   -- Object number [J_OBJNR]
    CREATION_USER,               -- Created By [ERNAM]
    CREATION_DATETIME,           -- Time Stamp [TIMESTAMP]
    LASTCHANGE_USER,             -- Changed By [AENAM]
    LASTCHANGE_DATETIME,         -- Time Stamp [TIMESTAMP]
    DUMMY_FAA_MD_EEW_PS,         -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO)
);

Learn More