SAP ABAP Table VZBEST (Treasury general portfolio structure)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM (Application Component) Treasury and Risk Management
     ⤷ FTVV (Package) TR - Objects from FVV in both Loans/Securities areas

Basic Data

Table Category	INTTAB	Structure
Structure	VZBEST	Table Relationship Diagram
Short Description	Treasury general portfolio structure

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	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RKEY1	☐	VVRKEY13	CHAR13	CHAR	13	0	Key part 1
5	RKEY2	☐	VVRKEY10	CHAR10	CHAR	10	0	Key part 2
6	SRECTYPE	☐	VVSRECTYPE	VVSRECTYPE	CHAR	2	0	Record Type
7	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
8	RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
9	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
10	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
11	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
12	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
13	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
14	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
15	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
16	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
17	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
18	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
19	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
20	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
21	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
22	SZINSTYP	☐	VVSZINSTYP	VVSZINSTYP	CHAR	1	0	Interest type: fixed, variable, other
23	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
24	BKOND	☐	TB_BKOND	WERTV7	CURR	13	2	Interest rate as amount
25	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	TCURC
26	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
27	SNOTTYPE	☐	TB_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type for option, future, security etc.
28	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
29	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	*
30	REWHR	☐	REWHR	WAERS	CUKY	5	0	Issue currency	*
31	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
32	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
33	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
34	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
35	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
36	SOPTAUS	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
37	SABRMET	☐	TB_ABRMET	T_SABRMET	CHAR	1	0	Settlement method for option, warrant and future
38	SETTLFL	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
39	OSTRIKE	☐	TB_OSTRIKE	WERTV7	CURR	13	2	Strike amount of option, warrant
40	OFWAERS	☐	TB_OFWAERS	WAERS	CUKY	5	0	Strike currency of option, warrant, future	TCURC
41	URANTYP	☐	TI_URANTYP	RANTYP	CHAR	1	0	Underlying contract type
42	USANLF	☐	TB_USANLF	VVSANLF	NUMC	3	0	Underlying product category	TZAF
43	USFGZUTYP	☐	TB_USFGZUT	T_SFGZUTY	NUMC	2	0	Underlying activity category	AT02
44	USGSART	☐	TB_USGSART	VVSART	CHAR	3	0	Product type of underlying	TZPA
45	USFHAART	☐	TB_USFHAAR	T_SFHAART	CHAR	3	0	Transaction Type of Underlying	AT10
46	URGATT	☐	TB_URGATT	T_URGATT	CHAR	13	0	Underlying ID for option/warrant/future	VTIUL
47	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
48	BNOMINAL	☐	BNOMINAL	WERTV8_TR	CURR	15	2	Nominal amount in position currency
49	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
50	SHWHR	☐	VVSHWHR	WAERS	CUKY	5	0	Local currency	TCURC
51	BKAUFWR	☐	BKAUFWR	WERTV8_TR	CURR	15	2	Acquisition value in position currency
52	BKAUFHW	☐	BKAUFHW	WERTV8_TR	CURR	15	2	Acquisition value in local currency
53	BBUCHWR	☐	BBUCHWR	WERTV8_TR	CURR	15	2	Book value in position currency
54	BBUCHHW	☐	BBUCHHW	WERTV8_TR	CURR	15	2	Book value in local currency
55	BKOSTWR	☐	BKOSTWR	WERTV8_TR	CURR	15	2	Capitalized incid.costs acquisition value in pos. currency
56	BKOSTHW	☐	BKOSTHW	WERTV8_TR	CURR	15	2	Capitalized incid.costs acquisition value in local currency
57	BKSTBWR	☐	VVBKSTBWR	WERTV8_TR	CURR	15	2	Book value of capitalized incid. costs in position currency
58	BKSTBHW	☐	VVBKSTBHW	WERTV8_TR	CURR	15	2	Book value of activated incid. costs in local currency
59	BNOMS	☐	BNOMS	BWHR	CURR	13	2	Nominal value
60	BKURSWEFW	☐	TB_BKURSWR	WERTV8_TR	CURR	15	2	Market value of position in position currency
61	BKURSWEHW	☐	TB_BKURSHW	WERTV8_TR	CURR	15	2	Market value of position in local currency
62	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	*
63	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
64	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
65	KKURS	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
66	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
67	.INCLUDE	☐				0	0	Loans reporting structure
68	RANLVD	☐	RANL	RANL	CHAR	13	0	Contract Number
69	BVKWR	☐	VVBVKWR	WERTV8_TR	CURR	15	2	Contract Capital in Position Currency
70	BVKHW	☐	VVBVKHW	WERTV8_TR	CURR	15	2	Contract capital in local currency
71	BZKWR	☐	VVBZKWR	WERTV8_TR	CURR	15	2	Current Commitment Capital in Position Currency
72	BZKHW	☐	VVBZKHW	WERTV8_TR	CURR	15	2	Commitment capital in local currency
73	BRPWR	☐	VVBRPWR	WERTV8_TR	CURR	15	2	Rem. Capital Acc. to Debit Position in Position Currency
74	BRPHW	☐	VVBRPHW	WERTV8_TR	CURR	15	2	Remaining Capital Acc. to Debit Position in Local Currency
75	BRIWR	☐	VVBRIWR	WERTV8_TR	CURR	15	2	Effective Capital in Position Currency
76	BRIHW	☐	VVBRIHW	WERTV8_TR	CURR	15	2	Effective Capital in Local Currency
77	BRVWR	☐	VVBRVWR	WERTV8_TR	CURR	15	2	Available Capital in Position Currency
78	BRVHW	☐	VVBRVHW	WERTV8_TR	CURR	15	2	Available Capital in Local Currency
79	BMIWR	☐	VVBMIWR	WERTV8_TR	CURR	15	2	Capital Reduction in Position Currency
80	BMIHW	☐	VVBMIHW	WERTV8_TR	CURR	15	2	Reductions in local currency
81	BATWR	☐	VVBATSWR	WERTV8_TR	CURR	15	2	Unsched. Repayment: Debit Position in Position Currency
82	BATHW	☐	VVBATSHW	WERTV8_TR	CURR	15	2	Unscheduled Repayment: Debit Position in Local Currency
83	BATZWR	☐	VVBATZWR	WERTV8_TR	CURR	15	2	Unsched. Repayment: Incoming Payments in Position Currency
84	BATZHW	☐	VVBATZHW	WERTV8_TR	CURR	15	2	Unscheduled Repayment: Incoming Payments in Local Currency
85	BPTWR	☐	VVBPTSWR	WERTV8_TR	CURR	15	2	Scheduled Repayment: Debit Position in Position Currency
86	BPTHW	☐	VVBPTSHW	WERTV8_TR	CURR	15	2	Scheduled Repayment: Debit Position in Local Currency
87	BPTZWR	☐	VVBPTZWR	WERTV8_TR	CURR	15	2	Scheduled Repayment: Incoming Payment in Position Currency
88	BPTZHW	☐	VVBPTZHW	WERTV8_TR	CURR	15	2	Scheduled Repayment: Incoming Payment in Local Currency
89	BAVWR	☐	VVBAVWR	WERTV8_TR	CURR	15	2	Disbursement Obligation in Position Currency
90	BAVHW	☐	VVBAVHW	WERTV8_TR	CURR	15	2	Disbursement Obligation in Local Currency
91	BVAWR	☐	VVBVAWR	WERTV8_TR	CURR	15	2	Value-Dated Capital in Position Currency
92	BVAHW	☐	VVBVAHW	WERTV8_TR	CURR	15	2	Value-Dated Capital in Local Currency
93	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
94	SKLASS	☐	VVKLASS	SWPKLASS	NUMC	3	0	Classification	*
95	KBKOND	☐	TB_KBKOND	VVKWKURS	DEC	15	6	Interest amount
96	BNOMI1	☐	TB_BNOMI1	WERTV8_TR	CURR	15	2	Nominal amount of outgoing side
97	BNOMI2	☐	TB_BNOMI2	WERTV8_TR	CURR	15	2	Nominal amount of incoming side
98	.INCLUDE	☐				0	0	General Treasury Partner Data
99	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
100	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
101	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
102	SROLEXT	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
103	SRECHTSF	☐	SRECHTSF	SBETTYP	NUMC	2	0	Indicator for legal form	*
104	SRECHTST	☐	SRECHTST	SRECHTST	NUMC	2	0	Indicator for legal entity	*
105	SRATING	☐	SRATING	SRATING	CHAR	3	0	Rating indicator	*
106	BRSCH	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
107	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
108	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	*
109	XKONTRA	☐	XKONTRA	CHAR10	CHAR	10	0	Text field for contracting party
110	XDPBANK	☐	RDBANK	CHAR10	CHAR	10	0	Depositary bank search term in partner management
111	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
112	.INCLUDE	☐				0	0	Securities reporting structure
113	RDEPOTNR	☐	ABNKR	ABNKR	CHAR	15	0	Securities account no.
114	RDPBANK	☐	RDEPOTBANK	BU_PARTNER	CHAR	10	0	Depository Bank	BUT000
115	RGSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
116	DKEMI	☐	DKEMI	DATUM	DATS	8	0	Issuer call date
117	VERKONTO	☐	VERKONTO	ABNKR	CHAR	15	0	No. of bank giro acct, security acct no. in US secur.accts
118	BSALDO	☐	BSALDO	WERTV7	CURR	13	2	Remaining Balance of a Contract (Account)
119	SOFTYP	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
120	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
121	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
122	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
123	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
124	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VZBEST	BUKRS	T001	BUKRS
2	VZBEST	MANDT	T000	MANDT
3	VZBEST	OFWAERS	TCURC	WAERS
4	VZBEST	RDPBANK	BUT000	PARTNER
5	VZBEST	RGSBER	TGSB	GSBER
6	VZBEST	RPORTB	TWPOB	RPORTB
7	VZBEST	RREFKONT	T037S	RREFKONT
8	VZBEST	SANLF	TZAF	SANLF
9	VZBEST	SBILK	TW11	SBILK
10	VZBEST	SBWHR	TCURC	WAERS
11	VZBEST	SFGTYP	AT01	SFGTYP
12	VZBEST	SFGZUSTT	AT02	SFGZUSTT
13	VZBEST	SFHAART	AT10	SFHAART
14	VZBEST	SGLZB	TW07	SGLZB
15	VZBEST	SGSART	TZPA	GSART
16	VZBEST	SHWHR	TCURC	WAERS
17	VZBEST	SSTATI	TZC37	STATU
18	VZBEST	SWHRKOND	TCURC	WAERS
19	VZBEST	SZSREF	T056R	REFERENZ
20	VZBEST	URGATT	VTIUL	GATTUNG
21	VZBEST	USANLF	TZAF	SANLF
22	VZBEST	USFGZUTYP	AT02	SFGZUSTT
23	VZBEST	USFHAART	AT10	SFHAART
24	VZBEST	USGSART	TZPA	GSART

History

Last changed by/on	SAP	20130529
SAP Release Created in