SAP Table THMT_HEDGE_ITEM
Hedged Item
THMT_HEDGE_ITEM (Hedged Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link THMT_HEDGE_ITEM to other SAP tables.
THMT_HEDGE_ITEM table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | 0 | |||||||||
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | 0 | |||||||||
CRUSER | Entered by | TB_CRUSER | CHAR | 12 | 0 | |||||||||
UPUSER | Last Changed by | TB_UPUSER | CHAR | 12 | 0 | |||||||||
H_CR_DATE | Create date of the hedge | THM_H_CR_DATE | DATS | 8 | 0 | |||||||||
H_CH_DATE | Change date of the hedge | THM_H_CH_DATE | DATS | 8 | 0 | |||||||||
HEDGE_CAT | Hedge category | THM_HEDGE_CATEGORY | NUMC | 2 | 0 |
Possible values
|
||||||||
TARGET_RATIO | Target ratio of the hedge item | THM_HEDGE_RATIO_TARGET | DEC | 5 | 2 |
Possible values
|
||||||||
ACTUAL_RATIO | Actual ratio of the hedge item | THM_HEDGE_RATIO_ACTUAL | DEC | 5 | 2 |
Possible values
|
||||||||
NOMINAL | Nominal amount of the hedge item | THM_HEDGE_NOMINAL | CURR | 17 | 2 | |||||||||
CURRENCY | Currency of the hedge item | THM_HEDGE_CURRENCY | TCURC | CUKY | 5 | 0 | ||||||||
PLANNER_ID | Hedge Plan ID | THM_PLANNERID | THMEXT_PLANNER | CHAR | 13 | 0 | ||||||||
HEDGE_ID_ROLL | Rolled hedge ID | THM_HED_ID_ROLL | NUMC | 10 | 0 | |||||||||
YTM | Yield-to-maturity of the hedged item | THM_YTM | DEC | 10 | 7 | |||||||||
START_RECL_PL | Start of Reclassification of Equity Capital | THA_START_RECL_PL | DATS | 8 | 0 | |||||||||
END_RECL_PL | End of Reclassification of Equity Capital | THA_END_RECL_PL | DATS | 8 | 0 | |||||||||
QUANTITY | Quantity of the hedged item | THA_HEDGE_QUANTITY | QUAN | 15 | 3 | |||||||||
UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | 0 | |||||||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | 0 |
THMT_HEDGE_ITEM foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
THMT_HEDGE_ITEM | BUKRS | * | T001 | Company Codes | MANDT | |
THMT_HEDGE_ITEM | BUKRS | THMT_HEDGE_ITEM | BUKRS | T001 | Company Codes | BUKRS |
THMT_HEDGE_ITEM | CURRENCY | THMT_HEDGE_ITEM | MANDT | TCURC | Currency Codes | MANDT |
THMT_HEDGE_ITEM | CURRENCY | THMT_HEDGE_ITEM | CURRENCY | TCURC | Currency Codes | WAERS |
THMT_HEDGE_ITEM | MANDT | THMT_HEDGE_ITEM | MANDT | T000 | Clients | MANDT |
THMT_HEDGE_ITEM | PLANNER_ID | THMT_HEDGE_ITEM | BUKRS | THMEXT_PLANNER | E-HA: Hedge Plan | BUKRS |
THMT_HEDGE_ITEM | PLANNER_ID | THMT_HEDGE_ITEM | PLANNER_ID | THMEXT_PLANNER | E-HA: Hedge Plan | PLANNERID |
THMT_HEDGE_ITEM | PLANNER_ID | * | THMEXT_PLANNER | E-HA: Hedge Plan | MANDT |