SAP ABAP Table VTMWRK1 (Transaction view for collective 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	VTMWRK1	Table Relationship Diagram
Short Description	Transaction view for collective 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	Transaction
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
5	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
6	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
7	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
8	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
9	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
10	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
11	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
12	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
13	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
14	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
15	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
16	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
17	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
18	RFHAZUNR	☐	TB_RFHAZUN	T_RFHAZU	NUMC	5	0	Number status of activity
19	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
20	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
21	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
22	SROLEXT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
23	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
24	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
25	RREFKONT2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
26	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
27	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
28	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
29	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
30	AMTINPUT	☐	TB_AMTIN	TX_AMTIN	CHAR	1	0	Note field for traded amount forex transactions
31	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
32	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
33	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
34	JLIMIT	☐	TB_JLIMIT	XFELD	CHAR	1	0	Limit indicator
35	AKUEND	☐	TB_AKUEND	T_AKUEND	NUMC	2	0	Period of Notice
36	SKUEND	☐	TB_SKUEND	T_SKUEND	NUMC	1	0	Unit of Period of Notice
37	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
38	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
39	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
40	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
41	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
42	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
43	VRFHA	☐	TB_VORFHA	T_RFHA	CHAR	13	0	Reference transaction (Rollover/premature settlement)	*
44	SINCLBE	☐	TB_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
45	SNPVCAL	☐	TB_SNPVCAL	T_SNPVCAL	CHAR	1	0	NPV Calculation
46	SRNDNG	☐	TB_SRNDNG	TFM_SROUND	CHAR	1	0	Rounding of Amount from Generated Flows
47	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
48	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
49	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
50	SFRGZUST	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
51	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
52	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
53	FACILITYNR	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	VTBFHA
54	FACILITYBUKRS	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	T001
55	POSACC	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
56	RCOMVALCL2	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
57	TIMESTAMP_DEAL	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
58	RPORTB2	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
59	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
60	DPROLOL	☐	TB_DPROLOL	DATUM	DATS	8	0	Last rollover date
61	PEFFZINS	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
62	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
63	XEFFMETH	☐	TB_XEFFMETH	TEXT60	CHAR	60	0	Name of effective interest rate method
64	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
65	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
66	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
67	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
68	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
69	BANLAGE	☐	TM_BSUMME	WERT8	CURR	15	2	Single or totaled amount
70	BBLFZ	☐	TM_BBLFZ	WERT8	CURR	15	2	Amount at start of term/ last rollover date
71	BELFZ	☐	TM_BELFZ	WERT8	CURR	15	2	Amount at end of term
72	BNOMI	☐	TM_BNOMI	WERT8	CURR	15	2	Nominal amount
73	BZINSBLFZ	☐	TM_BZINSBLFZ	WERT8	CURR	15	2	Interest Total at Start of Term
74	BZINSELFZ	☐	TM_BZINSELFZ	WERT8	CURR	15	2	Interest Total at End of Term
75	BZINSSTICH	☐	TM_BZINSSTICH	WERT8	CURR	15	2	Interest Total on Key Date
76	PZINS	☐	TM_PZINS	DEC3_7	DEC	10	7	Interest rate
77	SZINSKAP	☐	TB_SZINSKAP	XFELD	CHAR	1	0	Capitalize Interest
78	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
79	PKOND1STPER	☐	TFM_PKOND1STPER	DECV3_7	DEC	10	7	Interest Rate for the First Period
80	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
81	FORMULA	☐	TB_IRATE_FORMULA	TEXT100	CHAR	100	0	FTR: Interest Formula
82	AMNT_DELTA	☐	TB_FC_AMOUNT_DELTA	T_POS_AMOUNT	CURR	17	2	FTR Facility: Amount Above/Below the Limit
83	AMNT_LIMIT	☐	TB_FC_AMOUNT_LIMIT	T_POS_AMOUNT	CURR	17	2	FTR Facility: Limit Amount on Key Date
84	AMNT_USED	☐	TB_FC_AMOUNT_USED	T_POS_AMOUNT	CURR	17	2	FTR Facility: Utilization on Key Date
85	AMNT_FREE	☐	TB_FC_AMOUNT_FREE	T_POS_AMOUNT	CURR	17	2	FTR Facility: Amount Available on Key Date
86	AMNT_OVER	☐	TB_FC_AMOUNT_OVER	T_POS_AMOUNT	CURR	17	2	FTR Facility: Overdraft Amount on Key Date
87	XNPVCAL	☐	TB_XNPVCAL	TEXT30	CHAR	30	0	Name of NPV calculation
88	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
89	XKONTRH	☐	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
90	XGSART	☐	TB_XGSART	TEXT30	CHAR	30	0	Name of product type
91	XFHAART	☐	TB_XFHAART	TEXT30	CHAR	30	0	Name of transaction type
92	XANLF	☐	TB_XANLF	TEXT30	CHAR	30	0	Product Category Name
93	XFGTYP	☐	TB_XFGTYP	TEXT30	CHAR	30	0	Transaction category name
94	XPGTYP	☐	TB_XPGTYP	TEXT60	CHAR	60	0	Description of product category and transaction category
95	XFGZUSTT	☐	TB_XFGZUSTT	TEXT30	CHAR	30	0	Name of Activity Category
96	XAKTIV	☐	TB_XAKTIV	TEXT30	CHAR	30	0	Active status name
97	ICON_CHECKED	☐	TB_ICON_CHECKED	CHAR4	CHAR	4	0	Processing indicator
98	PZINS_AMOUNT	☐	TB_BKOND	WERTV7	CURR	13	2	Interest rate as amount
99	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	VTMWRK1	ABWTYP	AT05	ABWTYP	KEY	1	CN
2	VTMWRK1	BUKRS	T001	BUKRS	KEY	1	CN
3	VTMWRK1	FACILITYBUKRS	T001	BUKRS	KEY	1	CN
4	VTMWRK1	FACILITYNR	VTBFHA	RFHA
5	VTMWRK1	MANDT	T000	MANDT	KEY	1	CN
6	VTMWRK1	OBJNR	ONR00	OBJNR		1	N
7	VTMWRK1	POSACC	TRFT_POS_ACCOUNT	POS_ACCOUNT
8	VTMWRK1	RCOMVALCL	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
9	VTMWRK1	RCOMVALCL2	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
10	VTMWRK1	RLDEPO	TWD01	RLDEPO		C	CN
11	VTMWRK1	RMAID	VTBMA	RMAID		C	CN
12	VTMWRK1	RPORTB	TWPOB	RPORTB
13	VTMWRK1	RPORTB2	TWPOB	RPORTB
14	VTMWRK1	RREFKONT	T037S	RREFKONT	KEY	1	CN
15	VTMWRK1	RREFKONT2	T037S	RREFKONT	REF	C	CN
16	VTMWRK1	SANLF	TZAF	SANLF	KEY	1	CN
17	VTMWRK1	SFGTYP	AT01	SFGTYP	KEY	1	CN
18	VTMWRK1	SFHAART	AT10	SFHAART	KEY	1	CN
19	VTMWRK1	SGSART	TZPA	GSART	KEY	1	CN
20	VTMWRK1	SKALID	TFACD	IDENT	KEY	1	CN
21	VTMWRK1	SKALID2	TFACD	IDENT	KEY	1	CN
22	VTMWRK1	TBEGRU	TRBRG	TBEGRU		C	N
23	VTMWRK1	WGSCHFT	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in