SAP ABAP Table VTMTGSB (Time Deposit - Fast Processing)

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	VTMTGSB	Table Relationship Diagram
Short Description	Time Deposit - Fast Processing

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 transactions from money market view
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	XPGART	☐	TB_XPGART	TEXT60	CHAR	60	0	Name of product and transaction type
81	SBWGARTZU	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
82	SBWGARTAB	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
83	BSALDOALT	☐	TM_BSALDO	T_BSALDO	CURR	13	2	Amount or balance
84	BSALDONEU	☐	TM_BSALDO	T_BSALDO	CURR	13	2	Amount or balance
85	XSALDONEU	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
86	PZINSALT	☐	TM_PZINS	DEC3_7	DEC	10	7	Interest rate
87	PZINSNEU	☐	TM_PZINS	DEC3_7	DEC	10	7	Interest rate
88	DBLFZALT	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
89	DBLFZNEU	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
90	XBLFZNEU	☐	TM_XLFZBEG	T_XDATUM	CHAR	10	0	Term Start
91	DELFZALT	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
92	DELFZNEU	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
93	XELFZNEU	☐	TM_XLFZEND	T_XDATUM	CHAR	10	0	End of Term
94	SZNSPROALT	☐	TB_SZNSPRO	T_SZNSPRO	NUMC	1	0	Interest Handling with Rollover
95	SZNSPRONEU	☐	TB_SZNSPRO	T_SZNSPRO	NUMC	1	0	Interest Handling with Rollover
96	SZINSKAPALT	☐	TB_SZINSKAP	XFELD	CHAR	1	0	Capitalize Interest
97	SZINSKAPNEU	☐	TB_SZINSKAP	XFELD	CHAR	1	0	Capitalize Interest
98	SKUENDGG	☐	TM_SKUEND	XFELD	CHAR	1	0	Termination indicator
99	BSALDOSAVE	☐	TM_BSALDO	T_BSALDO	CURR	13	2	Amount or balance
100	SZINSKAPSALDO	☐	TB_SZINSKAP	XFELD	CHAR	1	0	Capitalize Interest
101	SCHANGE	☐	TM_SCHANGE	XFELD	CHAR	1	0	Change indicator
102	SSAVED	☐	TM_SSAVED	XFELD	CHAR	1	0	Save indicator
103	DVTRABNEU	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in