| 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 | KTOPL | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | No | T004 | KTOPL | Allow NULL? |
| 3 | KTOGR | Account determination | nvarchar | 8 | 0 | CHAR | (N' ') | No | T095A | KTOGR | Allow NULL? |
| 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | AFABE_D | Allow NULL? |
| 5 | KTNAFB | Accumulated depreciation account for ordinary depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTNAFB | Allow NULL? |
| 6 | KTNAFG | Expense account for ordinary depreciation to book val. 0 | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTNAFG | Allow NULL? |
| 7 | KTNAFU | Expense account for ordinary depreciation below zero | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTNAFU | Allow NULL? |
| 8 | KTSAFB | Accumulated depreciation account for special depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSAFB | Allow NULL? |
| 9 | KTSAFG | Expense account for special depreciation up to book value 0 | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSAFG | Allow NULL? |
| 10 | KTSAFU | Expense account for special depreciation below zero | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSAFU | Allow NULL? |
| 11 | KTAAFB | Balance sheet account for unplanned depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAAFB | Allow NULL? |
| 12 | KTAAFG | Expense account for unplanned depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAAFG | Allow NULL? |
| 13 | KTAAFU | Expense account for unplanned depreciation below zero | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAAFU | Allow NULL? |
| 14 | KTZINB | Contra account for posting interest | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTZINB | Allow NULL? |
| 15 | KTZING | Expense account for interest over zero | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTZING | Allow NULL? |
| 16 | KTZINU | Expense account: Interest below zero | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTZINU | Allow NULL? |
| 17 | KTMAFB | Value adjustment account for transferred reserves | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMAFB | Allow NULL? |
| 18 | KTMAFG | Contra account for transferring reserves | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMAFG | Allow NULL? |
| 19 | KTAUNB | Accumulated depreciation account: Revaluation of ord.deprec. | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAUNB | Allow NULL? |
| 20 | KTAUNG | Offsetting account: Revaluation of ordinary depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAUNG | Allow NULL? |
| 21 | KTNZUS | Revenue account for write-up on ordinary depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTNZUS | Allow NULL? |
| 22 | KTSZUS | Revenue account for write-up to special depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSZUS | Allow NULL? |
| 23 | KTAZUS | Revenue account for write-up on unplanned depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAZUS | Allow NULL? |
| 24 | KTMZUS | Rev. account: Write-up on transfer of reserves | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMZUS | Allow NULL? |
