| 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 | AFARSL | Internal calculation key for depreciation and interest | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | AFARSL_OLD | Allow NULL? |
| 3 | GBEGIN | Start of Validity Period | char | 1 | 0 | CHAR | (N' ') | No | | GBEGIN | Allow NULL? |
| 4 | AFATYP | Depreciation type | char | 1 | 0 | CHAR | (N' ') | No | | AFATYP | Allow NULL? |
| 5 | XAFAUT | Automatic calculation of depreciation or interest | char | 1 | 0 | CHAR | (N' ') | No | | XAFAUT | Allow NULL? |
| 6 | DEGFAK | Declining-balance multiplication factor | decimal | 3 | 2 | DEC | ((0)) | No | | DEGFAK | |
| 7 | MAXPRZ | Maximum percentage rate | decimal | 7 | 4 | DEC | ((0)) | No | | MAXPRZ | |
| 8 | MINPRZ | Minimum percentage rate | decimal | 7 | 4 | DEC | ((0)) | No | | MINPRZ | |
| 9 | UMAFSL | Calculation key after changeover | nvarchar | 4 | 0 | CHAR | (N' ') | No | T090 | UMAFSL | Allow NULL? |
| 10 | UMRPRZ | Net book value percentage rate for depreciation changeover | decimal | 3 | 1 | DEC | ((0)) | No | | UMRPRZ | |
| 11 | XSTILL | Calculate shutdown | char | 1 | 0 | CHAR | (N' ') | No | | XSTILL | Allow NULL? |
| 12 | XENDAU | Depreciation after end of planned life | char | 1 | 0 | CHAR | (N' ') | No | | XENDAU | Allow NULL? |
| 13 | XUNTNL | Calculation of depreciation below net book value zero | char | 1 | 0 | CHAR | (N' ') | No | | XUNTNL | Allow NULL? |
| 14 | XEFDAU | Depreciation with expired effective life | char | 1 | 0 | CHAR | (N' ') | No | | XEFDAU | Allow NULL? |
| 15 | PERBZU | Period control: Acquisition | nvarchar | 2 | 0 | CHAR | (N' ') | No | T090R | PERBZU | Allow NULL? |
| 16 | PERBNA | Period control: Acquisition in the following year | nvarchar | 2 | 0 | CHAR | (N' ') | No | T090R | PERBNA | Allow NULL? |
| 17 | PERBAB | Period control: Retirement | nvarchar | 2 | 0 | CHAR | (N' ') | No | T090R | PERBAB | Allow NULL? |
| 18 | PERBUM | Period control : Transfer | nvarchar | 2 | 0 | CHAR | (N' ') | No | T090R | PERBUM | Allow NULL? |
| 19 | XDAILY | Depreciation calculation to exact day | char | 1 | 0 | CHAR | (N' ') | No | | XDAILY | Allow NULL? |
| 20 | XLIFEC | Reduce useful life to the end of fiscal year | char | 1 | 0 | CHAR | (N' ') | No | | XLIFEC | Allow NULL? |
| 21 | XAFNAH | Depreciation levels by fiscal years and periods | char | 1 | 0 | CHAR | (N' ') | No | | XAFNAH | Allow NULL? |
| 22 | XBZDAT | Ind.: Calculate depreciation from the asset value date | char | 1 | 0 | CHAR | (N' ') | No | | XBZDAT | Allow NULL? |
| 23 | UMSTM | Changeover method | char | 1 | 0 | CHAR | (N' ') | No | | UMSTM | Allow NULL? |
| 24 | AFACLA | Ordinary depreciation classification | char | 1 | 0 | CHAR | (N' ') | No | | AFACLA | Allow NULL? |
| 25 | AFAMET | Depreciation calculation method | char | 1 | 0 | CHAR | (N' ') | No | | AFAMET | Allow NULL? |
| 26 | XRAFA | Do not reduce depreciation in shortened fiscal year | char | 1 | 0 | CHAR | (N' ') | No | | XRAFA | Allow NULL? |
| 27 | MSFAKR | Effects of multiple shifts in depreciation key | char | 1 | 0 | CHAR | (N' ') | No | | MSFAKR | Allow NULL? |
| 28 | SCHROTT | Effect of scrap value on the base value | char | 1 | 0 | NUMC | (N'0') | No | | AA_SCHROTT | Allow NULL? |
