SAP ABAP Table VTMWRK0 (View of Transaction for Collective Processing and Reporting)

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	VTMWRK0	Table Relationship Diagram
Short Description	View of Transaction for Collective Processing and Reporting

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
4	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
5	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
6	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
7	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
8	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
9	XKONTRH	☐	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
10	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
11	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
12	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
13	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
14	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
15	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
16	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
17	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
18	PZINS	☐	TM_PZINS	DEC3_7	DEC	10	7	Interest rate
19	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
20	FORMULA	☐	TB_IRATE_FORMULA	TEXT100	CHAR	100	0	FTR: Interest Formula
21	BANLAGE	☐	TM_BSALDO	T_BSALDO	CURR	13	2	Amount or balance
22	BSUMME	☐	TM_BSUMME	WERT8	CURR	15	2	Single or totaled amount
23	BZINS	☐	TM_BSUMME	WERT8	CURR	15	2	Single or totaled amount
24	XNPVCAL	☐	TB_XNPVCAL	TEXT30	CHAR	30	0	Name of NPV calculation
25	AMNT_DELTA	☐	TB_FC_AMOUNT_DELTA	T_POS_AMOUNT	CURR	17	2	FTR Facility: Amount Above/Below the Limit
26	AMNT_LIMIT	☐	TB_FC_AMOUNT_LIMIT	T_POS_AMOUNT	CURR	17	2	FTR Facility: Limit Amount on Key Date
27	AMNT_USED	☐	TB_FC_AMOUNT_USED	T_POS_AMOUNT	CURR	17	2	FTR Facility: Utilization on Key Date
28	AMNT_FREE	☐	TB_FC_AMOUNT_FREE	T_POS_AMOUNT	CURR	17	2	FTR Facility: Amount Available on Key Date
29	AMNT_OVER	☐	TB_FC_AMOUNT_OVER	T_POS_AMOUNT	CURR	17	2	FTR Facility: Overdraft Amount on Key Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTMWRK0	BUKRS	T001	BUKRS
2	VTMWRK0	KONTRH	BUT000	PARTNER
3	VTMWRK0	MANDT	T000	MANDT
4	VTMWRK0	RDEALER	TZDEA	RDEALER
5	VTMWRK0	RMAID	VTBMA	RMAID		C	CN
6	VTMWRK0	RPORTB	TWPOB	RPORTB
7	VTMWRK0	SANLF	TZAF	SANLF
8	VTMWRK0	SFGTYP	AT01	SFGTYP
9	VTMWRK0	SFGZUSTT	AT02	SFGZUSTT
10	VTMWRK0	SFHAART	AT10	SFHAART
11	VTMWRK0	SGSART	TZPA	GSART
12	VTMWRK0	WGSCHFT	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in