FAAT_DCTR_SEGAMT

Transparent Table Temporary Data
192 Fields 1 CDS Views

Depreciation Trace : Segment Amount, Period&Calculation Para

FAAT_DCTR_SEGAMT is an SAP database table in S/4HANA. Depreciation Trace : Segment Amount, Period&Calculation Para. It contains 192 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DeprTraceSegmentAmount view from CONSUMPTION

Fields (192)

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 amount_type FAA_EE_AMOUNT_TYPE Value Type
KEY curr_type FAA_EE_CURR_TYPE Currency Type
KEY period_to FINS_FISCALPERIOD Fiscal Period
currency FAA_EE_CURRENCY Currency
basevalue FAA_DC_TRACE_CD_BASEVALUE Base Value
baseval_prev FAA_DC_TRACE_CD_BASEVAL_PREV BaseVal-PYA
perfactor FAA_DC_TRACE_CD__PERFACTOR Period Factor
perfactor_raw FAA_EE_PERFACTOR Period Factor
percent FAA_DC_TRACE_CD_PERCENT Percentage
percent_raw FAA_EE_PERCENT Percent
amount FAA_DC_TRACE_CD_AMOUNT Calculated Amt
amount_prev FAA_DC_TRACE_CD_AMOUNT_PREV Calc. Amt PY
amount_skipped FAA_EE_AMOUNT_SKIPPED Amount Skipped
minvalue FAA_DC_TRACE_CD_MINVALUE Cutoff Value
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_apc FAA_DC_TRACE_PREV_CUR_APC APC - CY Acq.
prev_cur_revl FAA_DC_TRACE_PREV_CUR_REVL Prop.Rep.Val.CY
prev_cur_invs FAA_DC_TRACE_PREV_CUR_INVS Inv.Grant- CYA
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_resv FAA_DC_TRACE_PREV_CUR_RESV Prop.Reserve 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
prev_cur_downp FAA_DC_TRACE_PREV_CUR_DOWNP Down Pmt CY
base_add FAA_DC_TRACE_CD_BASE_ADD Add.Base Value
base_add_prev FAA_DC_TRACE_CD_BASE_ADD_PREV AdBsValPYA
minval_prev FAA_DC_TRACE_CD_MINVAL_PREV CutoffVal.PYA
minval_perc_used FAA_EE_MINVAL_PERC_USED CutoffValPerc.
netvalue FAA_DC_TRACE_CD_NETVALUE Net Book Value
netval_prev FAA_DC_TRACE_CD_NETVAL_PREV NBV - PYA
sum_apc FAA_DC_TRACE_CD_SUM_APC Total APC
sum_apc_prev FAA_DC_TRACE_CD_SUM_APC_PREV Total APC - PYA
am_add FAA_DC_TRACE_CD_AM_ADD Add. Amt
am_add_prev FAA_DC_TRACE_CD_AM_ADD_PREV Add. Amt PYA
sign FAA_EE_SIGN +/- Sign
perseg_reduced FAA_EE_PERSEG_REDUCED Reduced Period
amount_reduced FAA_EE_AMOUNT_REDUCED Amount Reduced
useful_life FAA_EE_USEFUL_LIFE Useful Life
exp_life FAA_EE_EXP_LIFE Exp.Useful Life
exp_life_new FAA_EE_EXP_LIFE_NEW Exp.Life/Chngvr
exp_life_seg FAA_EE_EXP_LIFE_SEG Exp.Life/Seg.
peryear_weighted FAA_EE_PERYEAR_WEIGHTED Weighted Prds
peryear FAA_EE_PERYEAR Periods in FY
short_yr_prds FAA_EE_SHORT_YR_PRDS Short.FY Prds
perseg_weighted FAA_EE_PERSEG_WEIGHTED Wghtd Prd Seg.
ignore_short_yr FAA_EE_IGNORE_SHORT_YR Ignore Short.Yr
changeover_yr FAA_EE_CHANGEOVER_YR Changeover Year
changeover_prd UMPER Changeover Prd
use_halfperiods FAA_EE_USE_HALFPERIODS Half Periods
baseval_key FAA_EE_BASEVAL_KEY Base Value
base_add_key FAA_EE_BASE_ADD_KEY Add.Base Value
baseval_max FAA_DC_TR_P_BASEVAL_MAX Max.Base Val.
baseval_factor FAA_DC_TR_P_BASEVAL_FACTOR Base.Val.Red.
baseval_fact_add FAA_DC_TR_P_BASEVAL_FACTOR_ADD Base.Val.Red.
baseval_stated FAA_DC_TR_P_BASEVAL_STATED Ext.Base Val.
percent_key FAA_EE_PERCENT_KEY Calc. Method
percent_stated FAA_DC_TR_P_PERCENT_STATED Ext. Percentage
percent_factor FAA_DC_TR_P_PERCENT_FACTOR Perc.Fact.
percent_max FAA_DC_TR_P_PERCENT_MAX Max. Percentage
percent_min FAA_DC_TR_P_PERCENT_MIN Min.Perc.
percent_round FAA_EE_PERCENT_ROUND No. of Places
amount_factor FAA_DC_TR_P_AMOUNT_FACTOR MSF/Shutdown
amount_max FAA_DC_TR_P_AMOUNT_MAX Max.Amount
use_year_amount FAA_EE_USE_YEAR_AMOUNT Cumulate Values
skip_amount FAA_EE_SKIP_AMOUNT Skip Amount
check_amount FAA_EE_CHECK_AMOUNT Correct Amount
minval_percent FAA_DC_TR_P_MINVAL_PERCENT CutoffPerc
minval_stated FAA_DC_TR_P_MINVAL_STATED Scrap Value
minval_memo FAA_DC_TR_P_MINVAL_MEMO Memo Value
minval_rndmethod FAA_EE_MINVAL_RNDMETHOD Rounding Method
minval_rnddecim FAA_EE_MINVAL_RNDDECIM No. of Places
minval_rndplace FAA_EE_MINVAL_RNDPLACE Int.Dec.Pl.
subtract_minval FAA_EE_SUBTRACT_MINVAL Scrap Val. Ded.
no_minval FAA_EE_NO_MINVAL Below Zero
minval_tolerance FAA_DC_TR_P_MINVAL_TOLERANCE NBV Tolerance
minval_key FAA_EE_MINVAL_KEY Cutoff Value
minval_perc_add FAA_EE_MINVAL_PERC_ADD AddScrapPerc.
minval_stated_add FAA_EE_MINVAL_STATED_ADD Add.Scrap Value
rounding_off FAA_EE_ROUNDING_OFF Do Not Round
leas_paymt_cycle FAA_EE_LEAS_PAYMT_CYCLE Payment Cycle
leas_no_payments FAA_EE_LEAS_NO_PAYMENTS No. Payments
leas_intrst_rate FAA_EE_LEAS_INTRST_RATE Leasing Int.Rate
leas_per_payment FAA_EE_LEAS_PER_PAYMENT Payment Amount
leas_adv_payment FAA_EE_LEAS_ADV_PAYMENT Advance Payment
use_days XDAILY Dep. to the Day
fyear_dt FAA_EE_FYEAR Fiscal Year
area_dt FAA_EE_AREA Deprec. Area
curr_type_dt FAA_EE_CURR_TYPE Currency Type
amount_type_dt FAA_EE_AMOUNT_TYPE Value Type
period_to_dt FAA_DC_PERIOD_TO To Period
period_from_dt FAA_DC_PERIOD_FROM From Period
periods_dt FAA_DC_PERIODS Periods
periods_short_fy_dt FAA_DC_PERIODS_SHORT_YR Short.FY Prds
depr_key_dt AFASL Dep. key
phase_dt APHASE Phase
start_date_dt FAA_DC_START_DATE Start Date
start_prd_dt FAA_DC_START_PRD Start Period
start_yr_dt FAA_DC_START_YR Start Year
leas_paymt_cycle_dt LRYTH Cycle
leas_no_payments_dt LEANZ No.leas.paymnts
leas_intrst_rate_dt LZINS Annl Int. Rate
leas_per_payment_dt LEGEB Lease payment
leas_adv_payment_dt LVORS Advance pay.
useful_life_dt FAA_DC_USEFUL_LIFE Useful Life
useful_life_prds_dt NDPER Periods
useful_life_yrs_dt NDJAR Useful Life
exp_life_dt FAA_DC_EXPIRED_LIFE Exp.Useful Life
exp_life_seg_dt FAA_DC_EXPIRED_LIFE_SEG Exp.Useful Life
exp_life_new_dt FAA_DC_EXPIRED_LIFE_NEW Exp.Useful Life
age_index_dt ALIND Aging Index
rplcmntval_index_dt WBIND Index series
revaltn_key_dt J_1AARVKEY Revaluation Key
invsupport_key_dt INVSL Invest.Support
scrapvalue_dt SCHRW Scrap value
scrapvalue_prctg_dt SCHRW_PROZ Scrap Value %
neg_values_dt XNEGA Negative Val.Allowed
changeover_yr_dt UMJAR Changeover year
changeover_prd_dt UMPER Changeover Prd
changeover_ind_dt FAA_DC_CHANGEOVER_IND Indicator
var_dep_portion_dt APROP Var.dep.portion
shift_fact_dt BF_MSFAK Shift Factor
is_shutdown_dt BF_XSTIL Shutdown
assetclass_dt BF_ANLKL Asset class
cap_date_dt BF_AKTIVD Activated On
initial_acq_dt BF_ZUGDAT First Acq. On
initial_acq_yr_dt BF_ZUJAHR Acquisition Yr
initial_acq_prd_dt BF_ZUPER First Acq. Per.
orig_acq_date_dt BF_AIBDT Acq.Orig.Ast.On
last_ret_date_dt ABGDAT_B Last retmt. on
deact_date_dt DEAKT Deact.Date
usage_impact_ind_dt FAA_DC_USAGE_IMPACT_IND Influence Ind.
sort_indicator_dt FAA_DC_SORT_INDICATOR Sort Indicator
multi_level_indx_dt FAA_DC_MULTI_LEVEL_INDX Step Index
cutof_value_indx_dt FAA_DC_CUTOF_VALUE_INDX CutoffVal.Index
ignore_memval_dt XERWRT Do not take memo value into account
has_tddp_dt HAS_TDDP Time-Dependent
to_date_of_tddp_dt BDATU Valid To
grp_asset_assgnd_dt FAA_DC_GRP_ASSET_ASSGND GrpAsset Assgn.
use_usage_data_dt FAA_DC_USE_USAGE_DATA Consider Usage
range_length_dt FAA_DC_RANGE_LENGTH Interval Length
calc_inflation_dt FAA_DC_CALC_INFLATION Inflation
calc_perform_dt FAA_DC_CALC_PERFORM Calculate
recalc_perform_dt FAA_DC_RECALC_PERFORM Obsolete
calc_end_reached_dt FAA_DC_CALC_END_REACHED Obsolete
use_alignment_dt FAA_DC_USE_ALIGNMENT Align Segments
use_max_periods_dt FAA_DC_USE_MAX_PERIODS Per Period
use_days_dt XDAILY Dep. to the Day
first_day_in_yr_dt FAA_DC_FIRST_DAY_IN_YR First Day
last_day_in_yr_dt FAA_DC_LAST_DAY_IN_YR Last Day
is_shortfiscyear_dt XRUMPF Shortened FYear
is_behind_ul_dt FAA_DC_IS_BEHIND_UL After UL
amount_factor_dt FAA_EE_AMOUNT_FACTOR MSF/Shutdown
use_exp_life_new_dt FAA_DC_USE_EXP_LIFE_NEW From ChngYr
currency_dt WAERS Currency
baseval_key_dt FAA_EE_BASEVAL_KEY Base Value
base_add_key_dt FAA_EE_BASE_ADD_KEY Add.Base Value
percent_key_dt FAA_EE_PERCENT_KEY Calc. Method
percent_stated_dt FAA_EE_PERCENT_STATED Ext. Percentage
usage_object_dt FAA_UO Usage Object
msgty SYMSGTY Message Type
msgid SYMSGID Message Class
msgno SYMSGNO Message Number
msgv1 SYMSGV Message Variable
msgv2 SYMSGV Message Variable
msgv3 SYMSGV Message Variable
msgv4 SYMSGV Message Variable

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 : Segment Amount, Period&Calculation Para
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_DCTR_SEGAMT (
    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]
    AMOUNT_TYPE,          -- Value Type [FAA_EE_AMOUNT_TYPE]
    CURR_TYPE,            -- Currency Type [FAA_EE_CURR_TYPE]
    PERIOD_TO,            -- Fiscal Period [FINS_FISCALPERIOD]
    CURRENCY,             -- Currency [FAA_EE_CURRENCY]
    BASEVALUE,            -- Base Value [FAA_DC_TRACE_CD_BASEVALUE]
    BASEVAL_PREV,         -- BaseVal-PYA [FAA_DC_TRACE_CD_BASEVAL_PREV]
    PERFACTOR,            -- Period Factor [FAA_DC_TRACE_CD__PERFACTOR]
    PERFACTOR_RAW,        -- Period Factor [FAA_EE_PERFACTOR]
    PERCENT,              -- Percentage [FAA_DC_TRACE_CD_PERCENT]
    PERCENT_RAW,          -- Percent [FAA_EE_PERCENT]
    AMOUNT,               -- Calculated Amt [FAA_DC_TRACE_CD_AMOUNT]
    AMOUNT_PREV,          -- Calc. Amt PY [FAA_DC_TRACE_CD_AMOUNT_PREV]
    AMOUNT_SKIPPED,       -- Amount Skipped [FAA_EE_AMOUNT_SKIPPED]
    MINVALUE,             -- Cutoff Value [FAA_DC_TRACE_CD_MINVALUE]
    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_APC,         -- APC - CY Acq. [FAA_DC_TRACE_PREV_CUR_APC]
    PREV_CUR_REVL,        -- Prop.Rep.Val.CY [FAA_DC_TRACE_PREV_CUR_REVL]
    PREV_CUR_INVS,        -- Inv.Grant- CYA [FAA_DC_TRACE_PREV_CUR_INVS]
    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_RESV,        -- Prop.Reserve CY [FAA_DC_TRACE_PREV_CUR_RESV]
    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]
    PREV_CUR_DOWNP,       -- Down Pmt CY [FAA_DC_TRACE_PREV_CUR_DOWNP]
    BASE_ADD,             -- Add.Base Value [FAA_DC_TRACE_CD_BASE_ADD]
    BASE_ADD_PREV,        -- AdBsValPYA [FAA_DC_TRACE_CD_BASE_ADD_PREV]
    MINVAL_PREV,          -- CutoffVal.PYA [FAA_DC_TRACE_CD_MINVAL_PREV]
    MINVAL_PERC_USED,     -- CutoffValPerc. [FAA_EE_MINVAL_PERC_USED]
    NETVALUE,             -- Net Book Value [FAA_DC_TRACE_CD_NETVALUE]
    NETVAL_PREV,          -- NBV - PYA [FAA_DC_TRACE_CD_NETVAL_PREV]
    SUM_APC,              -- Total APC [FAA_DC_TRACE_CD_SUM_APC]
    SUM_APC_PREV,         -- Total APC - PYA [FAA_DC_TRACE_CD_SUM_APC_PREV]
    AM_ADD,               -- Add. Amt [FAA_DC_TRACE_CD_AM_ADD]
    AM_ADD_PREV,          -- Add. Amt PYA [FAA_DC_TRACE_CD_AM_ADD_PREV]
    SIGN,                 -- +/- Sign [FAA_EE_SIGN]
    PERSEG_REDUCED,       -- Reduced Period [FAA_EE_PERSEG_REDUCED]
    AMOUNT_REDUCED,       -- Amount Reduced [FAA_EE_AMOUNT_REDUCED]
    USEFUL_LIFE,          -- Useful Life [FAA_EE_USEFUL_LIFE]
    EXP_LIFE,             -- Exp.Useful Life [FAA_EE_EXP_LIFE]
    EXP_LIFE_NEW,         -- Exp.Life/Chngvr [FAA_EE_EXP_LIFE_NEW]
    EXP_LIFE_SEG,         -- Exp.Life/Seg. [FAA_EE_EXP_LIFE_SEG]
    PERYEAR_WEIGHTED,     -- Weighted Prds [FAA_EE_PERYEAR_WEIGHTED]
    PERYEAR,              -- Periods in FY [FAA_EE_PERYEAR]
    SHORT_YR_PRDS,        -- Short.FY Prds [FAA_EE_SHORT_YR_PRDS]
    PERSEG_WEIGHTED,      -- Wghtd Prd Seg. [FAA_EE_PERSEG_WEIGHTED]
    IGNORE_SHORT_YR,      -- Ignore Short.Yr [FAA_EE_IGNORE_SHORT_YR]
    CHANGEOVER_YR,        -- Changeover Year [FAA_EE_CHANGEOVER_YR]
    CHANGEOVER_PRD,       -- Changeover Prd [UMPER]
    USE_HALFPERIODS,      -- Half Periods [FAA_EE_USE_HALFPERIODS]
    BASEVAL_KEY,          -- Base Value [FAA_EE_BASEVAL_KEY]
    BASE_ADD_KEY,         -- Add.Base Value [FAA_EE_BASE_ADD_KEY]
    BASEVAL_MAX,          -- Max.Base Val. [FAA_DC_TR_P_BASEVAL_MAX]
    BASEVAL_FACTOR,       -- Base.Val.Red. [FAA_DC_TR_P_BASEVAL_FACTOR]
    BASEVAL_FACT_ADD,     -- Base.Val.Red. [FAA_DC_TR_P_BASEVAL_FACTOR_ADD]
    BASEVAL_STATED,       -- Ext.Base Val. [FAA_DC_TR_P_BASEVAL_STATED]
    PERCENT_KEY,          -- Calc. Method [FAA_EE_PERCENT_KEY]
    PERCENT_STATED,       -- Ext. Percentage [FAA_DC_TR_P_PERCENT_STATED]
    PERCENT_FACTOR,       -- Perc.Fact. [FAA_DC_TR_P_PERCENT_FACTOR]
    PERCENT_MAX,          -- Max. Percentage [FAA_DC_TR_P_PERCENT_MAX]
    PERCENT_MIN,          -- Min.Perc. [FAA_DC_TR_P_PERCENT_MIN]
    PERCENT_ROUND,        -- No. of Places [FAA_EE_PERCENT_ROUND]
    AMOUNT_FACTOR,        -- MSF/Shutdown [FAA_DC_TR_P_AMOUNT_FACTOR]
    AMOUNT_MAX,           -- Max.Amount [FAA_DC_TR_P_AMOUNT_MAX]
    USE_YEAR_AMOUNT,      -- Cumulate Values [FAA_EE_USE_YEAR_AMOUNT]
    SKIP_AMOUNT,          -- Skip Amount [FAA_EE_SKIP_AMOUNT]
    CHECK_AMOUNT,         -- Correct Amount [FAA_EE_CHECK_AMOUNT]
    MINVAL_PERCENT,       -- CutoffPerc [FAA_DC_TR_P_MINVAL_PERCENT]
    MINVAL_STATED,        -- Scrap Value [FAA_DC_TR_P_MINVAL_STATED]
    MINVAL_MEMO,          -- Memo Value [FAA_DC_TR_P_MINVAL_MEMO]
    MINVAL_RNDMETHOD,     -- Rounding Method [FAA_EE_MINVAL_RNDMETHOD]
    MINVAL_RNDDECIM,      -- No. of Places [FAA_EE_MINVAL_RNDDECIM]
    MINVAL_RNDPLACE,      -- Int.Dec.Pl. [FAA_EE_MINVAL_RNDPLACE]
    SUBTRACT_MINVAL,      -- Scrap Val. Ded. [FAA_EE_SUBTRACT_MINVAL]
    NO_MINVAL,            -- Below Zero [FAA_EE_NO_MINVAL]
    MINVAL_TOLERANCE,     -- NBV Tolerance [FAA_DC_TR_P_MINVAL_TOLERANCE]
    MINVAL_KEY,           -- Cutoff Value [FAA_EE_MINVAL_KEY]
    MINVAL_PERC_ADD,      -- AddScrapPerc. [FAA_EE_MINVAL_PERC_ADD]
    MINVAL_STATED_ADD,    -- Add.Scrap Value [FAA_EE_MINVAL_STATED_ADD]
    ROUNDING_OFF,         -- Do Not Round [FAA_EE_ROUNDING_OFF]
    LEAS_PAYMT_CYCLE,     -- Payment Cycle [FAA_EE_LEAS_PAYMT_CYCLE]
    LEAS_NO_PAYMENTS,     -- No. Payments [FAA_EE_LEAS_NO_PAYMENTS]
    LEAS_INTRST_RATE,     -- Leasing Int.Rate [FAA_EE_LEAS_INTRST_RATE]
    LEAS_PER_PAYMENT,     -- Payment Amount [FAA_EE_LEAS_PER_PAYMENT]
    LEAS_ADV_PAYMENT,     -- Advance Payment [FAA_EE_LEAS_ADV_PAYMENT]
    USE_DAYS,             -- Dep. to the Day [XDAILY]
    FYEAR_DT,             -- Fiscal Year [FAA_EE_FYEAR]
    AREA_DT,              -- Deprec. Area [FAA_EE_AREA]
    CURR_TYPE_DT,         -- Currency Type [FAA_EE_CURR_TYPE]
    AMOUNT_TYPE_DT,       -- Value Type [FAA_EE_AMOUNT_TYPE]
    PERIOD_TO_DT,         -- To Period [FAA_DC_PERIOD_TO]
    PERIOD_FROM_DT,       -- From Period [FAA_DC_PERIOD_FROM]
    PERIODS_DT,           -- Periods [FAA_DC_PERIODS]
    PERIODS_SHORT_FY_DT,  -- Short.FY Prds [FAA_DC_PERIODS_SHORT_YR]
    DEPR_KEY_DT,          -- Dep. key [AFASL]
    PHASE_DT,             -- Phase [APHASE]
    START_DATE_DT,        -- Start Date [FAA_DC_START_DATE]
    START_PRD_DT,         -- Start Period [FAA_DC_START_PRD]
    START_YR_DT,          -- Start Year [FAA_DC_START_YR]
    LEAS_PAYMT_CYCLE_DT,  -- Cycle [LRYTH]
    LEAS_NO_PAYMENTS_DT,  -- No.leas.paymnts [LEANZ]
    LEAS_INTRST_RATE_DT,  -- Annl Int. Rate [LZINS]
    LEAS_PER_PAYMENT_DT,  -- Lease payment [LEGEB]
    LEAS_ADV_PAYMENT_DT,  -- Advance pay. [LVORS]
    USEFUL_LIFE_DT,       -- Useful Life [FAA_DC_USEFUL_LIFE]
    USEFUL_LIFE_PRDS_DT,  -- Periods [NDPER]
    USEFUL_LIFE_YRS_DT,   -- Useful Life [NDJAR]
    EXP_LIFE_DT,          -- Exp.Useful Life [FAA_DC_EXPIRED_LIFE]
    EXP_LIFE_SEG_DT,      -- Exp.Useful Life [FAA_DC_EXPIRED_LIFE_SEG]
    EXP_LIFE_NEW_DT,      -- Exp.Useful Life [FAA_DC_EXPIRED_LIFE_NEW]
    AGE_INDEX_DT,         -- Aging Index [ALIND]
    RPLCMNTVAL_INDEX_DT,  -- Index series [WBIND]
    REVALTN_KEY_DT,       -- Revaluation Key [J_1AARVKEY]
    INVSUPPORT_KEY_DT,    -- Invest.Support [INVSL]
    SCRAPVALUE_DT,        -- Scrap value [SCHRW]
    SCRAPVALUE_PRCTG_DT,  -- Scrap Value % [SCHRW_PROZ]
    NEG_VALUES_DT,        -- Negative Val.Allowed [XNEGA]
    CHANGEOVER_YR_DT,     -- Changeover year [UMJAR]
    CHANGEOVER_PRD_DT,    -- Changeover Prd [UMPER]
    CHANGEOVER_IND_DT,    -- Indicator [FAA_DC_CHANGEOVER_IND]
    VAR_DEP_PORTION_DT,   -- Var.dep.portion [APROP]
    SHIFT_FACT_DT,        -- Shift Factor [BF_MSFAK]
    IS_SHUTDOWN_DT,       -- Shutdown [BF_XSTIL]
    ASSETCLASS_DT,        -- Asset class [BF_ANLKL]
    CAP_DATE_DT,          -- Activated On [BF_AKTIVD]
    INITIAL_ACQ_DT,       -- First Acq. On [BF_ZUGDAT]
    INITIAL_ACQ_YR_DT,    -- Acquisition Yr [BF_ZUJAHR]
    INITIAL_ACQ_PRD_DT,   -- First Acq. Per. [BF_ZUPER]
    ORIG_ACQ_DATE_DT,     -- Acq.Orig.Ast.On [BF_AIBDT]
    LAST_RET_DATE_DT,     -- Last retmt. on [ABGDAT_B]
    DEACT_DATE_DT,        -- Deact.Date [DEAKT]
    USAGE_IMPACT_IND_DT,  -- Influence Ind. [FAA_DC_USAGE_IMPACT_IND]
    SORT_INDICATOR_DT,    -- Sort Indicator [FAA_DC_SORT_INDICATOR]
    MULTI_LEVEL_INDX_DT,  -- Step Index [FAA_DC_MULTI_LEVEL_INDX]
    CUTOF_VALUE_INDX_DT,  -- CutoffVal.Index [FAA_DC_CUTOF_VALUE_INDX]
    IGNORE_MEMVAL_DT,     -- Do not take memo value into account [XERWRT]
    HAS_TDDP_DT,          -- Time-Dependent [HAS_TDDP]
    TO_DATE_OF_TDDP_DT,   -- Valid To [BDATU]
    GRP_ASSET_ASSGND_DT,  -- GrpAsset Assgn. [FAA_DC_GRP_ASSET_ASSGND]
    USE_USAGE_DATA_DT,    -- Consider Usage [FAA_DC_USE_USAGE_DATA]
    RANGE_LENGTH_DT,      -- Interval Length [FAA_DC_RANGE_LENGTH]
    CALC_INFLATION_DT,    -- Inflation [FAA_DC_CALC_INFLATION]
    CALC_PERFORM_DT,      -- Calculate [FAA_DC_CALC_PERFORM]
    RECALC_PERFORM_DT,    -- Obsolete [FAA_DC_RECALC_PERFORM]
    CALC_END_REACHED_DT,  -- Obsolete [FAA_DC_CALC_END_REACHED]
    USE_ALIGNMENT_DT,     -- Align Segments [FAA_DC_USE_ALIGNMENT]
    USE_MAX_PERIODS_DT,   -- Per Period [FAA_DC_USE_MAX_PERIODS]
    USE_DAYS_DT,          -- Dep. to the Day [XDAILY]
    FIRST_DAY_IN_YR_DT,   -- First Day [FAA_DC_FIRST_DAY_IN_YR]
    LAST_DAY_IN_YR_DT,    -- Last Day [FAA_DC_LAST_DAY_IN_YR]
    IS_SHORTFISCYEAR_DT,  -- Shortened FYear [XRUMPF]
    IS_BEHIND_UL_DT,      -- After UL [FAA_DC_IS_BEHIND_UL]
    AMOUNT_FACTOR_DT,     -- MSF/Shutdown [FAA_EE_AMOUNT_FACTOR]
    USE_EXP_LIFE_NEW_DT,  -- From ChngYr [FAA_DC_USE_EXP_LIFE_NEW]
    CURRENCY_DT,          -- Currency [WAERS]
    BASEVAL_KEY_DT,       -- Base Value [FAA_EE_BASEVAL_KEY]
    BASE_ADD_KEY_DT,      -- Add.Base Value [FAA_EE_BASE_ADD_KEY]
    PERCENT_KEY_DT,       -- Calc. Method [FAA_EE_PERCENT_KEY]
    PERCENT_STATED_DT,    -- Ext. Percentage [FAA_EE_PERCENT_STATED]
    USAGE_OBJECT_DT,      -- Usage Object [FAA_UO]
    MSGTY,                -- Message Type [SYMSGTY]
    MSGID,                -- Message Class [SYMSGID]
    MSGNO,                -- Message Number [SYMSGNO]
    MSGV1,                -- Message Variable [SYMSGV]
    MSGV2,                -- Message Variable [SYMSGV]
    MSGV3,                -- Message Variable [SYMSGV]
    MSGV4,                -- Message Variable [SYMSGV]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO, DEPR_AREA, FISC_YEAR, AMOUNT_TYPE, CURR_TYPE, PERIOD_TO)
);

Learn More