SAP Table
T030S Accts for Foreign Currency Assets Exchange Rate Differences
SAP table T030S has 4 primary key fields being MANDT,KTOPL,KDFSL,CURTP.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T030S columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyKTOPL | Chart of Accounts | CHAR | 4 | 0 | T004 | KTOPL | |
| KeyKDFSL | Key for Exchange Rate Differences in Foreign Currency Accts | CHAR | 4 | 0 | KDFSL | ||
| KeyCURTP | Valuation Area for FI Year-End Closing | CHAR | 2 | 0 | T033 | BWBER | |
| KSOLL | Account for Losses from Exchange Rate Changes | CHAR | 10 | 0 | SKA1 | KSOLL | |
| KHABN | Account for Gains from Exchange Rate Changes | CHAR | 10 | 0 | SKA1 | KHABN | |
| GSOLL | Expense Account for Losses from Rolling Valuation | CHAR | 10 | 0 | SKA1 | GSOLL | |
| GHABN | Revenue Account for Gains from Rolling Valuation | CHAR | 10 | 0 | SKA1 | GHABN |
/ Relationships
T030S foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T030S | CURTP | T033 | FI Depreciation Area | BWBER |
| T030S | GHABN | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| T030S | GHABN | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| T030S | GHABN | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| T030S | GSOLL | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| T030S | GSOLL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| T030S | GSOLL | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| T030S | KHABN | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| T030S | KHABN | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| T030S | KHABN | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| T030S | KSOLL | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| T030S | KSOLL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| T030S | KSOLL | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| T030S | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| T030S | MANDT | T000 | Clients | MANDT |