FAAT_MD_ROOT

Transparent Table Application Table
13 Fields 7 CDS Views

Fixed Asset Master: Root Segment

FAAT_MD_ROOT is an SAP database table in S/4HANA. Fixed Asset Master: Root Segment. It contains 13 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
FAA_ASSETS4 view from Unit Test View for Asset
FAA_ES_ASSET_MD view from Fixed Asset Master Data for Enterprise Search
FAA_SDM_BALANCE01 view inner Asset balance cube 01
FAA_UPA_MIG_BALANCE01 view_entity inner Asset balance cube 01
FAA_UPA_MIG_DI_BALANCE01 view_entity inner DOC_IT balance layer 01
P_FixedAsset view union_all BASIC
P_MasterFixedAsset view union_all BASIC

Fields (13)

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
lifecycle_status FAA_MD_LC_STATUS Lifecycle Status
completeness_status FAA_MD_COMPL_STATUS Completeness Status
auc_status FAA_MD_AUC_STATUS AuC Status
is_main_asset FAA_MD_XMAIN Main Asset
is_historical_managed FAA_MD_XHISTLMGMT Manage Historically
is_blocked FAA_MD_XBLOCKED Asset Blocked
is_post_capitalization FAA_MD_XPOSTCAP Post-capital.
validity_date FAA_MD_VALIDITY_DATE Validity Date
archive_file_key ARKEY Archive File

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: Root Segment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_MD_ROOT (
    CLIENT,                  -- Client [MANDT]
    COMP_CODE,               -- Company Code [BUKRS]
    ASSET_NO,                -- Asset [ANLN1]
    ASSET_SUBNO,             -- Sub-number [ANLN2]
    LIFECYCLE_STATUS,        -- Lifecycle Status [FAA_MD_LC_STATUS]
    COMPLETENESS_STATUS,     -- Completeness Status [FAA_MD_COMPL_STATUS]
    AUC_STATUS,              -- AuC Status [FAA_MD_AUC_STATUS]
    IS_MAIN_ASSET,           -- Main Asset [FAA_MD_XMAIN]
    IS_HISTORICAL_MANAGED,   -- Manage Historically [FAA_MD_XHISTLMGMT]
    IS_BLOCKED,              -- Asset Blocked [FAA_MD_XBLOCKED]
    IS_POST_CAPITALIZATION,  -- Post-capital. [FAA_MD_XPOSTCAP]
    VALIDITY_DATE,           -- Validity Date [FAA_MD_VALIDITY_DATE]
    ARCHIVE_FILE_KEY,        -- Archive File [ARKEY]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO)
);

Learn More