FAAT_DCTR_YRAMT

Transparent Table Temporary Data
66 Fields 1 CDS Views

Depreciation Trace : Year Amount

FAAT_DCTR_YRAMT is an SAP database table in S/4HANA. Depreciation Trace : Year Amount. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DeprTraceYearAmount view from CONSUMPTION

Fields (66)

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 depr_area AFABER Deprec. Area
KEY fisc_year FAA_EE_FYEAR Fiscal Year
KEY curr_type FAA_EE_CURR_TYPE Currency Type
currency FAA_EE_CURRENCY Currency
cum_apc FAA_DC_TRACE_CUM_APC Total APC PY
cum_revl FAA_DC_TRACE_CUM_REVL Tot.RevRepValPY
cum_invs FAA_DC_TRACE_CUM_INVS Tot.Inv.GrantPY
cum_depr_o FAA_DC_TRACE_CUM_DEPR_O Tot. ODep. PY
cum_depr_s FAA_DC_TRACE_CUM_DEPR_S Tot.Spec.Dep.PY
cum_depr_u FAA_DC_TRACE_CUM_DEPR_U Tot.Unpl.Dep.PY
cum_resv FAA_DC_TRACE_CUM_RESV Tot.Reserves PY
cum_intr FAA_DC_TRACE_CUM_INTR Total Int. PY
cum_revl_d FAA_DC_TRACE_CUM_REVL_D TotReval.ODepPY
cum_downp FAA_DC_TRACE_CUM_DOWNP Tot.DownPmts PY
cur_apc FAA_DC_TRACE_CUR_APC Current Yr APC
cur_revl FAA_DC_TRACE_CUR_REVL CY Rev.Rep.Val.
cur_invs FAA_DC_TRACE_CUR_INVS CurrYrInv.Grant
cur_depr_o FAA_DC_TRACE_CUR_DEPR_O Curr.Yr ODep.
cur_depr_s FAA_DC_TRACE_CUR_DEPR_S Curr.Yr SDep.
cur_depr_u FAA_DC_TRACE_CUR_DEPR_U CurrYr UDep.
cur_resv FAA_DC_TRACE_CUR_RESV CurrYr Reserves
cur_intr FAA_DC_TRACE_CUR_INTR Interest CY
cur_revl_d FAA_DC_TRACE_CUR_REVL_D CY Reval. ODep.
cur_downp FAA_DC_TRACE_CUR_DOWNP CurrYr Down Pmt
prev_prev_apc FAA_DC_TRACE_PREV_PREV_APC APC - PYA
prev_prev_revl FAA_DC_TRACE_PREV_PREV_REVL Pr.RevRepVal.PY
prev_prev_invs FAA_DC_TRACE_PREV_PREV_INVS Inv.Grant PY
prev_prev_depr_o FAA_DC_TRACE_PREV_PREV_DEPR_O Pr.ODep. PY
prev_prev_depr_s FAA_DC_TRACE_PREV_PREV_DEPR_S Pr.SDep. PY
prev_prev_depr_u FAA_DC_TRACE_PREV_PREV_DEPR_U Pr.UDep. PY
prev_prev_resv FAA_DC_TRACE_PREV_PREV_RESV Pr.Reserves PY
prev_prev_intr FAA_DC_TRACE_PREV_PREV_INTR Prop.Int. PY
prev_prev_revl_d FAA_DC_TRACE_PREV_PREV_REVL_D Pr.Rev.ODep. PY
prev_prev_downp FAA_DC_TRACE_PREV_PREV_DOWNP Down Pmt PY
prev_cur_revl FAA_DC_TRACE_PREV_CUR_REVL Prop.Rep.Val.CY
prev_cur_depr_o FAA_DC_TRACE_PREV_CUR_DEPR_O Prop.ODep. CY
prev_cur_depr_s FAA_DC_TRACE_PREV_CUR_DEPR_S Prop.SDep. CY
prev_cur_depr_u FAA_DC_TRACE_PREV_CUR_DEPR_U Prop.UDep. CY
prev_cur_intr FAA_DC_TRACE_PREV_CUR_INTR Prop. Int. CY
prev_cur_revl_d FAA_DC_TRACE_PREV_CUR_REVL_D Pr.RevalODep.CY
total_apc FAA_DC_TRACE_TOTAL_APC Total APC
total_revl FAA_DC_TRACE_TOTAL_REVL Total Rev.RV
total_invs FAA_DC_TRACE_TOTAL_INVS Total Inv.Grant
total_depr_o FAA_DC_TRACE_TOTAL_DEPR_O Total ODep.
total_depr_s FAA_DC_TRACE_TOTAL_DEPR_S Total SDep.
total_depr_u FAA_DC_TRACE_TOTAL_DEPR_U Total UDep.
total_resv FAA_DC_TRACE_TOTAL_RESV Total Trns.Res.
total_intr FAA_DC_TRACE_TOTAL_INTR Total Interest
total_revl_d FAA_DC_TRACE_TOTAL_REVL_D Total Rev.ODep.
total_downp FAA_DC_TRACE_TOTAL_DOWNP Total Down Pmt
prev_apc FAA_DC_TRACE_PREV_APC APC PY
prev_revl FAA_DC_TRACE_PREV_REVL Rev.Rep.Val. PY
prev_invs FAA_DC_TRACE_PREV_INVS Inv.Grant PY
prev_depr_o FAA_DC_TRACE_PREV_DEPR_O Plan ODep PY
prev_depr_s FAA_DC_TRACE_PREV_DEPR_S Plan SDep PY
prev_depr_u FAA_DC_TRACE_PREV_DEPR_U Plan UDep PY
prev_resv FAA_DC_TRACE_PREV_RESV Reserves PY
prev_intr FAA_DC_TRACE_PREV_INTR Interest PY
prev_revl_d FAA_DC_TRACE_PREV_REVL_D Reval.ODep. PY
prev_downp FAA_DC_TRACE_PREV_DOWNP Down Pmt PY
shortened_depr_o FAA_DC_TRACE_SHORTENED_DEPR_O ODep. Reduction
shortened_depr_s FAA_DC_TRACE_SHORTENED_DEPR_S SDep. Reduction

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.

