SAP table THMT_HEDGE_ITEM (Hedged Item)

SAP table THMT_HEDGE_ITEM has 3 primary key fields being MANDT,BUKRS,HEDGE_ID.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
HEDGE_ID Identification Number of Hedged Item NUMC 10 0 THM_HEDGE_ID
VALUATION_AREA Treasury Valuation Area CHAR 3 0 TPM_VAL_AREA
CRUSER Entered By CHAR 12 0 TB_CRUSER
UPUSER Last Changed By CHAR 12 0 TB_UPUSER
H_CR_DATE Create date of the hedge DATS 8 0 THM_H_CR_DATE
H_CH_DATE Change date of the hedge DATS 8 0 THM_H_CH_DATE
HEDGE_CAT Hedge Category NUMC 2 0 THM_HEDGE_CATEGORY
01 Cash flow hedge
02 Fair value hedge
03 Net Investment hedge
TARGET_RATIO Target Ratio of the Hedged Item DEC 5 2 THM_HEDGE_RATIO_TARGET
ACTUAL_RATIO Actual Ratio of the Hedged Item DEC 5 2 THM_HEDGE_RATIO_ACTUAL
NOMINAL Amount of the Hedged Item CURR 17 2 THM_HEDGE_NOMINAL
CURRENCY Currency of the Hedged Item CUKY 5 0 TCURC THM_HEDGE_CURRENCY
PLANNER_ID Hedge Plan ID CHAR 13 0 THMEXT_PLANNER THM_PLANNERID
HEDGE_ID_ROLL Reference Hedged Item ID NUMC 10 0 THM_HED_ID_ROLL
YTM Yield-to-maturity of the hedged item DEC 10 7 THM_YTM
START_RECL_PL Start of Reclassification of Equity Capital DATS 8 0 THA_START_RECL_PL
END_RECL_PL End of Reclassification of Equity Capital DATS 8 0 THA_END_RECL_PL
QUANTITY Quantity of the hedged item QUAN 15 3 THA_HEDGE_QUANTITY
UNIT_OF_MEASURE Unit of Measure for the Commodity UNIT 3 0 TPM_CTY_UOM
COMMODITY_ID Commodity ID (obsolete) CHAR 18 0 TRCO_COMM_ID
HR_STRATEGY E-HA: Hedge Strategy NUMC 4 0 THM_HRSTRATEGY
BUCKET_INDICATOR Exposure Bucket Processing CHAR 1 0 THM_BUCKET_INDICATOR
DESCRIPTION Description of a hedged item CHAR 50 0 THM_HEDGE_DESCRIPTION

THMT_HEDGE_ITEM foreign key relationships

Table Field Check Table Check Field
0 THMT_HEDGE_ITEM BUKRS T001 Company Codes BUKRS
1 THMT_HEDGE_ITEM CURRENCY TCURC Currency Codes WAERS
0 THMT_HEDGE_ITEM PLANNER_ID THMEXT_PLANNER E-HA: Hedge Plan BUKRS