| 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 | AFASL | Depreciation key | nvarchar | 4 | 0 | CHAR | (N' ') | No | | AFASL | Allow NULL? |
| 4 | XAKTIV | Status of depreciation key | char | 1 | 0 | CHAR | (N' ') | Yes | | XAKTIV_RSL | Allow NULL? |
| 5 | METHBT | Maximum amount method | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T090NH_METH | METHBT | Allow NULL? |
| 6 | ANHWSL | Cutoff value key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T091 | ANHWSL | Allow NULL? |
| 7 | XNAAUS | No ord. depreciation with special depreciation | char | 1 | 0 | CHAR | (N' ') | Yes | | XNAAUS | Allow NULL? |
| 8 | XZIAUS | No interest if there is no depreciation planned | char | 1 | 0 | CHAR | (N' ') | Yes | | XZIAUS | Allow NULL? |
| 9 | XNAZUG | Acquisition in year of capitalization only | char | 1 | 0 | CHAR | (N' ') | Yes | | XNAZUG_NEW | Allow NULL? |
| 10 | XPERGJ | Period control per fiscal year | char | 1 | 0 | CHAR | (N' ') | Yes | | XPERGJ | Allow NULL? |
| 11 | PROZST | Number of places that the percentage rate is rounded to | char | 1 | 0 | NUMC | (N'0') | Yes | | PROZST | Allow NULL? |
| 12 | XDAILY | Depreciation calculation to exact day | char | 1 | 0 | CHAR | (N' ') | Yes | | XDAILY | Allow NULL? |
| 13 | XRAFA | Do not reduce depreciation in shortened fiscal year | char | 1 | 0 | CHAR | (N' ') | Yes | | XRAFA | Allow NULL? |