SAP THAEXS_TRANS_ALV Table in S/4 HANA - Display Structure for Exposure Transaction
THAEXS_TRANS_ALV is a standard SAP Table which is used to store Display Structure for Exposure Transaction data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the THAEXS_TRANS_ALV table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: THAEXS_TRANS_ALV
THAEXS_TRANS_ALV table structure field list
Below is the full THAEXS_TRANS_ALV field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
| PLANNERID | Hedge Plan ID | THM_PLANNERID | CHAR | 13(0) | THMEXT_PLANNER | ALPHA | THM_PLANNERID | PLN | ||
| TRANSACTIONID | E-HA: Transaction | THM_TRANSACTION | CHAR | 11(0) | Assigned to domain | ALPHA | THM_TRANSACTION | |||
| TEXT50 | Description of the Exposure Transaction | THA_TRANSTEXT | CHAR | 50(0) | TEXT50 | |||||
| EXPOSUREID | Exposure ID | THM_EXPOSUREID | NUMC | 5(0) | THMEXT_EXPOS | THM_EXPOSUREID | ||||
| TRANSCAT | Transaction Category (E-HA) | THM_TRANSCAT | NUMC | 2(0) | THMEXTS_CATEGORY | THM_TRANSCAT | ||||
| TRANSACTIVITY | Transaction Activity (E-HA) | THM_TRANSACT | NUMC | 2(0) | THMEXTS_ACTIVITY | THM_TRANSACT | ||||
| REFERENCE | Reference (E-HA) | THM_REFERENCE | CHAR | 16(0) | CHAR16 | |||||
| TRANS_STATUS | Transaction Status (E-HA) | THA_TRANS_STATUS | NUMC | 2(0) | THA_TRANS_STATUS | |||||
| TRANS_ORIGIN | Origin of Exposure Transaction | THA_TRANS_ORIGIN | CHAR | 1(0) | THA_TRANS_ORIGIN | |||||
| NEW_TRANSACT | Transaction Activity (E-HA) | THM_TRANSACT | NUMC | 2(0) | Assigned to domain | THM_TRANSACT | ||||
| CREATEDATE | E-HA: Date the Transaction is Created | THM_TRANS_CRDATE | DATS | 8(0) | TPM_POSITION_DATE | |||||
| TRANSDATE | E-HA: Date the Transaction is Related to | THM_TRANS_DUEDATE | DATS | 8(0) | TPM_POSITION_DATE | |||||
| AMOUNT | Nominal Amount (E-HA) | THM_TRANSAMOUNT | CURR | 17(2) | THM_TRANSAMOUNT | |||||
| CURRENCY | Nominal Amount Currency | THM_TRANSCURRENCY | CUKY | 5(0) | Assigned to domain | WAERS | ||||
| RATE | FX Rate for Transaction (E-HA) | THM_TRANSRATE | DEC | 13(9) | TB_KKURS | |||||
| VALID_FROM | Valid-From Date of the Transaction (E-Hedge Accounting) | THM_TRANS_VALIDFROM | DATS | 8(0) | TPM_POSITION_DATE | |||||
| AMOUNT_NEW | New Transaction Amount (E-HA) | THA_TRANSAMOUNT_NEW | CURR | 17(2) | THM_TRANSAMOUNT | |||||
| INTRATE_REF | Reference Interest Rate | SZSREF | CHAR | 10(0) | Assigned to domain | ZIREFKU | ||||
| INTRATE_ADJ | Fixing Date of Percentage Rate from Condition | VVDPKOND | DATS | 8(0) | DATUM | |||||
| INTCALC_START | Start of Calculation Period | DBERVON | DATS | 8(0) | DATUM | |||||
| INTCALC_END | End of Calculation Period | DBERBIS | DATS | 8(0) | DATUM | |||||
| INTCALC_METHOD | Interest Calculation Method | SZBMETH | CHAR | 1(0) | SZBMETH | |||||
| INTCALC_TIMEBAS | Number of base days in a calculation period | ABASTAGE | NUMC | 6(0) | INT6 | |||||
| INTCALC_DAYS | Workdays | ATAGE | INT2 | 5(0) | ATAGE | |||||
| INTCALC_KALID | Factory calendar | SKALID | CHAR | 2(0) | Assigned to domain | WFCID | H_TFACD | IDENT | ||
| INTCALC_AMNT | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | |||||
| INTRATE_FIX | Interest rate as a percentage | TB_PKOND | DEC | 10(7) | DECV3_7 | |||||
| INTRATE_SIGN | +/- Sign of Interest Rate Spread | THA_SIGN_SOFFSET | CHAR | 1(0) | THA_SIGN_SOFFSET | |||||
| FLG_INT_AMOUNT | Indicate Interest Amount (E-Hedge Accounting) | THM_FLG_INTAMOUNT | CHAR | 1(0) | THM_FLG_INTAMOUNT | |||||
| INTRATE_SOFFSET | Fixer offset for variable interest rate reference | TV_SOFFSET | DEC | 10(7) | DECV3_7 | |||||
| INTRATE_REGI | Status of Interest Rate Adjustment | TB_IRA_REGISTRATION_STATE | CHAR | 2(0) | T_IRA_REGISTRATION_STATE | |||||
| QUANTITY | Exposure quantity | THA_EXP_QUANTITY | QUAN | 13(3) | FTR_QUAN | |||||
| UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 18(0) | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | COMMODITY_ID | ||
| QUANTITY_NEW | Exposure quantity | THA_EXP_QUANTITY | QUAN | 13(3) | FTR_QUAN |
Search for further information about these or an SAP related objects