| 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 | * | MANDT | Allow NULL? |
| 2 | KTOPL | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | KTOPL | Allow NULL? |
| 3 | KTOGR | Account determination | nvarchar | 8 | 0 | CHAR | (N' ') | No | * | KTOGR | Allow NULL? |
| 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | AFABE_D | Allow NULL? |
| 5 | MGPLN | Migration Plan | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | FAGL_MGPLN | Allow NULL? |
| 6 | LDGRP | Ledger Group | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | FAGL_LDGRP | Allow NULL? |
| 7 | KTANSW | Bal. sheet account: Acquisition and production costs | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTANSW | Allow NULL? |
| 8 | KTANZA | G/L account:down payments | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTANZA | Allow NULL? |
| 9 | KTERLW | Clearing account for revenue from asset sale | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTERLW | Allow NULL? |
| 10 | KTMEHR | G/L account: asset retirement gain | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTMEHR | Allow NULL? |
| 11 | KTMAHK | Acct:Gain from asset retirement over APC (curr. not used) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTMAHK | Allow NULL? |
| 12 | KTMIND | G/L account for asset retirement loss | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTMIND | Allow NULL? |
| 13 | KTREST | G/L account for net book value when scrapped | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTREST | Allow NULL? |
| 14 | KTAPFG | G/L account:Decimals from asset acquisition: not used | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTADEC | Allow NULL? |
| 15 | KTAUFW | Reconciliation account: Revaluation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAUFW | Allow NULL? |
| 16 | KTAUFG | Offsetting account for revaluation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAUFG | Allow NULL? |
| 17 | KTANSG | Contra account: Acquisition value posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTANSG | Allow NULL? |
| 18 | KTANZG | Contra account: Down payment posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTANZG | Allow NULL? |
| 19 | KTVBAB | Clearing acct.revenue from sale to affiliated company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTVBAB | Allow NULL? |
| 20 | KTVZU | Clearing acct: Acquisition from affiliated company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTVBZU | Allow NULL? |
| 21 | KTVIZU | Clearing account for allocation of investment support | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTVIZU | Allow NULL? |
| 22 | KTRIZU | Clearing account for repaying investment support | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTVRIZ | Allow NULL? |
| 23 | KTARIZ | Expense account:Repayment of investment support | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTARIZ | Allow NULL? |
| 24 | KTVERK | G/L acct for costs of sale | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTVERK | Allow NULL? |
| 25 | KTCOAB | Cost element for settlement of asset u. cons. to CO objects | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTCOAB | Allow NULL? |
| 26 | KTENAK | Revenue account for post-capitaliz. of asset | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTENAK | Allow NULL? |
| 27 | KTNAIB | Account for capitalization differences/nonoperating expense | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTNAIB | Allow NULL? |
| 28 | KTNAFB | Accumulated depreciation account for ordinary depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTNAFB | Allow NULL? |
| 29 | KTNAFG | Expense account for ordinary depreciation to book val. 0 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTNAFG | Allow NULL? |
| 30 | KTNAFU | Expense account for ordinary depreciation below zero | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTNAFU | Allow NULL? |
| 31 | KTSAFB | Accumulated depreciation account for special depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTSAFB | Allow NULL? |
| 32 | KTSAFG | Expense account for special depreciation up to book value 0 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTSAFG | Allow NULL? |
| 33 | KTSAFU | Expense account for special depreciation below zero | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTSAFU | Allow NULL? |
| 34 | KTAAFB | Balance sheet account for unplanned depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAAFB | Allow NULL? |
| 35 | KTAAFG | Expense account for unplanned depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAAFG | Allow NULL? |
| 36 | KTAAFU | Expense account for unplanned depreciation below zero | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAAFU | Allow NULL? |
| 37 | KTZINB | Contra account for posting interest | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTZINB | Allow NULL? |
| 38 | KTZING | Expense account for interest over zero | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTZING | Allow NULL? |
| 39 | KTZINU | Expense account: Interest below zero | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTZINU | Allow NULL? |
| 40 | KTMAFB | Value adjustment account for transferred reserves | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTMAFB | Allow NULL? |
| 41 | KTMAFG | Contra account for transferring reserves | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTMAFG | Allow NULL? |
| 42 | KTAUNB | Accumulated depreciation account: Revaluation of ord.deprec. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAUNB | Allow NULL? |
| 43 | KTAUNG | Offsetting account: Revaluation of ordinary depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAUNG | Allow NULL? |
| 44 | KTNZUS | Revenue account for write-up on ordinary depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTNZUS | Allow NULL? |
| 45 | KTSZUS | Revenue account for write-up to special depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTSZUS | Allow NULL? |
| 46 | KTAZUS | Revenue account for write-up on unplanned depreciation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTAZUS | Allow NULL? |
| 47 | KTMZUS | Rev. account: Write-up on transfer of reserves | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KTMZUS | Allow NULL? |
