SAP table T030H (Acct Determ.for Open Item Exch.Rate Differences)
SAP table T030H has 5 primary key fields being MANDT,KTOPL,HKONT,WAERS,CURTP.
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 | |
| HKONT | General Ledger Account | CHAR | 10 | 0 | SKA1 | HKONT | |
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| CURTP | Currency Type | CHAR | 2 | 0 | FINSC_CURTYPE | FINS_CURTYPE | |
| LKORR | Local Account for Adjusting Receivables/Payables | CHAR | 10 | 0 | SKA1 | LKORR | |
| LSREA | Local Account for Realized Exchange Rate Losses | CHAR | 10 | 0 | SKA1 | LSREA | |
| LHREA | Local Account for Realized Exchange Rate Gains | CHAR | 10 | 0 | SKA1 | LHREA | |
| LSTRA | Local Account for Loss from Translation | CHAR | 10 | 0 | SKA1 | LSTRA | |
| LHTRA | Local Account for Gain from Translation | CHAR | 10 | 0 | SKA1 | LHTRA | |
| LSBEW | Local Account for Loss from Valuation | CHAR | 10 | 0 | SKA1 | LSBEW | |
| LHBEW | Local Account for Gain from Valuation | CHAR | 10 | 0 | SKA1 | LHBEW | |
| LSTRV | Local Account for Clearing Translation Gain | CHAR | 10 | 0 | SKA1 | LSTRV | |
| LHTRV | Local Account for Clearing Translation Loss | CHAR | 10 | 0 | SKA1 | LHTRV |
T030H foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T030H | CURTP | FINSC_CURTYPE | Currency type | CURTYPE |
| 1 T030H | HKONT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030H | HKONT | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030H | HKONT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030H | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 1 T030H | LHBEW | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030H | LHBEW | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030H | LHBEW | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030H | LHREA | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T030H | LHREA | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T030H | LHREA | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T030H | LHTRA | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030H | LHTRA | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030H | LHTRA | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030H | LHTRV | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T030H | LHTRV | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T030H | LHTRV | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T030H | LKORR | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030H | LKORR | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030H | LKORR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030H | LSBEW | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T030H | LSBEW | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T030H | LSBEW | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T030H | LSREA | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030H | LSREA | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030H | LSREA | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030H | LSTRA | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 T030H | LSTRA | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 T030H | LSTRA | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 T030H | LSTRV | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 T030H | LSTRV | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 T030H | LSTRV | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 T030H | MANDT | T000 | Clients | MANDT |
| 1 T030H | WAERS | TCURC | Currency Codes | MANDT |
| 1 T030H | WAERS | TCURC | Currency Codes | WAERS |