| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABE_D | Allow NULL? |
| 4 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | WAERS | Allow NULL? |
| 5 | RUNDEN | Number of places for rounding in depreciation calculation | char | 1 | 0 | NUMC | (N'0') | No | | RUNDEN | Allow NULL? |
| 6 | ERWERT | Memo value | decimal | 13 | 2 | CURR | ((0)) | No | | ERWERT | |
| 7 | GWGWRT | Maximum low-value asset amount | decimal | 13 | 2 | CURR | ((0)) | No | | GWGWRT | |
| 8 | UMRWRT | Net book value for changeover of depreciation method | decimal | 13 | 2 | CURR | ((0)) | No | | UMRWRT | |
| 9 | GWGBST | Maximum LVA amount for purchase order | decimal | 13 | 2 | CURR | ((0)) | No | | GWGBST | |
| 10 | FILLER | Inapplicable | char | 1 | 0 | CHAR | (N' ') | No | | XPERHM | Allow NULL? |
| 11 | RNDAHK | Number of places for rounding indexed replacement value | char | 1 | 0 | NUMC | (N'0') | No | | RNDAHK | Allow NULL? |
| 12 | ABGJA | Closed fiscal year for depreciation calculation | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | ABGJA | Allow NULL? |
| 13 | AFRHY | Depreciation posting cycle | nvarchar | 3 | 0 | NUMC | (N'000') | No | | AFRHY | Allow NULL? |
| 14 | XANZUM | Indicator transfer down payments from previous years | char | 1 | 0 | CHAR | (N' ') | No | | XANZUM | Allow NULL? |
| 15 | VERSN_011 | Financial Statement Version | nvarchar | 4 | 0 | CHAR | (N' ') | No | T011 | VERSN_011 | Allow NULL? |
| 16 | X445R | Weight depreciation distribution | char | 1 | 0 | CHAR | (N' ') | No | | X445R | Allow NULL? |
| 17 | XAKPL | Indicator for managing group assets | char | 1 | 0 | CHAR | (N' ') | No | | T093B_AKPL | Allow NULL? |
| 18 | BASRND | Which value is rounded? | char | 1 | 0 | CHAR | (N' ') | No | | BASRND | Allow NULL? |
| 19 | METRND | Rounding method | char | 1 | 0 | CHAR | (N' ') | No | | METRND | Allow NULL? |
| 20 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | T009 | PERIV | Allow NULL? |
| 21 | TOLERANZ | Tolerance amount in deprec. calculation | decimal | 13 | 2 | CURR | ((0)) | Yes | | FIAA_TOLE | |
| 22 | KZRBWB_AFABE | Area Posts Net Book Value for Retirement | char | 1 | 0 | CHAR | (N' ') | Yes | | KZRBWB_AFABE | Allow NULL? |