SAP ABAP Table VTG_IRATE_DERIV (TR_Transaction Management: FHA Worklist Toolbox)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-TR (Application Component) Transaction Management
     ⤷ FTTR (Package) Treasury: Financial Transaction

Basic Data

Table Category	INTTAB	Structure
Structure	VTG_IRATE_DERIV	Table Relationship Diagram
Short Description	TR_Transaction Management: FHA Worklist Toolbox

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	TR Transaction Management: Transaction Display Structure
2	.INCLUDE	☐				0	0	Transaction
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
6	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
7	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
8	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
9	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
10	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
11	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
12	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
13	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
14	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
15	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
16	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
17	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
18	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
19	RFHAZUNR	☐	TB_RFHAZUN	T_RFHAZU	NUMC	5	0	Number status of activity
20	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
21	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
22	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
23	SROLEXT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
24	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
25	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
26	RREFKONT2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
27	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
28	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
29	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
30	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
31	AMTINPUT	☐	TB_AMTIN	TX_AMTIN	CHAR	1	0	Note field for traded amount forex transactions
32	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
33	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
34	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
35	JLIMIT	☐	TB_JLIMIT	XFELD	CHAR	1	0	Limit indicator
36	AKUEND	☐	TB_AKUEND	T_AKUEND	NUMC	2	0	Period of Notice
37	SKUEND	☐	TB_SKUEND	T_SKUEND	NUMC	1	0	Unit of Period of Notice
38	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
39	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
40	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
41	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
42	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
43	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
44	VRFHA	☐	TB_VORFHA	T_RFHA	CHAR	13	0	Reference transaction (Rollover/premature settlement)	*
45	SINCLBE	☐	TB_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
46	SNPVCAL	☐	TB_SNPVCAL	T_SNPVCAL	CHAR	1	0	NPV Calculation
47	SRNDNG	☐	TB_SRNDNG	TFM_SROUND	CHAR	1	0	Rounding of Amount from Generated Flows
48	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
49	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
50	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
51	SFRGZUST	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
52	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
53	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
54	FACILITYNR	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	VTBFHA
55	FACILITYBUKRS	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	T001
56	POSACC	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
57	RCOMVALCL2	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
58	TIMESTAMP_DEAL	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
59	RPORTB2	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
60	.INCLUDE	☐				0	0	Financial transaction: Screen fields
61	XBUKRS	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
62	XGSART	☐	TB_XGSART	TEXT30	CHAR	30	0	Name of product type
63	XFHAART	☐	TB_FATEXT	T_XTEXT30	CHAR	30	0	Name of Transaction Type
64	XABWTYP	☐	TB_XABRBEZ	TEXT60	CHAR	60	0	Name: Processing Category
65	SKUENDT	☐	TM_SKUENDT	XFELD	CHAR	1	0	Period of notice in days
66	SKUENDM	☐	TM_SKUENDM	XFELD	CHAR	1	0	Period of notice in months
67	XRFHA	☐	TB_XRFHA	T_XRFHA	CHAR	13	0	Financial transaction number
68	XAKTIV	☐	TM_XAKTIV	TEXT60	CHAR	60	0	Active status: description
69	XFRGZUST	☐	TB_XFRGZUST	TEXT60	CHAR	60	0	Transaction release: Release status
70	XKONTRH	☐	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
71	XGARANT	☐	TB_XGARANT	TEXT80	CHAR	80	0	Name and address of guarantor
72	SNOTE	☐	TB_SNOTE	XFELD	CHAR	1	0	Memo exists
73	SINCLB	☐	TB_SINCLBB	XFELD	CHAR	1	0	Calculation Period: Start Inclusive - End Exclusive
74	SINCLE	☐	TB_SINCLEB	XFELD	CHAR	1	0	Calculation Period: Start Exclusive - End Inclusive
75	SNPVCALY	☐	TB_SNPVCALY	XFELD	CHAR	1	0	NPV calculation via yield
76	SNPVCALD	☐	TB_SNPVCALD	XFELD	CHAR	1	0	NPV calculation via discounting
77	SRNDNGB	☐	TB_SRNDNGB	XFELD	CHAR	1	0	Round Up or Down to the Nearest Whole Number
78	SRNDNGD	☐	TB_SRNDNGD	XFELD	CHAR	1	0	Round down
79	SRNDNGU	☐	TB_SRNDNGU	XFELD	CHAR	1	0	Round up
80	BEGRUTXT	☐	BEGRUTXT	TEXT50	CHAR	50	0	Name of authorization group for financial transactions
81	XREFKONT	☐	TB_XREFKONT	TEXT40	CHAR	40	0	Name of account assignment reference
82	XREFKONT2	☐	TB_XREFKONT2	TEXT40	CHAR	40	0	Name of account assignment reference 2
83	XPORTB	☐	VVXPORTB	TEXT30	CHAR	30	0	Portfolio name
84	SVALIDATED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
85	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
86	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
87	EXT_RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
88	XLDEPO	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
89	DBLFZ_LABEL	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
90	SMSG	☐	TB_SMSG	XFELD	CHAR	1	0	Messages Exist
91	SFUNKTV	☐	TB_SFUNKTV	T_FUNKTION	CHAR	4	0	Transition Function from Directly Preceding Activity	*
92	SFUNKTL	☐	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	*
93	LATEST_DATE	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
94	LATEST_TIME	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
95	ICON_FLAG	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
96	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
97	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
98	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
99	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
100	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
101	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
102	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
103	XANLF	☐	TB_XANLF	TEXT30	CHAR	30	0	Product Category Name
104	XFGTYP	☐	TB_XFGTYP	TEXT30	CHAR	30	0	Transaction category name
105	XPGTYP	☐	TB_XPGTYP	TEXT60	CHAR	60	0	Description of product category and transaction category
106	XFGZUSTT	☐	TB_XFGZUSTT	TEXT30	CHAR	30	0	Name of Activity Category
107	XFUNKTV	☐	TB_XFUNKTV	TEXT30	CHAR	30	0	Treasury function name from directly preceding activity
108	XFUNKTL	☐	TB_XFUNKTL	TEXT30	CHAR	30	0	Name of Treasury function
109	BNOMUND	☐	TB_NOMUND	WERTV8_TR	CURR	15	2	Nominal amount of underlying
110	BNOMEIN	☐	TB_NOMEIN	WERTV8_TR	CURR	15	2	Nominal amount of incoming side
111	BNOMAUS	☐	TB_NOMAUS	WERTV8_TR	CURR	15	2	Nominal amount of outgoing side
112	FESTZINS	☐	TB_FESTZINS	DECV3_7	DEC	10	7	Fixed-rate FRA / cap/floor
113	FESTZINSES	☐	TB_FESTZINS_ES	DECV3_7	DEC	10	7	Fixed interest of incoming side
114	FESTZINSAS	☐	TB_FESTZINS_AS	DECV3_7	DEC	10	7	Fixed interest of outgoing side
115	ZINSREF	☐	TB_ZINSREF	ZIREFKU	CHAR	10	0	FRA reference interest rate, cap/floor	*
116	ZINSREFES	☐	TB_ZINSREF_ES	ZIREFKU	CHAR	10	0	Reference interest rate of incoming side	*
117	ZINSREFAS	☐	TB_ZINSREF_AS	ZIREFKU	CHAR	10	0	Reference interest rate of outgoing side	*
118	ICON_LOCKED	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTG_IRATE_DERIV	ABWTYP	AT05	ABWTYP	KEY	1	CN
2	VTG_IRATE_DERIV	BUKRS	T001	BUKRS	KEY	1	CN
3	VTG_IRATE_DERIV	FACILITYBUKRS	T001	BUKRS	KEY	1	CN
4	VTG_IRATE_DERIV	FACILITYNR	VTBFHA	RFHA
5	VTG_IRATE_DERIV	MANDT	T000	MANDT	KEY	1	CN
6	VTG_IRATE_DERIV	OBJNR	ONR00	OBJNR		1	N
7	VTG_IRATE_DERIV	POSACC	TRFT_POS_ACCOUNT	POS_ACCOUNT
8	VTG_IRATE_DERIV	RCOMVALCL	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
9	VTG_IRATE_DERIV	RCOMVALCL2	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
10	VTG_IRATE_DERIV	RLDEPO	TWD01	RLDEPO		C	CN
11	VTG_IRATE_DERIV	RMAID	VTBMA	RMAID		C	CN
12	VTG_IRATE_DERIV	RPORTB	TWPOB	RPORTB
13	VTG_IRATE_DERIV	RPORTB2	TWPOB	RPORTB
14	VTG_IRATE_DERIV	RREFKONT	T037S	RREFKONT	KEY	1	CN
15	VTG_IRATE_DERIV	RREFKONT2	T037S	RREFKONT	REF	C	CN
16	VTG_IRATE_DERIV	SANLF	TZAF	SANLF	KEY	1	CN
17	VTG_IRATE_DERIV	SFGTYP	AT01	SFGTYP	KEY	1	CN
18	VTG_IRATE_DERIV	SFHAART	AT10	SFHAART	KEY	1	CN
19	VTG_IRATE_DERIV	SGSART	TZPA	GSART	KEY	1	CN
20	VTG_IRATE_DERIV	SKALID	TFACD	IDENT	KEY	1	CN
21	VTG_IRATE_DERIV	SKALID2	TFACD	IDENT	KEY	1	CN
22	VTG_IRATE_DERIV	TBEGRU	TRBRG	TBEGRU		C	N
23	VTG_IRATE_DERIV	WGSCHFT	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in