SAP ABAP Table VTVDETA_MM_CONVERT (Money Market: Cumulative Values)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI (Package) Application development R/3 Treasury information system

Basic Data

Table Category	INTTAB	Structure
Structure	VTVDETA_MM_CONVERT	Table Relationship Diagram
Short Description	Money Market: Cumulative Values

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	Treasury: Non-Cumulative Values MM: Charact. Trans./Act.
2	.INCLUDE	☐				0	0	Fixed characteristics in Treasury
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
6	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
7	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
8	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
9	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
10	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
11	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
12	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
13	SAKTIV	☐	FTI_SAKTIV	FTI_SAKTIV	CHAR	1	0	Active status of financial transaction (drilldown reporting)
14	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
15	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
16	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
17	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
18	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
19	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
20	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
21	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
22	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
23	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
24	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
25	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
26	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
27	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
28	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
29	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
30	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
31	WGSCHFT3	☐	FTI_WGSCH1	WAERS	CUKY	5	0	Currency borrowing/sale	*
32	WGSCHFT4	☐	FTI_WGSCH2	WAERS	CUKY	5	0	Currency investment/purchase	*
33	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
34	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
35	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
36	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
37	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
38	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
39	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
40	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
41	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
42	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
43	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
44	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
45	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
46	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
47	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
48	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
49	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
50	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
51	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
52	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
53	WZBETR	☐	FTI_SCWHR	WAERS	CUKY	5	0	Currency of payment amount	TCURC
54	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	*
55	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
56	SPLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	*
57	BZBETR	☐	D_CASHCW	WERTV8_TR	CURR	15	2	Payment amount in payment currency
58	BHWBETR	☐	D_CASHHW	WERTV8_TR	CURR	15	2	Payment amount in local currency
59	EHBETR	☐	EHBETR	WERTV7	CURR	13	2	Profit/loss amount in local currency
60	EEBETR	☐	EEBETR	WERTV7	CURR	13	2	Profit/loss amount in profit/loss currency
61	D_ASTUECK	☐	D_ASTUECK	ASTUECK	DEC	15	5	Change in no. of units (for unit-quoted securities)
62	D_AKTBWBW	☐	D_AKTBWBW	WERTV8_TR	CURR	15	2	Asset: Change in book value in position/transaction curr.
63	D_AKTBWHW	☐	D_AKTBWHW	WERTV8_TR	CURR	15	2	Asset: Change in book value in local currency
64	D_PASBWBW	☐	D_PASBWBW	WERTV8_TR	CURR	15	2	Liability: Change in book value in position/trans. curr.
65	D_PASBWHW	☐	D_PASBWHW	WERTV8_TR	CURR	15	2	Liability: Change in book value in local currency
66	D_AKTNOMWBW	☐	D_AKTNOMWBW	WERTV8_TR	CURR	15	2	Asset: Change in nominal value in purchase currency
67	D_PASNOMWBW	☐	D_PASNOMWBW	WERTV8_TR	CURR	15	2	Liability: Change in nominal value in sale currency
68	PABGERFBW	☐	PABGERFBW	WERTV8_TR	CURR	15	2	Revenue accrued/deferred in position currency (PC)
69	PABGERFPL	☐	PABGERFPLW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Profit/Loss Currency
70	PABGERFHW	☐	PABGERFHW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Local Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVDETA_MM_CONVERT	BUKRS	T001	BUKRS		1	CN
2	VTVDETA_MM_CONVERT	GSART	TZPA	GSART
3	VTVDETA_MM_CONVERT	HKONT	SKB1	SAKNR
4	VTVDETA_MM_CONVERT	LAND1	T005	LAND1
5	VTVDETA_MM_CONVERT	MANDT	T000	MANDT		1	CN
6	VTVDETA_MM_CONVERT	PARTNR	BUT000	PARTNER
7	VTVDETA_MM_CONVERT	PRKEY	PAYRQ	KEYNO		C	CN
8	VTVDETA_MM_CONVERT	RAHABKI	T012	HBKID
9	VTVDETA_MM_CONVERT	RAHKTID	T012K	HKTID
10	VTVDETA_MM_CONVERT	RDEALER	TZDEA	RDEALER
11	VTVDETA_MM_CONVERT	RFHA	VTBFHA	RFHA
12	VTVDETA_MM_CONVERT	RGARANT	BUT000	PARTNER		C	CN
13	VTVDETA_MM_CONVERT	RMAID	VTBMA	RMAID		C	CN
14	VTVDETA_MM_CONVERT	RPORTB	TWPOB	RPORTB		1	CN
15	VTVDETA_MM_CONVERT	RPZAHL	BUT000	PARTNER
16	VTVDETA_MM_CONVERT	RREFKONT	T037S	RREFKONT		1	CN
17	VTVDETA_MM_CONVERT	SANLF	TZAF	SANLF		1	CN
18	VTVDETA_MM_CONVERT	SBEWART	TZB0A	SBEWART
19	VTVDETA_MM_CONVERT	SFGTYP	AT01	SFGTYP
20	VTVDETA_MM_CONVERT	SFGZUSTT	AT02	SFGZUSTT
21	VTVDETA_MM_CONVERT	SFHAART	AT10	SFHAART
22	VTVDETA_MM_CONVERT	WAERS	TCURC	WAERS
23	VTVDETA_MM_CONVERT	WZBETR	TCURC	WAERS
24	VTVDETA_MM_CONVERT	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in