FAAT_CMP_LEDGER

Transparent Table Application Table
5 Fields 4 CDS Views

FAA Company Code: Ledger Settings

FAAT_CMP_LEDGER is an SAP database table in S/4HANA. FAA Company Code: Ledger Settings. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FAA_CFG_CMP_LEDGER view from Configuration Data of CompCodes and Ledger
FAA_LEDGER view from Ledger with FAA persistency (including tech Ledger)
FAA_LEDGER view union_all Ledger with FAA persistency (including tech Ledger)
I_FixedAssetCompanyCodeLedger view_entity from BASIC Fixed Asset Company Code Ledger

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp_code BUKRS Company Code
KEY ledger FINS_LEDGER Ledger
current_fisc_year LGJAHR Highest F.Year
plan_horizon FAA_PLAN_HORIZON Planning Horizon

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.

-- FAA Company Code: Ledger Settings
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_CMP_LEDGER (
    MANDT,              -- Client [MANDT]
    COMP_CODE,          -- Company Code [BUKRS]
    LEDGER,             -- Ledger [FINS_LEDGER]
    CURRENT_FISC_YEAR,  -- Highest F.Year [LGJAHR]
    PLAN_HORIZON,       -- Planning Horizon [FAA_PLAN_HORIZON]
    PRIMARY KEY (MANDT, COMP_CODE, LEDGER)
);

Learn More