SAP table T030K (Tax Accounts Determination)
SAP table T030K has 5 primary key fields being MANDT,KTOPL,KTOSL,MWSKZ,LAND1.
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 | |
| KTOSL | Internal processing key | CHAR | 3 | 0 | T007B | KTOSL_007B | |
| MWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | T007A | MWSKZ | |
| LAND1 | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| KONTS | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR | |
| KONTH | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR |
T030K foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T030K | KONTH | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T030K | KONTH | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T030K | KONTH | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T030K | KONTS | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030K | KONTS | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030K | KONTS | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030K | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 1 T030K | KTOSL | T007B | Tax Processing in Accounting | MANDT |
| 1 T030K | KTOSL | T007B | Tax Processing in Accounting | KTOSL |
| 0 T030K | LAND1 | T005 | Countries | MANDT |
| 0 T030K | LAND1 | T005 | Countries | LAND1 |
| 1 T030K | MANDT | T000 | Clients | MANDT |
| 0 T030K | MWSKZ | T007A | Tax Keys | KALSM |
| 0 T030K | MWSKZ | T007A | Tax Keys | MWSKZ |