SAP ABAP Table VTVBARW_GH (Money Market: For a Given Date)

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	VTVBARW_GH	Table Relationship Diagram
Short Description	Money Market: For a Given Date

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	.INCLUDE	☐				0	0	Treasury: Commitment Partner
28	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
29	.INCLUDE	☐				0	0	Treasury: Partner Attributes
30	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
31	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
32	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
33	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
34	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
35	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
36	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
37	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
38	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
39	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
40	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
41	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
42	.INCLUDE	☐				0	0	Business partner credit standing data
43	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
44	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
45	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
46	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
47	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
48	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
49	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
50	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
51	WGSCHFT1	☐	FTI_WGSCH1	WAERS	CUKY	5	0	Currency borrowing/sale	TCURC
52	WGSCHFT2	☐	FTI_WGSCH2	WAERS	CUKY	5	0	Currency investment/purchase	TCURC
53	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
54	CALC_CCY	☐	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	TCURC
55	RLZTG	☐	FTI_RLZTG	NUMC5	NUMC	5	0	Remaining Term in Days
56	RLZMO	☐	FTI_RLZMO	NUMC4	NUMC	4	0	Remaining Term in Months
57	RLZJA	☐	FTI_RLZJA	NUMC3	NUMC	3	0	Remaining Term in Years
58	UEBTG	☐	FTI_UEBTG	NUMC5	NUMC	5	0	Overdue Period in Days
59	UEBMO	☐	FTI_UEBMO	NUMC3	NUMC	3	0	Overdue Period in Months
60	UEBJA	☐	FTI_UEBJA	NUMC2	NUMC	2	0	Overdue Period in Years
61	MPKOND	☐	MPKOND	FTI_NUMC3	NUMC	3	0	Interest rate (characteristic in drill-down reporting)
62	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
63	PEFFZINS	☐	FTI_PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate on Key Date
64	BNOMI1	☐	FTI_PASNOMWBW	WERTV8_TR	CURR	15	2	Liability: Nominal value in currency of sale
65	BNOMI2	☐	FTI_AKTNOMWBW	WERTV8_TR	CURR	15	2	Asset: Nominal value in investment currency
66	BNOMI1HW	☐	FTI_PASNOMWHW	WERTV8_TR	CURR	15	2	Liability: Nominal value in local currency
67	BNOMI2HW	☐	FTI_AKTNOMWHW	WERTV8_TR	CURR	15	2	Asset: Nominal value in local currency
68	BAKTAWBW	☐	FTI_AKTAWBW	WERTV8_TR	CURR	15	2	Asset: Acquisition value in position/transaction currency
69	BAKTAWHW	☐	FTI_AKTAWHW	WERTV8_TR	CURR	15	2	Asset: Acquisition value in local currency
70	BPASAWBW	☐	FTI_PASAWBW	WERTV8_TR	CURR	15	2	Liability: Acquisition value in position/transact. currency
71	BPASAWHW	☐	FTI_PASAWHW	WERTV8_TR	CURR	15	2	Liability: Acquisition value in local currency
72	AKTBWBW	☐	FTI_AKTBWBW	WERTV8_TR	CURR	15	2	Asset: Book value in position currency/transaction currency
73	AKTBWHW	☐	FTI_AKTBWHW	WERTV8_TR	CURR	15	2	Asset: Book value in local currency
74	PASBWBW	☐	FTI_PASBWBW	WERTV8_TR	CURR	15	2	Liability: Book value in position/transaction currency
75	PASBWHW	☐	FTI_PASBWHW	WERTV8_TR	CURR	15	2	Liability: Book value in local currency
76	AKTBWBW_SIM	☐	AKTBWBW_SIM	WERTV8_TR	CURR	15	2	Asset: Book value from sim. valuation in purchase currency
77	AKTBWHW_SIM	☐	AKTBWHW_SIM	WERTV8_TR	CURR	15	2	Asset: Book value from sim. valuation in local currency
78	AZINSANSPBW	☐	AZINSANSPBW	WERTV7	CURR	13	2	Interest Receivable from Simulated Accr./Def. in Pos. Crcy
79	AZINSANSPHW	☐	AZINSANSPHW	WERTV7	CURR	13	2	Interest receivable from simulated accr./def. in local curr.
80	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
81	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
82	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
83	NPV_CC	☐	TV_NPV_CC	WERTV8_TR	CURR	15	2	RM NPV in Evaluation Currency
84	CLEAN_PRICE_CC	☐	FTI_CLEAN_PRICE_CC	T_PRESVAL	CURR	17	2	Clean Price in Valuation Currency
85	BPVALUE_CC	☐	TV_VALBP	T_PRESVAL	CURR	17	2	Basis Point Value in Evaluation Currency
86	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
87	MOD_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
88	BNOMI1_AW	☐	FTI_PASNOMWBW_AW	WERTV8_TR	CURR	15	2	Liability: Nominal value in display curr. from sale curr.
89	BNOMI2_AW	☐	FTI_AKTNOMWBW_AW	WERTV8_TR	CURR	15	2	Asset: Nominal value in display curr. from purchase curr.
90	BNOMI1HW_AW	☐	FTI_PASNOMWHW_AW	WERTV8_TR	CURR	15	2	Liability: Nominal value in display curr. from local curr.
91	BNOMI2HW_AW	☐	FTI_AKTNOMWHW_AW	WERTV8_TR	CURR	15	2	Asset: Nominal value in display currency from local currency
92	BAKTAWBW_AW	☐	FTI_AKTAWBW_AW	WERTV8_TR	CURR	15	2	Asset: Acquisition value in display currency
93	BAKTAWHW_AW	☐	FTI_AKTAWHW_AW	WERTV8_TR	CURR	15	2	Asset: Acquisition value in display curr. from local curr.
94	BPASAWBW_AW	☐	FTI_PASAWBW_AW	WERTV8_TR	CURR	15	2	Liability: Acquisition value in display currency
95	BPASAWHW_AW	☐	FTI_PASAWHW_AW	WERTV8_TR	CURR	15	2	Liability: Acquisition value in disp. curr. from local curr.
96	AKTBWBW_AW	☐	FTI_AKTBWBW_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency from position currency
97	AKTBWHW_AW	☐	FTI_AKTBWHW_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency from local currency
98	PASBWBW_AW	☐	FTI_PASBWBW_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display currency
99	PASBWHW_AW	☐	FTI_PASBWHW_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display curr. from local currency
100	AKTBWBW_SIM_AW	☐	AKTBWBW_SIM_AW	WERTV8_TR	CURR	15	2	Asset: Book value from sim. valuation in display currency
101	AKTBWHW_SIM_AW	☐	AKTBWHW_SIM_AW	WERTV8_TR	CURR	15	2	Asset: Book value from sim. valuation in display curr. (LC)
102	AZINSANSPBW_AW	☐	AZINSANSPBW_AW	WERTV7	CURR	13	2	Interest receivable from simulated accr./def. in displ.curr.
103	AZINSANSPHW_AW	☐	AZINSANSPHW_AW	WERTV7	CURR	13	2	Interest received from simulated acc./def.in displ.curr.(LC)
104	NPV_PC_AW	☐	FTI_NPV_PC		CURR	23	2	RM NPV in Display Currency
105	CLEAN_PRICE_PC_AW	☐	FTI_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
106	BPVALUE_PC_AW	☐	FTI_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Display Currency
107	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
108	RLZTG_K	☐	FTI_RLZTGK	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
109	UEBTG_K	☐	FTI_UEBTGK	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
110	PKOND	☐	TV_PKOND	DECV3_7	DEC	10	7	Interest rate
111	STUECKE	☐	FTI_STUECKE	ASTUECK	DEC	15	5	Number of units / Number of transactions
112	.INCLUDE	☐				0	0	Additional Treasury Selections
113	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
114	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
115	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
116	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
117	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
118	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
119	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
120	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
121	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
122	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
123	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
124	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
125	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
126	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
127	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
128	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
129	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
130	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
131	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
132	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
133	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
134	FLG_REVERSED_FLOWS	☐	FTI_REVERSED_FLOWS	XFELD	CHAR	1	0	Process Reversed Flows (for Query)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVBARW_GH	ANZGW	TCURC	WAERS
2	VTVBARW_GH	AUSWT	JBREVAL	AUSWERTUNG
3	VTVBARW_GH	BUKRS	T001	BUKRS		1	CN
4	VTVBARW_GH	CALC_CCY	TCURC	WAERS
5	VTVBARW_GH	CNTRY_COMP	T005	LAND1
6	VTVBARW_GH	GROUP_D	TP13	GROUP_D
7	VTVBARW_GH	GROUP_ID	TB001	BU_GROUP
8	VTVBARW_GH	GSART	TZPA	GSART
9	VTVBARW_GH	HKONT	SKB1	SAKNR
10	VTVBARW_GH	IND_SECTOR	TB038A	IND_SECTOR
11	VTVBARW_GH	ISTYPE	TB038	ISTYPE
12	VTVBARW_GH	KURSA	TW56	SKURSART
13	VTVBARW_GH	LAND1	T005	LAND1
14	VTVBARW_GH	LEGAL_ENTY	TB019	LEGAL_ENTY
15	VTVBARW_GH	LEGAL_ORG	TB032	LEGAL_ORG
16	VTVBARW_GH	MANDT	T000	MANDT		1	CN
17	VTVBARW_GH	NATION	T005	LAND1
18	VTVBARW_GH	NUMBR	T242Q	NUMBR
19	VTVBARW_GH	NUMBR_LC	T242Q	NUMBR
20	VTVBARW_GH	PARTNR	BUT000	PARTNER
21	VTVBARW_GH	PERIV	T009	PERIV
22	VTVBARW_GH	RATING	TP06	RATING
23	VTVBARW_GH	RDEALER	TZDEA	RDEALER
24	VTVBARW_GH	RFHA	VTBFHA	RFHA
25	VTVBARW_GH	RGARANT	BUT000	PARTNER		C	CN
26	VTVBARW_GH	RMAID	VTBMA	RMAID		C	CN
27	VTVBARW_GH	RPORTB	TWPOB	RPORTB		1	CN
28	VTVBARW_GH	RREFKONT	T037S	RREFKONT		1	CN
29	VTVBARW_GH	SANLF	TZAF	SANLF		1	CN
30	VTVBARW_GH	SBWHR	TCURC	WAERS		C	CN
31	VTVBARW_GH	SFGTYP	AT01	SFGTYP
32	VTVBARW_GH	SFGZUSTT	AT02	SFGZUSTT
33	VTVBARW_GH	SFHAART	AT10	SFHAART
34	VTVBARW_GH	SOL_INS	TP07	SOL_INS
35	VTVBARW_GH	STAFF_GRP	TP05	STAFF_GRP
36	VTVBARW_GH	STATE	T005	LAND1
37	VTVBARW_GH	VVRANLWI	TWX1	VVRANLWI
38	VTVBARW_GH	WAERS	TCURC	WAERS
39	VTVBARW_GH	WGSCHFT1	TCURC	WAERS
40	VTVBARW_GH	WGSCHFT2	TCURC	WAERS

History

Last changed by/on	SAP	20131127
SAP Release Created in