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