| 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 | T004 | KTOPL | Allow NULL? |
| 3 | KTOGR | Account determination | nvarchar | 8 | 0 | CHAR | (N' ') | No | T095A | KTOGR | Allow NULL? |
| 4 | AFASL | Depreciation key | nvarchar | 4 | 0 | CHAR | (N' ') | No | T090NA | AFASL | Allow NULL? |
| 5 | AFABER | Depreciation area real or derived | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABER | Allow NULL? |
| 6 | KTSOPO | Spec.res. Balance sheet account | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSOPO | Allow NULL? |
| 7 | KTSEIN | Exp. acct: Allocation to special reserves | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSEIN | Allow NULL? |
| 8 | KTNAUF | P&L account:Write-off spec.reserves w/ gross allocation | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTNAUF | Allow NULL? |
| 9 | KTSAUF | Rev. acct: Amortiz. special reserves | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSAUF | Allow NULL? |
| 10 | KTSABG | Rev. acct: Amortiz. spec.reserves after retirement | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTSABG | Allow NULL? |
| 11 | KTZUSA | Rev. account: Write-up on special reserves | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTZUSA | Allow NULL? |
| 12 | KTMEHR | G/L account: asset retirement gain | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMEHR | Allow NULL? |
| 13 | KTMIND | G/L account for asset retirement loss | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTMIND | Allow NULL? |
| 14 | KTVBAB | Clearing acct.revenue from sale to affiliated company | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | KTVBAB | Allow NULL? |
