| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | CHAR | (N' ') | No | T096 | AFAPL | Allow NULL? |
| 3 | AFABER | Depreciation area real or derived | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AFABER | Allow NULL? |
| 4 | XSTORE | Indicator: Store real depreciation area | char | 1 | 0 | CHAR | (N' ') | No | | XSTORE | Allow NULL? |
| 5 | ABVOR1 | +/- Sgn of real dep. area in screen layout rule of der. area | char | 1 | 0 | CHAR | (N' ') | No | | ABVORZ | Allow NULL? |
| 6 | AFABE1 | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABE_D | Allow NULL? |
| 7 | ANTEI1 | Proportion of real depreciation area in derived dep.area | char | 1 | 0 | NUMC | (N'0') | No | | ANTEIL | Allow NULL? |
| 8 | ABVOR2 | +/- Sgn of real dep. area in screen layout rule of der. area | char | 1 | 0 | CHAR | (N' ') | No | | ABVORZ | Allow NULL? |
| 9 | AFABE2 | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABE_D | Allow NULL? |
| 10 | ANTEI2 | Proportion of real depreciation area in derived dep.area | char | 1 | 0 | NUMC | (N'0') | No | | ANTEIL | Allow NULL? |
| 11 | ABVOR3 | +/- Sgn of real dep. area in screen layout rule of der. area | char | 1 | 0 | CHAR | (N' ') | No | | ABVORZ | Allow NULL? |
| 12 | AFABE3 | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABE_D | Allow NULL? |
| 13 | ANTEI3 | Proportion of real depreciation area in derived dep.area | char | 1 | 0 | NUMC | (N'0') | No | | ANTEIL | Allow NULL? |
| 14 | ABVOR4 | +/- Sgn of real dep. area in screen layout rule of der. area | char | 1 | 0 | CHAR | (N' ') | No | | ABVORZ | Allow NULL? |
| 15 | AFABE4 | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABE_D | Allow NULL? |
| 16 | ANTEI4 | Proportion of real depreciation area in derived dep.area | char | 1 | 0 | NUMC | (N'0') | No | | ANTEIL | Allow NULL? |
| 17 | VZANSW | +/- Sign for acquisition value | char | 1 | 0 | CHAR | (N' ') | No | | VZANSW | Allow NULL? |
| 18 | VZREST | +/- Sign for net book value | char | 1 | 0 | CHAR | (N' ') | No | | VZREST | Allow NULL? |
| 19 | BUHBKT | Post to G/L account | char | 1 | 0 | CHAR | (N' ') | No | | BUHBKT | Allow NULL? |
| 20 | VIEW0 | Asset view | char | 1 | 0 | NUMC | (N'0') | No | | VIEWX | Allow NULL? |
| 21 | VIEW1 | Asset view | char | 1 | 0 | NUMC | (N'0') | No | | VIEWX | Allow NULL? |
| 22 | VIEW2 | Asset view | char | 1 | 0 | NUMC | (N'0') | No | | VIEWX | Allow NULL? |
| 23 | VIEW3 | Asset view | char | 1 | 0 | NUMC | (N'0') | No | | VIEWX | Allow NULL? |
| 24 | VIEW4 | Asset view | char | 1 | 0 | NUMC | (N'0') | No | | VIEWX | Allow NULL? |
| 25 | VIEW5 | Asset view | char | 1 | 0 | NUMC | (N'0') | No | | VIEWX | Allow NULL? |
| 26 | VIEW6 | Asset view | char | 1 | 0 | NUMC | (N'0') | No | | VIEWX | Allow NULL? |
| 27 | VZINVZ | +/- Sign for investment grants | char | 1 | 0 | CHAR | (N' ') | No | | VZINVZ | Allow NULL? |
| 28 | VZAWMA | +/- Sign for transfer of reserves(acquis.val.reducing dep.) | char | 1 | 0 | CHAR | (N' ') | No | | VZAWMA | Allow NULL? |
| 29 | VZNAFA | +/- Sign for ordinary depreciation | char | 1 | 0 | CHAR | (N' ') | No | | VZNAFA | Allow NULL? |
| 30 | VZSAFA | +/- Sign for special depreciation | char | 1 | 0 | CHAR | (N' ') | No | | VZSAFA | Allow NULL? |
| 31 | VZAAFA | +/- Sign for unplanned depreciation | char | 1 | 0 | CHAR | (N' ') | No | | VZAAFA | Allow NULL? |
| 32 | VZINDW | +/- Sign for revaluation | char | 1 | 0 | CHAR | (N' ') | No | | VZINDW | Allow NULL? |
| 33 | VZZINS | +/- Sign for interest | char | 1 | 0 | CHAR | (N' ') | No | | VZZINS | Allow NULL? |
| 34 | VZINDA | +/- Sign for revaluation of ordinary depreciation | char | 1 | 0 | CHAR | (N' ') | No | | VZINDA | Allow NULL? |
| 35 | AFABEO | Indicator: Depreciation areas are OK | char | 1 | 0 | CHAR | (N' ') | No | | AFABEO | Allow NULL? |
| 36 | XBEREP | Asset Accounting: Depreciation area for reporting purposes | char | 1 | 0 | CHAR | (N' ') | Yes | | XBEREP | Allow NULL? |
| 37 | CORRBE | Depreciation area used for modification | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T093 | AFABE_CORR | Allow NULL? |
| 38 | GAFABER | Cross-system depreciation area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T093G | GLOBAFABER | Allow NULL? |
| 39 | LDGRP_GL | Target Ledger Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FAGL_TLDGRP | FAGL_TARGET_LDGRP | Allow NULL? |
| 40 | XAFABER | Treat Derived Depreciation Area As Real Area | char | 1 | 0 | CHAR | (N' ') | Yes | | X_AFABER | Allow NULL? |
| 41 | ABWBER | Alternative Depreciation Area for Account Determination | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T093 | ABW_AFABER | Allow NULL? |
| 42 | AREA_USAGE_IND | Purpose of Depreciation Area | char | 1 | 0 | CHAR | (N' ') | Yes | | AREA_USAGE_IND | Allow NULL? |
