THMHRT_ASS_RETRO SAP (Retrospective effectiveness assessment result) Table details
Dictionary Type: Table
Description: Retrospective effectiveness assessment result
Description: Retrospective effectiveness assessment result
ABAP Code to SELECT data from THMHRT_ASS_RETRO
Related tables to THMHRT_ASS_RETRO
Access table THMHRT_ASS_RETRO
Related tables to THMHRT_ASS_RETRO
Access table THMHRT_ASS_RETRO
Table field list including key, data, relationships and ABAP select examples
THMHRT_ASS_RETRO is a standard SAP Table which is used to store Retrospective effectiveness assessment result data and is available within R/3 SAP systems depending on the version and release level.
The THMHRT_ASS_RETRO table consists of various fields, each holding specific information or linking keys about Retrospective effectiveness assessment result data available in SAP. These include BUKRS (Company Code), RFHA (Financial Transaction), HEDGE_ID (Identification Number of Hedge Item), TEST_DATE (Date of calculation).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP THMHRT_ASS_RETRO table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
| HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | THMT_HEDGE_ITEM | THM_HEDGE_ID | HEDGEID | ||
| TEST_DATE | Date of calculation | THM_CALCULATION_DATE | DATS | 8 | DATUM | KEYDATE | |||
| CALC_DATE | Date of calculation | THM_CALCULATION_DATE | DATS | 8 | DATUM | KEYDATE | |||
| HR_VERSION | Version of the hedging relationship | THM_HR_VERSION | NUMC | 3 | THMHRT_HR | THM_HR_VERSION | |||
| CALC_TYPE | Calculation type | THM_CALC_TYPE | CHAR | 3 | THMT_CALC_TYPES | THM_CALC_TYPE | |||
| CURRENCY_DELTA | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| DELTA_DERIVATIVE | Delta in derivative cash flows | THM_DELTA_DERIVATIVE | CURR | 17(2) | WERTV9 | ||||
| SUM_DELTA_DERIV | Sum of delta in derivatives cash flows | THM_SUM_DELTA_DERIVATIVE | CURR | 17(2) | WERTV9 | ||||
| DELTA_HEDGE | Delta in hedge item cash flows | THM_DELTA_HEDGE | CURR | 17(2) | WERTV9 | ||||
| SUM_DELTA_HEDGE | Sum of delta in hedge item cash flows | THM_SUM_DELTA_HEDGE | CURR | 17(2) | WERTV9 | ||||
| EFFECT_RATIO | Effectiveness ratio | THM_EFFECTIVENESS_RATIO | DEC | 10(7) | DECV3_7 | ||||
| TEST_RESULT | Numeric 1-character | NUM1 | NUMC | 1 | NUM1 | ||||
| THRESHOLD | Threshold for Effectiveness Calculation in Percent | THA_THRESHOLD | DEC | 5(3) | PRZ23 | ||||
| TRANS_SPEED | Transition Speed for Effectiveness Calculation | THA_TRANS_SPEED | DEC | 5(2) | THA_TRANS_SPEED | ||||
| LOGUUID | E-HA: Detail Log UUID | THA_LOGUUID | RAW | 16 | UUID | ||||
| LOG_ARCHIVED | Has the log been archived? | THA_LOG_ARCHIVED | CHAR | 1 | FLAG | ||||
| ARCHIVE_NAME | Key for Archive File | ARKEY | CHAR | 20 | ARKEY | ||||
| EFF_TEST_REF | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID |
| Key field | Non-key field |
How do I retrieve data from SAP table THMHRT_ASS_RETRO using ABAP code
The following ABAP code Example will allow you to do a basic selection on THMHRT_ASS_RETRO to SELECT all data from the tableDATA: WA_THMHRT_ASS_RETRO TYPE THMHRT_ASS_RETRO.
SELECT SINGLE *
FROM THMHRT_ASS_RETRO
INTO CORRESPONDING FIELDS OF WA_THMHRT_ASS_RETRO
WHERE...
How to access SAP table THMHRT_ASS_RETRO
Within an ECC or HANA version of SAP you can also view further information about THMHRT_ASS_RETRO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects