FAAC_CMP_DA0

Transparent Table Customizing Table
11 Fields 11 CDS Views

Assign Depr. Area to company code

FAAC_CMP_DA0 is an SAP database table in S/4HANA. Assign Depr. Area to company code. It contains 11 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
FAA_CFG_CMP_DA view from Configuration of Depreciation Areas after REDESIGN
FAA_CFG_CMP_DA view left_outer Configuration of Depreciation Areas after REDESIGN
FAA_CFG_DEPR_AREA view from Configuration of Depr.Area
FAA_CFG_DEPR_AREA view left_outer Configuration of Depr.Area
FAA_CFG_VIRTUAL_AREA view inner Semantics of Virtual Depreciation Area
FAA_SDM_BALANCE02 view inner Asset line items
FAA_UPA_MIG_DA_MATH_FMLA view_entity inner Mathematical formula
FAA_UPA_MIG_DI_BALANCE02 view_entity inner DOC_IT line items
P_DepreciationAreaForLedger view from BASIC
P_DepreciationAreaForLedger view union_all BASIC
P_ValuationViewByDeprArea view from BASIC

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY comp_code BUKRS Company Code
KEY ledger FINS_LEDGER Ledger
KEY depr_area FAA_DEPR_AREA Depr.Area
valview FAA_VALVIEW ValView
fisc_year_from FAA_FROM_FISC_YEAR Valid-From Year
fisc_year_to FAA_TO_FISC_YEAR Valid-To Year
depr_fisc_year_var PERIV FY Variant
round_value BASRND Rounding Basis
round_method METRND Rounding Method
update_quantity XMENGE_AFABE Update Quantity

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.

-- Assign Depr. Area to company code
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAC_CMP_DA0 (
    CLIENT,              -- Client [MANDT]
    COMP_CODE,           -- Company Code [BUKRS]
    LEDGER,              -- Ledger [FINS_LEDGER]
    DEPR_AREA,           -- Depr.Area [FAA_DEPR_AREA]
    VALVIEW,             -- ValView [FAA_VALVIEW]
    FISC_YEAR_FROM,      -- Valid-From Year [FAA_FROM_FISC_YEAR]
    FISC_YEAR_TO,        -- Valid-To Year [FAA_TO_FISC_YEAR]
    DEPR_FISC_YEAR_VAR,  -- FY Variant [PERIV]
    ROUND_VALUE,         -- Rounding Basis [BASRND]
    ROUND_METHOD,        -- Rounding Method [METRND]
    UPDATE_QUANTITY,     -- Update Quantity [XMENGE_AFABE]
    PRIMARY KEY (CLIENT, COMP_CODE, LEDGER, DEPR_AREA)
);

Learn More