FAAT_MD_VAL

Transparent Table Application Table
31 Fields 2 CDS Views

Fixed Asset Master: Valuation

FAAT_MD_VAL is an SAP database table in S/4HANA. Fixed Asset Master: Valuation. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAA_DUE_VALUES view inner Ausstehende Abschreibungen Vorjahre zu GJ-Beginn
I_AssetValuation view from BASIC Asset Valuation

Fields (31)

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 ledger FINS_LEDGER Ledger
KEY depr_area AFABER Deprec. Area
negative_values_allowed XNEGA Negative Val.Allowed
odepr_start_date AFABG Dep. Start Date
sdepr_start_date SAFBG Spec.dep.start
int_start_date DZINBG Int.Calc. Start
readiness_date INBDA Operating Readiness
changeover_year UMJAR Changeover year
changeover_period UMPER Changeover Prd
lva_amount_check_type XGWGK LVA Check
index_repl_values WBIND Index series
index_repl_age ALIND Aging Index
ignore_error_in_hsl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_ksl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_osl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_vsl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_bsl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_csl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_dsl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_esl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_fsl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
ignore_error_in_gsl FAA_MD_IGNORE_ERROR_IN_CUR Ignore Currency
last_retirement_date ABGDAT_B Last retmt. on
current_fiscal_year LGJAN Last Fiscal Yr.
number_of_periods PERFY Period Scaling
calculation_view_type FAA_MD_CALC_VIEW_TYPE Calc. View Type
sdm_status FAA_SDM_STATUS SDM Status

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 Master: Valuation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_MD_VAL (
    CLIENT,                   -- Client [MANDT]
    COMP_CODE,                -- Company Code [BUKRS]
    ASSET_NO,                 -- Asset [ANLN1]
    ASSET_SUBNO,              -- Sub-number [ANLN2]
    LEDGER,                   -- Ledger [FINS_LEDGER]
    DEPR_AREA,                -- Deprec. Area [AFABER]
    NEGATIVE_VALUES_ALLOWED,  -- Negative Val.Allowed [XNEGA]
    ODEPR_START_DATE,         -- Dep. Start Date [AFABG]
    SDEPR_START_DATE,         -- Spec.dep.start [SAFBG]
    INT_START_DATE,           -- Int.Calc. Start [DZINBG]
    READINESS_DATE,           -- Operating Readiness [INBDA]
    CHANGEOVER_YEAR,          -- Changeover year [UMJAR]
    CHANGEOVER_PERIOD,        -- Changeover Prd [UMPER]
    LVA_AMOUNT_CHECK_TYPE,    -- LVA Check [XGWGK]
    INDEX_REPL_VALUES,        -- Index series [WBIND]
    INDEX_REPL_AGE,           -- Aging Index [ALIND]
    IGNORE_ERROR_IN_HSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_KSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_OSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_VSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_BSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_CSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_DSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_ESL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_FSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    IGNORE_ERROR_IN_GSL,      -- Ignore Currency [FAA_MD_IGNORE_ERROR_IN_CUR]
    LAST_RETIREMENT_DATE,     -- Last retmt. on [ABGDAT_B]
    CURRENT_FISCAL_YEAR,      -- Last Fiscal Yr. [LGJAN]
    NUMBER_OF_PERIODS,        -- Period Scaling [PERFY]
    CALCULATION_VIEW_TYPE,    -- Calc. View Type [FAA_MD_CALC_VIEW_TYPE]
    SDM_STATUS,               -- SDM Status [FAA_SDM_STATUS]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO, LEDGER, DEPR_AREA)
);

Learn More