SAP table T030 (Standard Accounts Table)
SAP table T030 has 6 primary key fields being MANDT,KTOPL,KTOSL,BWMOD,KOMOK,BKLAS.
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 | Transaction Key | CHAR | 3 | 0 | KTOSL | ||
| BWMOD | Valuation Grouping Code | CHAR | 4 | 0 | BWMOD | ||
| KOMOK | Account Modification | CHAR | 3 | 0 | KOMOK | ||
| BKLAS | Valuation Class | CHAR | 4 | 0 | T025 | BKLAS | |
| KONTS | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR | |
| KONTH | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR |
T030 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T030 | BKLAS | T025 | Valuation Classes | MANDT |
| 0 T030 | BKLAS | T025 | Valuation Classes | BKLAS |
| 1 T030 | KONTH | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030 | KONTH | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030 | KONTH | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030 | KONTS | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T030 | KONTS | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T030 | KONTS | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T030 | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 0 T030 | MANDT | T000 | Clients | MANDT |