SAP table T095B (G/L accounts value adjustment)
SAP table T095B has 4 primary key fields being MANDT,KTOPL,KTOGR,AFABE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KTOPL | Chart of Accounts | CHAR | 4 | 0 | T004 | KTOPL | |
| KTOGR | Account Determination | CHAR | 8 | 0 | T095A | KTOGR | |
| AFABE | Real depreciation area | NUMC | 2 | 0 | AFABE_D | ||
| KTNAFB | Accumulated Depreciation Account for Ordinary Depreciation | CHAR | 10 | 0 | SKA1 | KTNAFB | |
| KTNAFG | Expense Account for Ordinary Depreciation to Book Val. 0 | CHAR | 10 | 0 | SKA1 | KTNAFG | |
| KTNAFU | Expense Account for Ordinary Depreciation Below Zero | CHAR | 10 | 0 | SKA1 | KTNAFU | |
| KTSAFB | Accumulated Depreciation Account for Special Depreciation | CHAR | 10 | 0 | SKA1 | KTSAFB | |
| KTSAFG | Expense Account for Special Depreciation up to Book Value 0 | CHAR | 10 | 0 | SKA1 | KTSAFG | |
| KTSAFU | Expense Account for Special Depreciation Below Zero | CHAR | 10 | 0 | SKA1 | KTSAFU | |
| KTAAFB | Balance Sheet Account for Unplanned Depreciation | CHAR | 10 | 0 | SKA1 | KTAAFB | |
| KTAAFG | Expense Account for Unplanned Depreciation | CHAR | 10 | 0 | SKA1 | KTAAFG | |
| KTAAFU | Expense Account for Unplanned Depreciation Below Zero | CHAR | 10 | 0 | SKA1 | KTAAFU | |
| KTZINB | Contra Account for Posting Interest | CHAR | 10 | 0 | SKA1 | KTZINB | |
| KTZING | Expense Account for Interest over Zero | CHAR | 10 | 0 | SKA1 | KTZING | |
| KTZINU | Expense Account: Interest Below Zero | CHAR | 10 | 0 | SKA1 | KTZINU | |
| KTMAFB | Value Adjustment Account for Transferred Reserves | CHAR | 10 | 0 | SKA1 | KTMAFB | |
| KTMAFG | Contra Account for Transferring Reserves | CHAR | 10 | 0 | SKA1 | KTMAFG | |
| KTAUNB | Accumulated Depreciation Account: Revaluation of Ord.Deprec. | CHAR | 10 | 0 | SKA1 | KTAUNB | |
| KTAUNG | Offsetting Account: Revaluation of Ordinary Depreciation | CHAR | 10 | 0 | SKA1 | KTAUNG | |
| KTNZUS | Revenue Account for Write-Up on Ordinary Depreciation | CHAR | 10 | 0 | SKA1 | KTNZUS | |
| KTSZUS | Revenue Account for Write-Up to Special Depreciation | CHAR | 10 | 0 | SKA1 | KTSZUS | |
| KTAZUS | Revenue Account for Write-Up on Unplanned Depreciation | CHAR | 10 | 0 | SKA1 | KTAZUS | |
| KTMZUS | Rev. Account: Write-Up on Transfer of Reserves | CHAR | 10 | 0 | SKA1 | KTMZUS |
T095B foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T095B | KTAAFB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTAAFB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTAAFB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTAAFG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTAAFG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTAAFG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTAAFU | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTAAFU | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTAAFU | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTAUNB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTAUNB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTAUNB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTAUNG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTAUNG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTAUNG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTAZUS | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTAZUS | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTAZUS | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTMAFB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTMAFB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTMAFB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTMAFG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTMAFG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTMAFG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTMZUS | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTMZUS | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTMZUS | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTNAFB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTNAFB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTNAFB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTNAFG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTNAFG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTNAFG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTNAFU | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTNAFU | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTNAFU | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTNZUS | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTNZUS | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTNZUS | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTOGR | T095A | Account allocation | MANDT |
| 1 T095B | KTOGR | T095A | Account allocation | KTOGR |
| 0 T095B | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 1 T095B | KTSAFB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTSAFB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTSAFB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTSAFG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTSAFG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTSAFG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTSAFU | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTSAFU | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTSAFU | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTSZUS | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTSZUS | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTSZUS | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTZINB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTZINB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTZINB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | KTZING | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095B | KTZING | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095B | KTZING | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095B | KTZINU | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095B | KTZINU | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095B | KTZINU | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095B | MANDT | T000 | Clients | MANDT |