-- Depreciation Trace : Year Amount
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_DCTR_YRAMT (
    CLIENT,            -- Client [MANDT]
    COMP_CODE,         -- Company Code [BUKRS]
    ASSET_NO,          -- Asset [ANLN1]
    ASSET_SUBNO,       -- Sub-number [ANLN2]
    DEPR_AREA,         -- Deprec. Area [AFABER]
    FISC_YEAR,         -- Fiscal Year [FAA_EE_FYEAR]
    CURR_TYPE,         -- Currency Type [FAA_EE_CURR_TYPE]
    CURRENCY,          -- Currency [FAA_EE_CURRENCY]
    CUM_APC,           -- Total APC PY [FAA_DC_TRACE_CUM_APC]
    CUM_REVL,          -- Tot.RevRepValPY [FAA_DC_TRACE_CUM_REVL]
    CUM_INVS,          -- Tot.Inv.GrantPY [FAA_DC_TRACE_CUM_INVS]
    CUM_DEPR_O,        -- Tot. ODep. PY [FAA_DC_TRACE_CUM_DEPR_O]
    CUM_DEPR_S,        -- Tot.Spec.Dep.PY [FAA_DC_TRACE_CUM_DEPR_S]
    CUM_DEPR_U,        -- Tot.Unpl.Dep.PY [FAA_DC_TRACE_CUM_DEPR_U]
    CUM_RESV,          -- Tot.Reserves PY [FAA_DC_TRACE_CUM_RESV]
    CUM_INTR,          -- Total Int. PY [FAA_DC_TRACE_CUM_INTR]
    CUM_REVL_D,        -- TotReval.ODepPY [FAA_DC_TRACE_CUM_REVL_D]
    CUM_DOWNP,         -- Tot.DownPmts PY [FAA_DC_TRACE_CUM_DOWNP]
    CUR_APC,           -- Current Yr APC [FAA_DC_TRACE_CUR_APC]
    CUR_REVL,          -- CY Rev.Rep.Val. [FAA_DC_TRACE_CUR_REVL]
    CUR_INVS,          -- CurrYrInv.Grant [FAA_DC_TRACE_CUR_INVS]
    CUR_DEPR_O,        -- Curr.Yr ODep. [FAA_DC_TRACE_CUR_DEPR_O]
    CUR_DEPR_S,        -- Curr.Yr SDep. [FAA_DC_TRACE_CUR_DEPR_S]
    CUR_DEPR_U,        -- CurrYr UDep. [FAA_DC_TRACE_CUR_DEPR_U]
    CUR_RESV,          -- CurrYr Reserves [FAA_DC_TRACE_CUR_RESV]
    CUR_INTR,          -- Interest CY [FAA_DC_TRACE_CUR_INTR]
    CUR_REVL_D,        -- CY Reval. ODep. [FAA_DC_TRACE_CUR_REVL_D]
    CUR_DOWNP,         -- CurrYr Down Pmt [FAA_DC_TRACE_CUR_DOWNP]
    PREV_PREV_APC,     -- APC - PYA [FAA_DC_TRACE_PREV_PREV_APC]
    PREV_PREV_REVL,    -- Pr.RevRepVal.PY [FAA_DC_TRACE_PREV_PREV_REVL]
    PREV_PREV_INVS,    -- Inv.Grant PY [FAA_DC_TRACE_PREV_PREV_INVS]
    PREV_PREV_DEPR_O,  -- Pr.ODep. PY [FAA_DC_TRACE_PREV_PREV_DEPR_O]
    PREV_PREV_DEPR_S,  -- Pr.SDep. PY [FAA_DC_TRACE_PREV_PREV_DEPR_S]
    PREV_PREV_DEPR_U,  -- Pr.UDep. PY [FAA_DC_TRACE_PREV_PREV_DEPR_U]
    PREV_PREV_RESV,    -- Pr.Reserves PY [FAA_DC_TRACE_PREV_PREV_RESV]
    PREV_PREV_INTR,    -- Prop.Int. PY [FAA_DC_TRACE_PREV_PREV_INTR]
    PREV_PREV_REVL_D,  -- Pr.Rev.ODep. PY [FAA_DC_TRACE_PREV_PREV_REVL_D]
    PREV_PREV_DOWNP,   -- Down Pmt PY [FAA_DC_TRACE_PREV_PREV_DOWNP]
    PREV_CUR_REVL,     -- Prop.Rep.Val.CY [FAA_DC_TRACE_PREV_CUR_REVL]
    PREV_CUR_DEPR_O,   -- Prop.ODep. CY [FAA_DC_TRACE_PREV_CUR_DEPR_O]
    PREV_CUR_DEPR_S,   -- Prop.SDep. CY [FAA_DC_TRACE_PREV_CUR_DEPR_S]
    PREV_CUR_DEPR_U,   -- Prop.UDep. CY [FAA_DC_TRACE_PREV_CUR_DEPR_U]
    PREV_CUR_INTR,     -- Prop. Int. CY [FAA_DC_TRACE_PREV_CUR_INTR]
    PREV_CUR_REVL_D,   -- Pr.RevalODep.CY [FAA_DC_TRACE_PREV_CUR_REVL_D]
    TOTAL_APC,         -- Total APC [FAA_DC_TRACE_TOTAL_APC]
    TOTAL_REVL,        -- Total Rev.RV [FAA_DC_TRACE_TOTAL_REVL]
    TOTAL_INVS,        -- Total Inv.Grant [FAA_DC_TRACE_TOTAL_INVS]
    TOTAL_DEPR_O,      -- Total ODep. [FAA_DC_TRACE_TOTAL_DEPR_O]
    TOTAL_DEPR_S,      -- Total SDep. [FAA_DC_TRACE_TOTAL_DEPR_S]
    TOTAL_DEPR_U,      -- Total UDep. [FAA_DC_TRACE_TOTAL_DEPR_U]
    TOTAL_RESV,        -- Total Trns.Res. [FAA_DC_TRACE_TOTAL_RESV]
    TOTAL_INTR,        -- Total Interest [FAA_DC_TRACE_TOTAL_INTR]
    TOTAL_REVL_D,      -- Total Rev.ODep. [FAA_DC_TRACE_TOTAL_REVL_D]
    TOTAL_DOWNP,       -- Total Down Pmt [FAA_DC_TRACE_TOTAL_DOWNP]
    PREV_APC,          -- APC PY [FAA_DC_TRACE_PREV_APC]
    PREV_REVL,         -- Rev.Rep.Val. PY [FAA_DC_TRACE_PREV_REVL]
    PREV_INVS,         -- Inv.Grant PY [FAA_DC_TRACE_PREV_INVS]
    PREV_DEPR_O,       -- Plan ODep PY [FAA_DC_TRACE_PREV_DEPR_O]
    PREV_DEPR_S,       -- Plan SDep PY [FAA_DC_TRACE_PREV_DEPR_S]
    PREV_DEPR_U,       -- Plan UDep PY [FAA_DC_TRACE_PREV_DEPR_U]
    PREV_RESV,         -- Reserves PY [FAA_DC_TRACE_PREV_RESV]
    PREV_INTR,         -- Interest PY [FAA_DC_TRACE_PREV_INTR]
    PREV_REVL_D,       -- Reval.ODep. PY [FAA_DC_TRACE_PREV_REVL_D]
    PREV_DOWNP,        -- Down Pmt PY [FAA_DC_TRACE_PREV_DOWNP]
    SHORTENED_DEPR_O,  -- ODep. Reduction [FAA_DC_TRACE_SHORTENED_DEPR_O]
    SHORTENED_DEPR_S,  -- SDep. Reduction [FAA_DC_TRACE_SHORTENED_DEPR_S]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO, DEPR_AREA, FISC_YEAR, CURR_TYPE)
);

Learn More