FAAT_MD_LD

Transparent Table Application Table
11 Fields 3 CDS Views

Fixed Asset Master: Ledger

FAAT_MD_LD is an SAP database table in S/4HANA. Fixed Asset Master: Ledger. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FAA_ASSETLDS4 view from Unit Test View for Asset Ledger
FAA_M_AANLA view union_all Selection view for matchcode ID AANL-A
P_FixedAssetForLedger view union_all BASIC

Fields (11)

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 ledger FINS_LEDGER Ledger
capitalization_date AKTIVD Capitalized On
deactivation_date DEAKT Deact.Date
acquisition_date DZUGDAT First Acq. on
acquisition_year DZUJAHR Acquisition Yr
acquisition_period DZUPER First Acq. Per.
last_reval_date AM_LRVDAT Last Reval.

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: Ledger
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_MD_LD (
    CLIENT,               -- Client [MANDT]
    COMP_CODE,            -- Company Code [BUKRS]
    ASSET_NO,             -- Asset [ANLN1]
    ASSET_SUBNO,          -- Sub-number [ANLN2]
    LEDGER,               -- Ledger [FINS_LEDGER]
    CAPITALIZATION_DATE,  -- Capitalized On [AKTIVD]
    DEACTIVATION_DATE,    -- Deact.Date [DEAKT]
    ACQUISITION_DATE,     -- First Acq. on [DZUGDAT]
    ACQUISITION_YEAR,     -- Acquisition Yr [DZUJAHR]
    ACQUISITION_PERIOD,   -- First Acq. Per. [DZUPER]
    LAST_REVAL_DATE,      -- Last Reval. [AM_LRVDAT]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO, LEDGER)
);

Learn More