FAAT_MD_MULTI

Transparent Table Temporary Data
87 Fields 1 CDS Views

Fixed Asset Master: Multiple Asset

FAAT_MD_MULTI is an SAP database table in S/4HANA. Fixed Asset Master: Multiple Asset. It contains 87 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AssetMultipleCreation view from BASIC Asset Multiple Creation

Fields (87)

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
KEY row_index INT4 INT4
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
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
dummy_faa_md_eew_ps CFD_DUMMY Dummy
valid_from_date ADATU Valid From
business_area GSBER Business Area
cost_center KOSTL Cost Center
activity_type LSTAR Activity Type
internal_order CAUFN Int. Order
fund BP_GEBER Fund
grant_id GM_GRANT_NBR Grant
functional_area FKBER Functional Area
funds_center FISTL Funds Center
wbs_element FAA_MD_WBSELEMENT WBS Internal ID
tax_jurisdiction TXJCD Tax Jur.
real_estate_key IMKEY Real Estate Key
segment FB_SEGMENT Segment
profit_center PRCTR Profit Center
budget_period FM_BUDGET_PERIOD Budget Period
responsible_cost_center KOSTLV Resp. Cost Ctr
room RAUMNR Room
plant WERKS_D Plant
location STORT Location
car_license_plate AM_KFZKZ License Plate Number
personnel_number PERNR_D Personnel No.
business_place BUPLA Business place
dummy_faa_md_tdd_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: Multiple Asset
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_MD_MULTI (
    CLIENT,                      -- Client [MANDT]
    COMP_CODE,                   -- Company Code [BUKRS]
    ASSET_NO,                    -- Asset [ANLN1]
    ASSET_SUBNO,                 -- Sub-number [ANLN2]
    ROW_INDEX,                   -- INT4 [INT4]
    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]
    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]
    DUMMY_FAA_MD_EEW_PS,         -- Dummy [CFD_DUMMY]
    VALID_FROM_DATE,             -- Valid From [ADATU]
    BUSINESS_AREA,               -- Business Area [GSBER]
    COST_CENTER,                 -- Cost Center [KOSTL]
    ACTIVITY_TYPE,               -- Activity Type [LSTAR]
    INTERNAL_ORDER,              -- Int. Order [CAUFN]
    FUND,                        -- Fund [BP_GEBER]
    GRANT_ID,                    -- Grant [GM_GRANT_NBR]
    FUNCTIONAL_AREA,             -- Functional Area [FKBER]
    FUNDS_CENTER,                -- Funds Center [FISTL]
    WBS_ELEMENT,                 -- WBS Internal ID [FAA_MD_WBSELEMENT]
    TAX_JURISDICTION,            -- Tax Jur. [TXJCD]
    REAL_ESTATE_KEY,             -- Real Estate Key [IMKEY]
    SEGMENT,                     -- Segment [FB_SEGMENT]
    PROFIT_CENTER,               -- Profit Center [PRCTR]
    BUDGET_PERIOD,               -- Budget Period [FM_BUDGET_PERIOD]
    RESPONSIBLE_COST_CENTER,     -- Resp. Cost Ctr [KOSTLV]
    ROOM,                        -- Room [RAUMNR]
    PLANT,                       -- Plant [WERKS_D]
    LOCATION,                    -- Location [STORT]
    CAR_LICENSE_PLATE,           -- License Plate Number [AM_KFZKZ]
    PERSONNEL_NUMBER,            -- Personnel No. [PERNR_D]
    BUSINESS_PLACE,              -- Business place [BUPLA]
    DUMMY_FAA_MD_TDD_EEW_PS,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO, ROW_INDEX)
);

Learn More