FAAT_CMP

Transparent Table Application Table
6 Fields 4 CDS Views

Fixed Asset Company Code

FAAT_CMP is an SAP database table in S/4HANA. Fixed Asset Company Code. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FAA_CFG_CMP view from Configuration of CompCodes in Asset Accounting
FAA_CMP_LDT view from Join of FAAT_CMP and FAAT_CMP_LDT
I_FixedAssetCompanyCode view_entity from BASIC Fixed Asset Company Code
P_AssetCompanyCode view union_all BASIC

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp_code BUKRS Company Code
status FAA_COMP_CODE_STATUS Company Code Status
locked FAA_XLOCKED Comp. Code Locked
sdm_status FAA_SDM_STATUS SDM Status
upa_migration_year FAA_UPA_MIG_YEAR UPA Migration Year

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 Company Code
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_CMP (
    MANDT,               -- Client [MANDT]
    COMP_CODE,           -- Company Code [BUKRS]
    STATUS,              -- Company Code Status [FAA_COMP_CODE_STATUS]
    LOCKED,              -- Comp. Code Locked [FAA_XLOCKED]
    SDM_STATUS,          -- SDM Status [FAA_SDM_STATUS]
    UPA_MIGRATION_YEAR,  -- UPA Migration Year [FAA_UPA_MIG_YEAR]
    PRIMARY KEY (MANDT, COMP_CODE)
);

Learn More