SAP table T093 (Real and derived depreciation areas)

SAP table T093 has 3 primary key fields being MANDT,AFAPL,AFABER.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AFAPL Chart of Depreciaton for Asset Valuation CHAR 4 0 T096 AFAPL
AFABER Depreciation Area Real or Derived NUMC 2 0 AFABER
XSTORE Indicator: Store Real Depreciation Area CHAR 1 0 XSTORE
ABVOR1 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area CHAR 1 0 ABVORZ
AFABE1 Real depreciation area NUMC 2 0 T093 AFABE_D
ANTEI1 Proportion of Real Depreciation Area in Derived Dep.Area NUMC 1 0 ANTEIL
ABVOR2 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area CHAR 1 0 ABVORZ
AFABE2 Real depreciation area NUMC 2 0 T093 AFABE_D
ANTEI2 Proportion of Real Depreciation Area in Derived Dep.Area NUMC 1 0 ANTEIL
ABVOR3 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area CHAR 1 0 ABVORZ
AFABE3 Real depreciation area NUMC 2 0 T093 AFABE_D
ANTEI3 Proportion of Real Depreciation Area in Derived Dep.Area NUMC 1 0 ANTEIL
ABVOR4 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area CHAR 1 0 ABVORZ
AFABE4 Real depreciation area NUMC 2 0 T093 AFABE_D
ANTEI4 Proportion of Real Depreciation Area in Derived Dep.Area NUMC 1 0 ANTEIL
VZANSW +/- Sign for Acquisition Value CHAR 1 0 VZANSW
VZREST +/- Sign for Net Book Value CHAR 1 0 VZREST
BUHBKT Post to G/L Account CHAR 1 0 BUHBKT
0 Area Does Not Post
1 Area Posts in Real Time
3 Area Posts Depreciation Only
4 Area Posts APC Immediately and Depreciation
VIEW0 Asset View NUMC 1 0 VIEWX
0 No authorization for this field group
1 Field group can be displayed
2 Field group can be displayed and changed
3 Field group is taken over from model (cannot change/display)
VIEW1 Asset View NUMC 1 0 VIEWX
0 No authorization for this field group
1 Field group can be displayed
2 Field group can be displayed and changed
3 Field group is taken over from model (cannot change/display)
VIEW2 Asset View NUMC 1 0 VIEWX
0 No authorization for this field group
1 Field group can be displayed
2 Field group can be displayed and changed
3 Field group is taken over from model (cannot change/display)
VIEW3 Asset View NUMC 1 0 VIEWX
0 No authorization for this field group
1 Field group can be displayed
2 Field group can be displayed and changed
3 Field group is taken over from model (cannot change/display)
VIEW4 Asset View NUMC 1 0 VIEWX
0 No authorization for this field group
1 Field group can be displayed
2 Field group can be displayed and changed
3 Field group is taken over from model (cannot change/display)
VIEW5 Asset View NUMC 1 0 VIEWX
0 No authorization for this field group
1 Field group can be displayed
2 Field group can be displayed and changed
3 Field group is taken over from model (cannot change/display)
VIEW6 Asset View NUMC 1 0 VIEWX
0 No authorization for this field group
1 Field group can be displayed
2 Field group can be displayed and changed
3 Field group is taken over from model (cannot change/display)
VZINVZ +/- Sign for Investment Grants CHAR 1 0 VZINVZ
VZAWMA +/- Sign for Transfer of Reserves(Acquis.Val.Reducing Dep.) CHAR 1 0 VZAWMA
VZNAFA +/- Sign for Ordinary Depreciation CHAR 1 0 VZNAFA
VZSAFA +/- Sign for Special Depreciation CHAR 1 0 VZSAFA
VZAAFA +/- Sign for Unplanned Depreciation CHAR 1 0 VZAAFA
VZINDW +/- Sign for Revaluation CHAR 1 0 VZINDW
VZZINS +/- Sign for Interest CHAR 1 0 VZZINS
VZINDA +/- Sign for Revaluation of Ordinary Depreciation CHAR 1 0 VZINDA
AFABEO Indicator: Depreciation Areas Are OK CHAR 1 0 AFABEO
XBEREP Asset Accounting: Depreciation area for reporting purposes CHAR 1 0 XBEREP
CORRBE Depreciation area used for modification NUMC 2 0 T093 AFABE_CORR
GAFABER Cross-System Depreciation Area CHAR 2 0 T093G GLOBAFABER
LDGRP_GL Target Ledger Group CHAR 4 0 FAGL_TLDGRP FAGL_TARGET_LDGRP
ACC_PRINCIPLE Accounting Principle CHAR 4 0 * ACCOUNTING_PRINCIPLE
XAFABER Treat Derived Depreciation Area as Real Area CHAR 1 0 X_AFABER
ABWBER Alternative Depreciation Area for Account Determination NUMC 2 0 T093 ABW_AFABER
AREA_USAGE_IND Purpose of Depreciation Area CHAR 1 0 AREA_USAGE_IND
Default Settings
1 Area for Differences Only
2 Adjustment of Special Reserves - France

T093 foreign key relationships

Table Field Check Table Check Field
0 T093 ABWBER T093 Real and derived depreciation areas MANDT
0 T093 ABWBER T093 Real and derived depreciation areas AFAPL
0 T093 ABWBER T093 Real and derived depreciation areas AFABER
1 T093 AFABE1 T093 Real and derived depreciation areas MANDT
1 T093 AFABE1 T093 Real and derived depreciation areas AFAPL
1 T093 AFABE1 T093 Real and derived depreciation areas AFABER
0 T093 AFABE2 T093 Real and derived depreciation areas MANDT
0 T093 AFABE2 T093 Real and derived depreciation areas AFAPL
0 T093 AFABE2 T093 Real and derived depreciation areas AFABER
1 T093 AFABE3 T093 Real and derived depreciation areas MANDT
1 T093 AFABE3 T093 Real and derived depreciation areas AFAPL
1 T093 AFABE3 T093 Real and derived depreciation areas AFABER
0 T093 AFABE4 T093 Real and derived depreciation areas MANDT
0 T093 AFABE4 T093 Real and derived depreciation areas AFAPL
0 T093 AFABE4 T093 Real and derived depreciation areas AFABER
1 T093 AFAPL T096 Chart of depreciation MANDT
0 T093 CORRBE T093 Real and derived depreciation areas MANDT
0 T093 CORRBE T093 Real and derived depreciation areas AFAPL
0 T093 CORRBE T093 Real and derived depreciation areas AFABER
1 T093 GAFABER T093G Cross-System Depreciation Areas MANDT
1 T093 GAFABER T093G Cross-System Depreciation Areas GAFABER
0 T093 LDGRP_GL FAGL_TLDGRP Ledger Group LDGRP
1 T093 MANDT T000 Clients MANDT