SAP table T095P (Reconcil.accts. derived dep. areas)
SAP table T095P has 5 primary key fields being MANDT,KTOPL,KTOGR,AFASL,AFABER.
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 | MANDT | ||
| KTOPL | Chart of Accounts | CHAR | 4 | 0 | T004 | KTOPL | |
| KTOGR | Account Determination | CHAR | 8 | 0 | T095A | KTOGR | |
| AFASL | Depreciation key | CHAR | 4 | 0 | T090NA | AFASL | |
| AFABER | Depreciation Area Real or Derived | NUMC | 2 | 0 | FAAV_DEPR_AREA | AFABER | |
| KTSOPO | Spec.res. Balance sheet account | CHAR | 10 | 0 | SKA1 | KTSOPO | |
| KTSEIN | Exp. acct: Allocation to special reserves | CHAR | 10 | 0 | SKA1 | KTSEIN | |
| KTNAUF | P&L account:Write-off spec.reserves w/ gross allocation | CHAR | 10 | 0 | SKA1 | KTNAUF | |
| KTSAUF | Rev. acct: Amortiz. special reserves | CHAR | 10 | 0 | SKA1 | KTSAUF | |
| KTSABG | Rev. acct: Amortiz. spec.reserves after retirement | CHAR | 10 | 0 | SKA1 | KTSABG | |
| KTZUSA | Rev. Account: Write-Up on Special Reserves | CHAR | 10 | 0 | SKA1 | KTZUSA | |
| KTMEHR | G/L Account: Asset Retirement Gain | CHAR | 10 | 0 | SKA1 | KTMEHR | |
| KTMIND | G/L Account for Asset Retirement Loss | CHAR | 10 | 0 | SKA1 | KTMIND | |
| KTVBAB | Clearing acct.revenue from sale to affiliated company | CHAR | 10 | 0 | SKA1 | KTVBAB |
T095P foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T095P | AFABER | FAAV_DEPR_AREA | Generated Table for View | DEPR_AREA |
| 1 T095P | AFASL | T090NA | Depreciation Keys | MANDT |
| 1 T095P | AFASL | T090NA | Depreciation Keys | AFAPL |
| 1 T095P | AFASL | T090NA | Depreciation Keys | AFASL |
| 0 T095P | KTMEHR | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095P | KTMEHR | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095P | KTMEHR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095P | KTMIND | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095P | KTMIND | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095P | KTMIND | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095P | KTNAUF | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095P | KTNAUF | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095P | KTNAUF | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095P | KTOGR | T095A | Account allocation | MANDT |
| 1 T095P | KTOGR | T095A | Account allocation | KTOGR |
| 0 T095P | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 1 T095P | KTSABG | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095P | KTSABG | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095P | KTSABG | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095P | KTSAUF | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095P | KTSAUF | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095P | KTSAUF | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095P | KTSEIN | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095P | KTSEIN | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095P | KTSEIN | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095P | KTSOPO | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095P | KTSOPO | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095P | KTSOPO | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T095P | KTVBAB | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T095P | KTVBAB | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T095P | KTVBAB | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T095P | KTZUSA | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T095P | KTZUSA | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T095P | KTZUSA | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |