SAP table T095 (Balance sheet accounts for depreciation areas)
SAP table T095 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 | FAAV_DEPR_AREA | AFABE_D | |
| KTANSW | Bal. Sheet Account: Acquisition and Production Costs | CHAR | 10 | 0 | SKA1 | KTANSW | |
| KTANZA | G/L Account:Down Payments | CHAR | 10 | 0 | SKA1 | KTANZA | |
| KTERLW | Clearing Account for Revenue from Asset Sale | CHAR | 10 | 0 | SKA1 | KTERLW | |
| KTMEHR | G/L Account: Asset Retirement Gain | CHAR | 10 | 0 | SKA1 | KTMEHR | |
| KTMAHK | Acct:Gain from Asset Retirement over APC (Curr. Not Used) | CHAR | 10 | 0 | SKA1 | KTMAHK | |
| KTMIND | G/L Account for Asset Retirement Loss | CHAR | 10 | 0 | SKA1 | KTMIND | |
| KTREST | G/L Account for Net Book Value When Scrapped | CHAR | 10 | 0 | SKA1 | KTREST | |
| KTAPFG | G/L Account:Decimals from Asset Acquisition: Not Used | CHAR | 10 | 0 | SKA1 | KTADEC | |
| KTAUFW | Reconciliation Account: Revaluation | CHAR | 10 | 0 | SKA1 | KTAUFW | |
| KTAUFG | Offsetting Account for Revaluation | CHAR | 10 | 0 | SKA1 | KTAUFG | |
| KTANSG | Contra account: Acquisition value posting | CHAR | 10 | 0 | SKA1 | KTANSG | |
| KTANZG | Contra account: Down payment posting | CHAR | 10 | 0 | SKA1 | KTANZG | |
| KTVBAB | Clearing acct.revenue from sale to affiliated company | CHAR | 10 | 0 | SKA1 | KTVBAB | |
| KTVZU | Clearing acct: Acquisition from affiliated company | CHAR | 10 | 0 | SKA1 | KTVBZU | |
| KTVIZU | Clearing Account for Allocation of Investment Support | CHAR | 10 | 0 | SKA1 | KTVIZU | |
| KTRIZU | Clearing Account for Repaying Investment Support | CHAR | 10 | 0 | SKA1 | KTVRIZ | |
| KTARIZ | Expense Account:Repayment of Investment Support | CHAR | 10 | 0 | SKA1 | KTARIZ | |
| KTVERK | G/L acct for costs of sale | CHAR | 10 | 0 | KTVERK | ||
| KTCOAB | Cost element for settlement of asset u. cons. to CO objects | CHAR | 10 | 0 | SKA1 | KTCOAB | |
| KTENAK | Revenue account for post-capitaliz. of asset | CHAR | 10 | 0 | SKA1 | KTENAK | |
| KTNAIB | Account for capitalization differences/nonoperating expense | CHAR | 10 | 0 | SKA1 | KTNAIB |
T095 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T095 | AFABE | FAAV_DEPR_AREA | Generated Table for View | DEPR_AREA |
| 1 T095 | KTANSG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTANSG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTANSG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTANSW | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTANSW | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTANSW | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTANZA | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTANZA | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTANZA | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTANZG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTANZG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTANZG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTAPFG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTAPFG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTAPFG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTARIZ | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTARIZ | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTARIZ | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTAUFG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTAUFG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTAUFG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTAUFW | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTAUFW | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTAUFW | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTCOAB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTCOAB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTCOAB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTENAK | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTENAK | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTENAK | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTERLW | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTERLW | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTERLW | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTMAHK | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTMAHK | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTMAHK | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTMEHR | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTMEHR | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTMEHR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTMIND | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTMIND | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTMIND | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTNAIB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTNAIB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTNAIB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTOGR | T095A | Account allocation | MANDT |
| 0 T095 | KTOGR | T095A | Account allocation | KTOGR |
| 1 T095 | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 0 T095 | KTREST | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTREST | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTREST | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTRIZU | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTRIZU | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTRIZU | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTVBAB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTVBAB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTVBAB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | KTVIZU | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095 | KTVIZU | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095 | KTVIZU | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095 | KTVZU | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095 | KTVZU | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095 | KTVZU | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095 | MANDT | T000 | Clients | MANDT |