SAP table THMEXT_PLANNER (E-HA: Hedge Plan)
SAP table THMEXT_PLANNER has 3 primary key fields being MANDT,BUKRS,PLANNERID.
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
Client
CLNT
3
0
T000
MANDT
Company Code
CHAR
4
0
T001
BUKRS
Hedge Plan ID
CHAR
13
0
THM_PLANNERID
TEXT
Description of Hedge Plan
CHAR
50
0
THA_PLANNERTEXT
RISKCAT
Hedge Risk Category
NUMC
2
0
THM_RISKCAT
Possible values
01
Exchange Rate Risk
02
Interest Rate Risk
03
Commodity Price Risk
STARTTERM
Start of Term of Hedge Plan
DATS
8
0
THM_STARTTERM
ENDTERM
End of Term of Hedge Plan
DATS
8
0
THM_ENDTERM
CRUSER
Entered By
CHAR
12
0
TB_CRUSER
CDATE
Date
DATS
8
0
DATUM
UPUSER
Last Changed By
CHAR
12
0
TB_UPUSER
UDATE
Date
DATS
8
0
DATUM
TIME
Time
TIMS
6
0
UZEIT
LASTEXPOSUREID
Exposure ID
NUMC
5
0
THM_EXPOSUREID
SINGLEHEDGE
Indicator: Assign All Exposures to One Single Hedge
CHAR
1
0
THM_SINGLEHEDGE
NOMINAL
Nominal Amount (E-HA)
CURR
17
2
THM_TRANSAMOUNT
CURRENCY
Nominal Amount Currency
CUKY
5
0
TCURC
THM_TRANSCURRENCY
RFHA
Financial Transaction
CHAR
13
0
VTBFHA
TB_RFHA
RO_FLAG
E-HA Data Created via External Exposure Data
CHAR
1
0
THM_RO_FLAG
LOANS_CONTRACT
Contract Number
CHAR
13
0
RANL
PLAN_STATUS
Hedge Plan Status
NUMC
2
0
THA_PLAN_STATUS
Possible values
00
Active
01
Reclassification Selected
HP_GROUP
Hedge Plan Grouping
CHAR
30
0
THA_GROUP
HP_PROGRAM
Hedge Plan Program
CHAR
30
0
THA_PROGRAM
THMEXT_PLANNER foreign key relationships
Table
Field
Check Table
Check Field
0 THMEXT_PLANNER
BUKRS
T001 Company Codes
BUKRS
1 THMEXT_PLANNER
CURRENCY
TCURC Currency Codes
WAERS
0 THMEXT_PLANNER
RFHA
VTBFHA Transaction
BUKRS
0 THMEXT_PLANNER
RFHA
VTBFHA Transaction
RFHA