SAP ABAP Table VTVDETA_MM (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	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	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
32	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
33	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
34	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
35	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
36	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
37	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
38	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
39	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
40	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
41	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
42	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
43	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
44	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
45	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
46	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
47	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
48	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
49	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
50	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
51	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
52	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	*
53	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
54	BZBETR	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
55	BHWBETR	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
56	EBBETR	☐	EBBETR	WERTV7	CURR	13	2	-->Profit/loss amount in position/transaction currency
57	EHBETR	☐	EHBETR	WERTV7	CURR	13	2	Profit/loss amount in local currency
58	D_AKTBWBW	☐	D_AKTBWBW	WERTV8_TR	CURR	15	2	Asset: Change in book value in position/transaction curr.
59	D_AKTBWHW	☐	D_AKTBWHW	WERTV8_TR	CURR	15	2	Asset: Change in book value in local currency
60	D_PASBWBW	☐	D_PASBWBW	WERTV8_TR	CURR	15	2	Liability: Change in book value in position/trans. curr.
61	D_PASBWHW	☐	D_PASBWHW	WERTV8_TR	CURR	15	2	Liability: Change in book value in local currency
62	D_AKTNOMWBW	☐	D_AKTNOMWBW	WERTV8_TR	CURR	15	2	Asset: Change in nominal value in purchase currency
63	D_PASNOMWBW	☐	D_PASNOMWBW	WERTV8_TR	CURR	15	2	Liability: Change in nominal value in sale currency
64	PABGERFBW	☐	PABGERFBW	WERTV8_TR	CURR	15	2	Revenue accrued/deferred in position currency (PC)
65	PABGERFHW	☐	PABGERFHW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Local Currency
66	D_ASTUECK	☐	D_ASTUECK	ASTUECK	DEC	15	5	Change in no. of units (for unit-quoted securities)
67	D_AWBW_A	☐	D_AWBW_A	WERTV8_TR	CURR	15	2	Change in acquisition value in position currency (asset)
68	D_AWBW_P	☐	D_AWBW_P	WERTV8_TR	CURR	15	2	Change in acquisition value in position currency (liability)
69	D_AWHW_A	☐	D_AWHW_A	WERTV8_TR	CURR	15	2	Change in acquisition value in local currency (asset)
70	D_AWHW_P	☐	D_AWHW_P	WERTV8_TR	CURR	15	2	Change in acquisition value in local currency (liability)

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in