SAP ABAP Table VTMHPTKOND (Main terms in money market)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTG (Package) R/3 application development for Treasury money market

Basic Data

Table Category	INTTAB	Structure
Structure	VTMHPTKOND	Table Relationship Diagram
Short Description	Main terms in money market

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	Financial Conditions from Money Market View
2	.INCLUDE	☐				0	0	Transaction Condition
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
6	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
7	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
8	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
9	RKOND	☐	TB_KOND	T_KOND	NUMC	4	0	Condition
10	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
11	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
12	.INCLUDE	☐				0	0	Structure for Financial Transaction Conditions (Without Key)
13	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
14	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
15	TCRTIM	☐	TB_CRTIM	TIME06	CHAR	6	0	Entry Time
16	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
17	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
18	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
19	SALTKOND	☐	TB_SALKOND	SKONDGRP	NUMC	4	0	Unit for supplementary condition items
20	SZINSANP	☐	SZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
21	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
22	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
23	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
24	SBKKLAS	☐	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
25	SBKTYP	☐	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions	AT08
26	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
27	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
28	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
29	SBASIS	☐	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
30	BBASIS	☐	TFM_BBASIS2	TFM_WRTV7	CURR	13	2	Calculation Base Amount
31	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
32	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
33	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
34	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
35	SFORMREF	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	*
36	SVARNAME	☐	TB_VARNAME	T_XFELD04	CHAR	4	0	Variable Name
37	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
38	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
39	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
40	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
41	SVWERK	☐	TB_SVWERK	T_SWERK	NUMC	1	0	Working Day Shift for Calculation Day
42	SVMETH	☐	TB_SVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
43	AVGSTAGE	☐	TB_AVGSTAG	T_GSTAGE	INT4	10	0	Number of Days for Relative Calculation of Value Date
44	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
45	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
46	SFWERK	☐	TB_SFWERK	T_SWERK	NUMC	1	0	Working Day Shift for Due Date
47	SFMETH	☐	TB_SFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
48	AFGSTAGE	☐	TB_AFGSTAG	T_GSTAGE	INT4	10	0	Number of days for rel. determination of due date
49	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
50	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
51	AZGSTAGE	☐	TB_AZGSTAG	T_GSTAGE	INT4	10	0	No. of days for relative determinatn of interest fixing
52	DZSREF	☐	TB_ZSREF	DATUM	DATS	8	0	Reference interest rate fixing date
53	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
54	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
55	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
56	SHERKUNFT	☐	TB_SHERK	T_XFELD04	CHAR	4	0	Display Area of Flow or Condition
57	SRHYTHM	☐	TB_SRHYTHM	T_SRHYTHM	NUMC	1	0	Frequency Indicator
58	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
59	SZWERK	☐	VVSZWERK	T_SWERK	NUMC	1	0	Shift to working day for interest fixing date
60	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
61	SKURSART	☐	TI_KURSART	VVSKURSART	CHAR	2	0	Rate/Price Type - Treasury Instruments	*
62	SFVMETH	☐	TB_SFVMETH	T_SFVMETH	NUMC	2	0	Update method for calculation date/due date
63	SERBTERM	☐	TFMERBTERM	TFMERBTERM	CHAR	1	0	FiMa indicator: Date and frequency inheritance for condition
64	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
65	SEXCLGUEL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
66	JSOFVERR	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
67	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
68	SKALID3	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
69	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
70	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
71	PKOND1STPER	☐	TFM_PKOND1STPER	DECV3_7	DEC	10	7	Interest Rate for the First Period
72	SREFDISC	☐	SREFDISC	SKONDGRP	NUMC	4	0	Referenced Condition Group Discounting
73	SDISCOUNT	☐	TFM_SDISCOUNT	TFM_SDISCOUNT	NUMC	1	0	Discounting Category
74	BROUNDUNIT	☐	TFMPRUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
75	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
76	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
77	FACILITYLINE	☐	TB_CREDIT_LINE	T_CREDIT_LINE	CHAR	3	0	Line of Credit	*
78	BGUEL_KP	☐	BGUEL_KP	T_POS_AMOUNT	CURR	17	2	Condition Item Effective from Amount
79	SULTGUEL	☐	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
80	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding
81	.INCLUDE	☐				0	0	Financial Conditions: Screen Fields
82	ARHYTM	☐	TB_ARHYTM	NUMC03	NUMC	3	0	Defined Frequency in Days or Months
83	SRHYTM	☐	TB_SRHYEINH	T_SRHYEINH	NUMC	2	0	Unit for date frequency
84	XKOART	☐	XKOARTL	XMBEZ	CHAR	30	0	Name of condition type
85	XGUELT	☐	TM_XGUELT	T_XDATUM	CHAR	10	0	Effective date
86	XVALUT	☐	TM_XVALUT	T_XDATUM	CHAR	10	0	Calculation date
87	XFAELL	☐	TM_XFAELL	T_XDATUM	CHAR	10	0	Due date
88	XBKOND	☐	TM_XBKOND	T_XBETRG18	CHAR	18	0	Condition amount
89	XZBMETH	☐	TM_XZINSBM	TEXT60	CHAR	60	0	Description of interest calculation method
90	XKALIDWT	☐	TB_XKALIDWT	TEXT60	CHAR	60	0	Name of interest rate calendar
91	XRHYTHM	☐	TM_XRHYTHM	TEXT60	CHAR	60	0	Frequency indicator: description
92	XVWERK	☐	TM_XGSCHTG	TEXT60	CHAR	60	0	Description of working day method
93	XFWERK	☐	TM_XGSCHTG	TEXT60	CHAR	60	0	Description of working day method
94	SBWGFI	☐	TB_SBWGFI	XFELD	CHAR	1	0	Posted flow exists (for viewed object)
95	SBWGAEND	☐	TB_SBWGAEN	XFELD	CHAR	1	0	Manually Changed Flow Exists (for Viewed Object)
96	SZINSKAP	☐	TB_SZINSKAP	XFELD	CHAR	1	0	Capitalize Interest
97	SFRANZE	☐	TB_SFRANZE	XFELD	CHAR	1	0	Shift Due Date Back to End of Term
98	XRHYTM	☐	TB_XRHYTM	TEXT30	CHAR	30	0	Unit of Frequency
99	SSELECTED	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTMHPTKOND	BUKRS	T001	BUKRS
2	VTMHPTKOND	MANDT	T000	MANDT
3	VTMHPTKOND	RFHA	VTBFHA	RFHA
4	VTMHPTKOND	SBERFIMA	AT40	SBERFIMA
5	VTMHPTKOND	SBKTYP	AT08	BKTYP
6	VTMHPTKOND	SKALID	TFACD	IDENT
7	VTMHPTKOND	SKALID2	TFACD	IDENT
8	VTMHPTKOND	SKALID3	TFACD	IDENT	KEY	1	CN
9	VTMHPTKOND	SKOART	TZK01	SKOART
10	VTMHPTKOND	SWHRKOND	TCURC	WAERS
11	VTMHPTKOND	SZSREF	T056R	REFERENZ

History

Last changed by/on	SAP	20130529
SAP Release Created in