1. Home
  2. Resources
  3. SAP Tables
  4. V_AFABE - Generated Table for View

SAP Table V_AFABE

Generated Table for View

V_AFABE (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link V_AFABE to other SAP tables.

V_AFABE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
AFABE Real depreciation area AFABE_D T093 NUMC 2 0
WAERS Currency Key WAERS TCURC CUKY 5 0
RUNDEN Number of places for rounding in depreciation calculation RUNDEN NUMC 1 0
ERWERT Memo value ERWERT CURR 13 2
GWGWRT Maximum low-value asset amount GWGWRT CURR 13 2
UMRWRT Net book value for changeover of depreciation method UMRWRT CURR 13 2
GWGBST Maximum LVA amount for purchase order GWGBST CURR 13 2
FILLER Inapplicable XPERHM CHAR 1 0
X Yes
NULL No
RNDAHK Number of places for rounding indexed replacement value RNDAHK NUMC 1 0
ABGJA Closed fiscal year for depreciation calculation ABGJA NUMC 4 0
AFRHY Depreciation posting cycle AFRHY NUMC 3 0
0
XANZUM Indicator transfer down payments from previous years XANZUM CHAR 1 0
X Yes
NULL No
VERSN_011 Financial Statement Version VERSN_011 T011 CHAR 4 0
X445R Weight depreciation distribution X445R CHAR 1 0
X Yes
NULL No
XAKPL Indicator for managing group assets T093B_AKPL CHAR 1 0
X Yes
NULL No
BASRND Which value is rounded? BASRND CHAR 1 0
0 Net book value
1 Automatically calculated depreciation
METRND Rounding method METRND CHAR 1 0
0 Arithmetic Rounding
1 Round Up
2 Round Down
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
TOLERANZ Tolerance amount in deprec. calculation FIAA_TOLE CURR 13 2
KZRBWB_AFABE Area Posts Net Book Value for Retirement KZRBWB_AFABE CHAR 1 0
X Yes
NULL No
AFAPL Chart of depreciaton for asset valuation AFAPL T096 CHAR 4 0
XSTORE Indicator: Store real depreciation area XSTORE CHAR 1 0
X Yes
NULL No
ABVOR1 +/- Sgn of real dep. area in screen layout rule of der. area ABVORZ CHAR 1 0
+ positive
- negative
AFABE1 Real depreciation area AFABE_D T093 NUMC 2 0
ANTEI1 Proportion of real depreciation area in derived dep.area ANTEIL NUMC 1 0
ABVOR2 +/- Sgn of real dep. area in screen layout rule of der. area ABVORZ CHAR 1 0
+ positive
- negative
AFABE2 Real depreciation area AFABE_D T093 NUMC 2 0
ANTEI2 Proportion of real depreciation area in derived dep.area ANTEIL NUMC 1 0
ABVOR3 +/- Sgn of real dep. area in screen layout rule of der. area ABVORZ CHAR 1 0
+ positive
- negative
AFABE3 Real depreciation area AFABE_D T093 NUMC 2 0
ANTEI3 Proportion of real depreciation area in derived dep.area ANTEIL NUMC 1 0
ABVOR4 +/- Sgn of real dep. area in screen layout rule of der. area ABVORZ CHAR 1 0
+ positive
- negative
AFABE4 Real depreciation area AFABE_D T093 NUMC 2 0
ANTEI4 Proportion of real depreciation area in derived dep.area ANTEIL NUMC 1 0
VZANSW +/- Sign for acquisition value VZANSW CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZREST +/- Sign for net book value VZREST CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
BUHBKT Post to G/L account BUHBKT CHAR 1 0
0 Area Does Not Post
1 Area Posts in Realtime
2 Area Posts APC and Depreciation Periodically
3 Area Posts Depreciation Only
4 Area Posts APC Directly and Depreciation
5 Area Posts APC Only
6 Area Posts Only APC Directly
VIEW0 Asset view VIEWX NUMC 1 0
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 VIEWX NUMC 1 0
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 VIEWX NUMC 1 0
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 VIEWX NUMC 1 0
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 VIEWX NUMC 1 0
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 VIEWX NUMC 1 0
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 VIEWX NUMC 1 0
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 VZINVZ CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZAWMA +/- Sign for transfer of reserves(acquis.val.reducing dep.) VZAWMA CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZNAFA +/- Sign for ordinary depreciation VZNAFA CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZSAFA +/- Sign for special depreciation VZSAFA CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZAAFA +/- Sign for unplanned depreciation VZAAFA CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZINDW +/- Sign for revaluation VZINDW CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZZINS +/- Sign for interest VZZINS CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
VZINDA +/- Sign for revaluation of ordinary depreciation VZINDA CHAR 1 0
+ Only Positive Values or Zero Allowed
- Only Negative Values or Zero Allowed
* All Values Allowed
0 No Values Allowed
AFABEO Indicator: Depreciation areas are OK AFABEO CHAR 1 0
X Yes
NULL No
XBEREP Asset Accounting: Depreciation area for reporting purposes XBEREP CHAR 1 0
X Yes
NULL No
CORRBE Depreciation area used for modification AFABE_CORR T093 NUMC 2 0
GAFABER Cross-system depreciation area GLOBAFABER T093G CHAR 2 0
LDGRP_GL Target Ledger Group FAGL_TARGET_LDGRP FAGL_TLDGRP CHAR 4 0
XAFABER Treat Derived Depreciation Area As Real Area X_AFABER CHAR 1 0
X Yes
NULL No
ABWBER Alternative Depreciation Area for Account Determination ABW_AFABER T093 NUMC 2 0
AREA_USAGE_IND Purpose of Depreciation Area AREA_USAGE_IND CHAR 1 0
NULL Default Settings
1 Area for Differences Only
2 Adjustment of Special Reserves - France
WRTAFB Adoption of values from depreciation area WRTAFB T093 NUMC 2 0
PARAFB Transfer of Depreciation Terms from Depreciation Area PARAFB T093 NUMC 2 0
XINDHI Ind: Calculate replacement value historically XINDHI CHAR 1 0
X Yes
NULL No
XWRTID Identical transfer of acquisition value XWRTID CHAR 1 0
X Yes
NULL No
XINDID Identical depreciation terms copied XINDID CHAR 1 0
X Yes
NULL No
AFARFO Sequence for depreciation calculation AFARFO CHAR 4 0
XZUJHR Ind: Manage asset values by acquisition year XZUJHR CHAR 1 0
X Yes
NULL No
XZUCOD Ind: Manage asset values according to currency codes XZUCOD CHAR 1 0
X Yes
NULL No
XAFABH Indicator: Dependent depreciation areas exist XAFABH CHAR 1 0
X Yes
NULL No
XUMHIS Indicator: Transfer with historical values XUMHIS CHAR 1 0
X Yes
NULL No
RVERS_GC Consolidation version RVERS_GC T858 CHAR 3 0
HS1069 Subgroup RSUBD T852 CHAR 3 0
CURNO Number of the Local Currency CURNO NUMC 1 0
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
BERTYP Standardization of deprec. area BERTYP CHAR 2 0
01 Valuation for trade bal. sheet
02 Special dep. reserves (special tax depreciation)
03 Valuation for tax bal. sheet (diff. from trade bal. sheet)
04 Net worth valuation
05 Insurance valuation
06 Group valuation
07 Cost-acc. valuation
08 Investment support
09 Manual Revaluation
10 US: Federal tax ACRS / MACRS
11 US: SMACRS - State modified MACRS
12 US: ALTMIN - Alternative minimum tax
13 US: ACE - Adjusted Current Earnings
14 US: E&P - Earnings & Profits
15 Austria: investment incentive
16 Stock indicator for real estate management of insurances
17 Depreciation area for handling inflation (hard currency)
18 Balance sheet according to other guidelines (e.g. IAS)
19 Property Tax (Russia)
20 Transport Tax (Russia)
21 Area Posts Net Book Value for Retirement
VERSN Capitalization Version for Capital Investment Measure VERSN_AIB TKKAL CHAR 3 0
XMENGE Area Is Relevant for Quantity Update XMENGE_AFABE CHAR 1 0
X TRUE
NULL FALSE

V_AFABE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_AFABE ABWBER V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE ABWBER V_AFABE ABWBER T093 Real and derived depreciation areas AFABER
V_AFABE ABWBER V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE AFABE V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE AFABE T093C AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE AFABE V_AFABE AFABE T093 Real and derived depreciation areas AFABER
V_AFABE AFABE1 V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE AFABE1 V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE AFABE1 V_AFABE AFABE1 T093 Real and derived depreciation areas AFABER
V_AFABE AFABE2 V_AFABE AFABE2 T093 Real and derived depreciation areas AFABER
V_AFABE AFABE2 V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE AFABE2 V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE AFABE3 V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE AFABE3 V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE AFABE3 V_AFABE AFABE3 T093 Real and derived depreciation areas AFABER
V_AFABE AFABE4 V_AFABE AFABE4 T093 Real and derived depreciation areas AFABER
V_AFABE AFABE4 V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE AFABE4 V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE AFAPL V_AFABE MANDT T096 Chart of depreciation MANDT
V_AFABE AFAPL V_AFABE AFAPL T096 Chart of depreciation AFAPL
V_AFABE BUKRS V_AFABE BUKRS T001 Company Codes BUKRS
V_AFABE BUKRS V_AFABE MANDT T001 Company Codes MANDT
V_AFABE CORRBE V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE CORRBE V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE CORRBE V_AFABE CORRBE T093 Real and derived depreciation areas AFABER
V_AFABE GAFABER V_AFABE MANDT T093G Cross-System Depreciation Areas MANDT
V_AFABE GAFABER V_AFABE GAFABER T093G Cross-System Depreciation Areas GAFABER
V_AFABE HS1069 V_AFABE MANDT T852 Subgroups MANDT
V_AFABE HS1069 V_AFABE HS1069 T852 Subgroups RSUBD
V_AFABE LDGRP_GL V_AFABE MANDT FAGL_TLDGRP Ledger Group MANDT
V_AFABE LDGRP_GL V_AFABE LDGRP_GL FAGL_TLDGRP Ledger Group LDGRP
V_AFABE MANDT V_AFABE MANDT T000 Clients MANDT
V_AFABE PARAFB V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE PARAFB V_AFABE PARAFB T093 Real and derived depreciation areas AFABER
V_AFABE PARAFB V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE PERIV V_AFABE MANDT T009 Fiscal Year Variants MANDT
V_AFABE PERIV V_AFABE PERIV T009 Fiscal Year Variants PERIV
V_AFABE RVERS_GC V_AFABE MANDT T858 Consolidation versions MANDT
V_AFABE RVERS_GC V_AFABE RVERS_GC T858 Consolidation versions RVERS
V_AFABE VERSN V_AFABE AFAPL TKKAL Entity Table for RA Versions for Assets Under Construction AFAPL
V_AFABE VERSN V_AFABE VERSN TKKAL Entity Table for RA Versions for Assets Under Construction VERSA
V_AFABE VERSN V_AFABE MANDT TKKAL Entity Table for RA Versions for Assets Under Construction MANDT
V_AFABE VERSN_011 V_AFABE MANDT T011 Financial Statement Versions MANDT
V_AFABE VERSN_011 V_AFABE VERSN_011 T011 Financial Statement Versions VERSN
V_AFABE WAERS V_AFABE MANDT TCURC Currency Codes MANDT
V_AFABE WAERS V_AFABE WAERS TCURC Currency Codes WAERS
V_AFABE WRTAFB V_AFABE MANDT T093 Real and derived depreciation areas MANDT
V_AFABE WRTAFB V_AFABE AFAPL T093 Real and derived depreciation areas AFAPL
V_AFABE WRTAFB V_AFABE WRTAFB T093 Real and derived depreciation areas AFABER