T093

Transparent Table Customizing Table
43 Fields 18 CDS Views

Real and derived depreciation areas

T093 is an SAP database table in S/4HANA. Real and derived depreciation areas. It contains 43 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
FAA_CFG_AFABER view inner Intern: Representative Ledger fuer AfA-Bereiche
FAA_MIG_ANEP view inner Join ANEP with ANEK plus add. Field AWKEY
FAA_MIG_ANLC view inner Get ANLC for migration in ACDOCA and FAAT_DOC_IT
faa_mig_anlp view inner ANLP with parallel currency areas
faa_mig_anlp_main view inner Test ANLP
FAA_MIG_PREP view left_outer Get combinations of BUKRS/GJAHR for ANLC migration
Faa_Rc1_Anep view inner Parallel areas without leading area
Faa_Rc1_Anlc_Base view inner Subtract planed values against posted values (Base View)
FAA_RC5_ANLC_NB view inner Reconciliation ANLC Non Posting Areas (Base View) RC5
FAA_REC_ANLC_BASE view inner Reconciliation ANLC (Base View)
FAA_REC_ANLC_BRC5 view inner Reconciliation ANLC (Base View) RC5
Faa_Rec_Anlp_Base view inner Reconciliation ANLP (Base View)
Faa_Rec_Anlp1_Sum view inner Reconciliation ANLP vs ANLC (Result Set)
Faa_Sil_Doc view inner Belege, die über FI-AA nachgebucht werden
I_AssetDepreciationArea view from BASIC Depreciation Area
P_AssetYearOpngValnAttrib view inner BASIC
P_DeprAreaForLedgerText view inner BASIC
P_DepreciationAreaForLedger view inner BASIC

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY afapl AFAPL Chart of Depr.
KEY afaber AFABER Deprec. Area
xstore XSTORE Real Dep. Area
abvor1 ABVORZ Dep. Area Sign
afabe1 AFABE_D Deprec. area
antei1 ANTEIL Divisor for Propor.
abvor2 ABVORZ Dep. Area Sign
afabe2 AFABE_D Deprec. area
antei2 ANTEIL Divisor for Propor.
abvor3 ABVORZ Dep. Area Sign
afabe3 AFABE_D Deprec. area
antei3 ANTEIL Divisor for Propor.
abvor4 ABVORZ Dep. Area Sign
afabe4 AFABE_D Deprec. area
antei4 ANTEIL Divisor for Propor.
vzansw VZANSW Acq. Value Sign
vzrest VZREST Net Bk Val.Sign
buhbkt BUHBKT Ind.: G/L Acct.
view0 VIEWX Asset Views
view1 VIEWX Asset Views
view2 VIEWX Asset Views
view3 VIEWX Asset Views
view4 VIEWX Asset Views
view5 VIEWX Asset Views
view6 VIEWX Asset Views
vzinvz VZINVZ Investment Grants
vzawma VZAWMA Transfer of Reserves
vznafa VZNAFA Ordinary Depreciat.
vzsafa VZSAFA Special Depr.
vzaafa VZAAFA Unplanned Depreciat.
vzindw VZINDW Revaluation
vzzins VZZINS Interest
vzinda VZINDA Revaluation Ord.Dep.
afabeo AFABEO Dep.Area OK
xberep XBEREP Area for reporting purposes only
corrbe AFABE_CORR Modification area
gafaber GLOBAFABER Cross-Syst.Area
ldgrp_gl FAGL_TARGET_LDGRP Target Ledger Group
acc_principle ACCOUNTING_PRINCIPLE Accounting Principle
xafaber X_AFABER As Real Area
abwber ABW_AFABER Alternat. Dep. Area
area_usage_ind AREA_USAGE_IND Dep. Area Purp.

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.

-- Real and derived depreciation areas
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T093 (
    MANDT,           -- Client [MANDT]
    AFAPL,           -- Chart of Depr. [AFAPL]
    AFABER,          -- Deprec. Area [AFABER]
    XSTORE,          -- Real Dep. Area [XSTORE]
    ABVOR1,          -- Dep. Area Sign [ABVORZ]
    AFABE1,          -- Deprec. area [AFABE_D]
    ANTEI1,          -- Divisor for Propor. [ANTEIL]
    ABVOR2,          -- Dep. Area Sign [ABVORZ]
    AFABE2,          -- Deprec. area [AFABE_D]
    ANTEI2,          -- Divisor for Propor. [ANTEIL]
    ABVOR3,          -- Dep. Area Sign [ABVORZ]
    AFABE3,          -- Deprec. area [AFABE_D]
    ANTEI3,          -- Divisor for Propor. [ANTEIL]
    ABVOR4,          -- Dep. Area Sign [ABVORZ]
    AFABE4,          -- Deprec. area [AFABE_D]
    ANTEI4,          -- Divisor for Propor. [ANTEIL]
    VZANSW,          -- Acq. Value Sign [VZANSW]
    VZREST,          -- Net Bk Val.Sign [VZREST]
    BUHBKT,          -- Ind.: G/L Acct. [BUHBKT]
    VIEW0,           -- Asset Views [VIEWX]
    VIEW1,           -- Asset Views [VIEWX]
    VIEW2,           -- Asset Views [VIEWX]
    VIEW3,           -- Asset Views [VIEWX]
    VIEW4,           -- Asset Views [VIEWX]
    VIEW5,           -- Asset Views [VIEWX]
    VIEW6,           -- Asset Views [VIEWX]
    VZINVZ,          -- Investment Grants [VZINVZ]
    VZAWMA,          -- Transfer of Reserves [VZAWMA]
    VZNAFA,          -- Ordinary Depreciat. [VZNAFA]
    VZSAFA,          -- Special Depr. [VZSAFA]
    VZAAFA,          -- Unplanned Depreciat. [VZAAFA]
    VZINDW,          -- Revaluation [VZINDW]
    VZZINS,          -- Interest [VZZINS]
    VZINDA,          -- Revaluation Ord.Dep. [VZINDA]
    AFABEO,          -- Dep.Area OK [AFABEO]
    XBEREP,          -- Area for reporting purposes only [XBEREP]
    CORRBE,          -- Modification area [AFABE_CORR]
    GAFABER,         -- Cross-Syst.Area [GLOBAFABER]
    LDGRP_GL,        -- Target Ledger Group [FAGL_TARGET_LDGRP]
    ACC_PRINCIPLE,   -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    XAFABER,         -- As Real Area [X_AFABER]
    ABWBER,          -- Alternat. Dep. Area [ABW_AFABER]
    AREA_USAGE_IND,  -- Dep. Area Purp. [AREA_USAGE_IND]
    PRIMARY KEY (MANDT, AFAPL, AFABER)
);

Learn More