GLO_FAAT_MD_VTDD

Transparent Table Application Table
30 Fields 1 CDS Views

Country Specific Fixed Asset Master: Time Dep. Data for Val.

GLO_FAAT_MD_VTDD is an SAP database table in S/4HANA. Country Specific Fixed Asset Master: Time Dep. Data for Val.. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GlobAssetTimeBasedValn view from BASIC CSMD Time Based Valuation of Asset

Fields (30)

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
KEY valid_to_date BDATU Valid To
valid_from_date ADATU Valid From
glo_jp_imp_posting_date GLO_JP_DI Impairment Post Date
glo_jp_imp_apc_hsl GLOFAA_JP_IMP_APC_AMOUNT_HSL APC in Co. Code Crcy
glo_jp_imp_apc_ksl GLOFAA_JP_IMP_APC_AMOUNT_KSL APC in Global Crcy
glo_jp_imp_apc_osl GLOFAA_JP_IMP_APC_AMOUNT_OSL APC in Currency 1
glo_jp_imp_apc_vsl GLOFAA_JP_IMP_APC_AMOUNT_VSL APC in Currency 2
glo_jp_imp_apc_bsl GLOFAA_JP_IMP_APC_AMOUNT_BSL APC in Currency 3
glo_jp_imp_apc_csl GLOFAA_JP_IMP_APC_AMOUNT_CSL APC in Currency 4
glo_jp_imp_apc_dsl GLOFAA_JP_IMP_APC_AMOUNT_DSL APC in Currency 5
glo_jp_imp_apc_esl GLOFAA_JP_IMP_APC_AMOUNT_ESL APC in Currency 6
glo_jp_imp_apc_fsl GLOFAA_JP_IMP_APC_AMOUNT_FSL APC in Currency 7
glo_jp_imp_apc_gsl GLOFAA_JP_IMP_APC_AMOUNT_GSL APC in Currency 8
glo_jp_imp_bai_hsl GLOFAA_JP_IMP_BAI_AMOUNT_HSL BAI in Co. Code Crcy
glo_jp_imp_bai_ksl GLOFAA_JP_IMP_BAI_AMOUNT_KSL BAI in Global Crcy
glo_jp_imp_bai_osl GLOFAA_JP_IMP_BAI_AMOUNT_OSL BAI in Currency 1
glo_jp_imp_bai_vsl GLOFAA_JP_IMP_BAI_AMOUNT_VSL BAI in Currency 2
glo_jp_imp_bai_bsl GLOFAA_JP_IMP_BAI_AMOUNT_BSL BAI in Currency 3
glo_jp_imp_bai_csl GLOFAA_JP_IMP_BAI_AMOUNT_CSL BAI in Currency 4
glo_jp_imp_bai_dsl GLOFAA_JP_IMP_BAI_AMOUNT_DSL BAI in Currency 5
glo_jp_imp_bai_esl GLOFAA_JP_IMP_BAI_AMOUNT_ESL BAI in Currency 6
glo_jp_imp_bai_fsl GLOFAA_JP_IMP_BAI_AMOUNT_FSL BAI in Currency 7
glo_jp_imp_bai_gsl GLOFAA_JP_IMP_BAI_AMOUNT_GSL BAI in Currency 8
glo_sk_cptl_imprv_yr GLOFAA_SK_CPTL_IMPRV_YEAR Capital Impr.Year

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.

-- Country Specific Fixed Asset Master: Time Dep. Data for Val.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLO_FAAT_MD_VTDD (
    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]
    VALID_TO_DATE,            -- Valid To [BDATU]
    VALID_FROM_DATE,          -- Valid From [ADATU]
    GLO_JP_IMP_POSTING_DATE,  -- Impairment Post Date [GLO_JP_DI]
    GLO_JP_IMP_APC_HSL,       -- APC in Co. Code Crcy [GLOFAA_JP_IMP_APC_AMOUNT_HSL]
    GLO_JP_IMP_APC_KSL,       -- APC in Global Crcy [GLOFAA_JP_IMP_APC_AMOUNT_KSL]
    GLO_JP_IMP_APC_OSL,       -- APC in Currency 1 [GLOFAA_JP_IMP_APC_AMOUNT_OSL]
    GLO_JP_IMP_APC_VSL,       -- APC in Currency 2 [GLOFAA_JP_IMP_APC_AMOUNT_VSL]
    GLO_JP_IMP_APC_BSL,       -- APC in Currency 3 [GLOFAA_JP_IMP_APC_AMOUNT_BSL]
    GLO_JP_IMP_APC_CSL,       -- APC in Currency 4 [GLOFAA_JP_IMP_APC_AMOUNT_CSL]
    GLO_JP_IMP_APC_DSL,       -- APC in Currency 5 [GLOFAA_JP_IMP_APC_AMOUNT_DSL]
    GLO_JP_IMP_APC_ESL,       -- APC in Currency 6 [GLOFAA_JP_IMP_APC_AMOUNT_ESL]
    GLO_JP_IMP_APC_FSL,       -- APC in Currency 7 [GLOFAA_JP_IMP_APC_AMOUNT_FSL]
    GLO_JP_IMP_APC_GSL,       -- APC in Currency 8 [GLOFAA_JP_IMP_APC_AMOUNT_GSL]
    GLO_JP_IMP_BAI_HSL,       -- BAI in Co. Code Crcy [GLOFAA_JP_IMP_BAI_AMOUNT_HSL]
    GLO_JP_IMP_BAI_KSL,       -- BAI in Global Crcy [GLOFAA_JP_IMP_BAI_AMOUNT_KSL]
    GLO_JP_IMP_BAI_OSL,       -- BAI in Currency 1 [GLOFAA_JP_IMP_BAI_AMOUNT_OSL]
    GLO_JP_IMP_BAI_VSL,       -- BAI in Currency 2 [GLOFAA_JP_IMP_BAI_AMOUNT_VSL]
    GLO_JP_IMP_BAI_BSL,       -- BAI in Currency 3 [GLOFAA_JP_IMP_BAI_AMOUNT_BSL]
    GLO_JP_IMP_BAI_CSL,       -- BAI in Currency 4 [GLOFAA_JP_IMP_BAI_AMOUNT_CSL]
    GLO_JP_IMP_BAI_DSL,       -- BAI in Currency 5 [GLOFAA_JP_IMP_BAI_AMOUNT_DSL]
    GLO_JP_IMP_BAI_ESL,       -- BAI in Currency 6 [GLOFAA_JP_IMP_BAI_AMOUNT_ESL]
    GLO_JP_IMP_BAI_FSL,       -- BAI in Currency 7 [GLOFAA_JP_IMP_BAI_AMOUNT_FSL]
    GLO_JP_IMP_BAI_GSL,       -- BAI in Currency 8 [GLOFAA_JP_IMP_BAI_AMOUNT_GSL]
    GLO_SK_CPTL_IMPRV_YR,     -- Capital Impr.Year [GLOFAA_SK_CPTL_IMPRV_YEAR]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO, LEDGER, DEPR_AREA, VALID_TO_DATE)
);

Learn More