SAP ABAP View V_THM_TRANS_IR (LDB Hedge: IR Exposure Transactions)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI_LDB (Package) Logical Databases for the R/3 CFM Information System

Basic Data

View Type	D	Database View
Database View	V_THM_TRANS_IR
Short Description	LDB Hedge: IR Exposure Transactions
Root table	THMEXT_TRANS	Hedge Management: Transactions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	THMEXT_TRANS	THMEXT_TRANS
2	THMEXT_TRANS_IR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	THMEXT_TRANS	MANDT	JL	EQ				0	0
2	THMEXT_TRANS_IR	MANDT	JR	EQ			AND	0	0
3	THMEXT_TRANS	BUKRS	JL	EQ				0	0
4	THMEXT_TRANS_IR	BUKRS	JR	EQ			AND	0	0
5	THMEXT_TRANS	PLANNERID	JL	EQ				0	0
6	THMEXT_TRANS_IR	PLANNERID	JR	EQ			AND	0	0
7	THMEXT_TRANS	TRANSACTIONID	JL	EQ				0	0
8	THMEXT_TRANS_IR	TRANSACTIONID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	THMEXT_TRANS	MANDT		☐	MANDT	☐	Client
2	BUKRS	THMEXT_TRANS	BUKRS		☐	BUKRS	☐	Company Code
3	HEDGEPLAN_ID	THMEXT_TRANS	PLANNERID		☐	THM_PLANNERID	☐	Hedge Management: Hedge Plan ID
4	EXPOSURE_ID	THMEXT_TRANS	EXPOSUREID		☐	THM_EXPOSUREID	☐	Hedge Management: Exposure ID
5	TRANSACTION_ID	THMEXT_TRANS	TRANSACTIONID		☐	THM_TRANSACTION	☐	Hedge Management: Transaction
6	CREATEDATE	THMEXT_TRANS_IR	CREATEDATE		☐	THM_TRANS_CRDATE	☐	Hedge Management: Date the transaction is created
7	INTRATE_REF_T_IR	THMEXT_TRANS_IR	INTRATE_REF		☐	SZSREF	☐	Reference Interest Rate
8	INTRATE_ADJ_T_IR	THMEXT_TRANS_IR	INTRATE_ADJ		☐	VVDPKOND	☐	Determination date for percentage rate of condition items
9	INTC_START_T_IR	THMEXT_TRANS_IR	INTCALC_START		☐	DBERVON	☐	Start of Calculation Period
10	INTC_END_T_IR	THMEXT_TRANS_IR	INTCALC_END		☐	DBERBIS	☐	End of Calculation Period
11	INTC_METHOD_T_IR	THMEXT_TRANS_IR	INTCALC_METHOD		☐	SZBMETH	☐	Interest Calculation Method
12	INTC_TIMEBS_T_IR	THMEXT_TRANS_IR	INTCALC_TIMEBAS		☐	ABASTAGE	☐	Number of base days in a calculation period
13	INTC_DAYS_T_IR	THMEXT_TRANS_IR	INTCALC_DAYS		☐	ATAGE	☐	Workdays
14	INTC_KALID_T_IR	THMEXT_TRANS_IR	INTCALC_KALID		☐	SKALID	☐	Factory calendar
15	INTC_AMNT_T_IR	THMEXT_TRANS_IR	INTCALC_AMNT		☐	BBWHR	☐	Amount in position currency
16	INTRATE_FIX_T_IR	THMEXT_TRANS_IR	INTRATE_FIX		☐	TB_PKOND	☐	Interest rate as a percentage
17	INTRATE_SGN_T_IR	THMEXT_TRANS_IR	INTRATE_SIGN		☐	THA_SIGN_SOFFSET	☐	+/- Sign of Interest Rate Spread
18	FLG_INT_AMT_T_IR	THMEXT_TRANS_IR	FLG_INT_AMOUNT		☐	THM_FLG_INTAMOUNT	☐	Hedge Management: Flag Interest Amount
19	INTRATE_OFF_T_IR	THMEXT_TRANS_IR	INTRATE_SOFFSET		☐	TV_SOFFSET	☐	Fixer offset for variable interest rate reference
20	INTRATE_REG_T_IR	THMEXT_TRANS_IR	INTRATE_REGI		☐	TB_IRA_REGISTRATION_STATE	☐	Status of Interest Rate Adjustment
21	CURRENCY	THMEXT_TRANS_IR	CURRENCY		☐	THM_TRANSCURRENCY	☐	Hedge Management: Transaction Currency
22	TEXT50	THMEXT_TRANS	TEXT50		☐	THA_TRANSTEXT	☐	Description of the Exposure Transaction
23	TRANS_AMOUNT	THMEXT_TRANS_IR	AMOUNT		☐	THM_TRANSAMOUNT	☐	Hedge Management: Transaction Amount
24	VALID_FROM	THMEXT_TRANS_IR	VALID_FROM		☐	THM_TRANS_VALIDFROM	☐	Hedge Management: Valid-from date of the transaction

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in