| 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 | T093 | AFABE_D | Allow NULL? |
| 5 | KTANSW | Bal. sheet account: Acquisition and production costs | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTANSW | Allow NULL? |
| 6 | KTANZA | G/L account:down payments | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTANZA | Allow NULL? |
| 7 | KTERLW | Clearing account for revenue from asset sale | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTERLW | Allow NULL? |
| 8 | KTMEHR | G/L account: asset retirement gain | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMEHR | Allow NULL? |
| 9 | KTMAHK | Acct:Gain from asset retirement over APC (curr. not used) | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMAHK | Allow NULL? |
| 10 | KTMIND | G/L account for asset retirement loss | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMIND | Allow NULL? |
| 11 | KTREST | G/L account for net book value when scrapped | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTREST | Allow NULL? |
| 12 | KTAPFG | G/L account:Decimals from asset acquisition: not used | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTADEC | Allow NULL? |
| 13 | KTAUFW | Reconciliation account: Revaluation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAUFW | Allow NULL? |
| 14 | KTAUFG | Offsetting account for revaluation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTAUFG | Allow NULL? |
| 15 | KTANSG | Contra account: Acquisition value posting | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTANSG | Allow NULL? |
| 16 | KTANZG | Contra account: Down payment posting | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTANZG | Allow NULL? |
| 17 | KTVBAB | Clearing acct.revenue from sale to affiliated company | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTVBAB | Allow NULL? |
| 18 | KTVZU | Clearing acct: Acquisition from affiliated company | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTVBZU | Allow NULL? |
| 19 | KTVIZU | Clearing account for allocation of investment support | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTVIZU | Allow NULL? |
| 20 | KTRIZU | Clearing account for repaying investment support | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTVRIZ | Allow NULL? |
| 21 | KTARIZ | Expense account:Repayment of investment support | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTARIZ | Allow NULL? |
| 22 | KTVERK | G/L acct for costs of sale | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | KTVERK | Allow NULL? |
| 23 | KTCOAB | Cost element for settlement of asset u. cons. to CO objects | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTCOAB | Allow NULL? |
| 24 | KTENAK | Revenue account for post-capitaliz. of asset | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTENAK | Allow NULL? |
| 25 | KTNAIB | Account for capitalization differences/nonoperating expense | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTNAIB | Allow NULL? |
