SAP ABAP Table VZTRDAT (General transaction data structure Treasury)

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	VZTRDAT	Table Relationship Diagram
Short Description	General transaction data structure Treasury

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	*
2	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
5	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
6	RANLVD	☐	RANL	RANL	CHAR	13	0	Contract Number
7	RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
8	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
9	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	*
10	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
11	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
12	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	*
13	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
14	SHWHR	☐	VVSHWHR	WAERS	CUKY	5	0	Local currency	*
15	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
16	DIS_FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	*
17	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
18	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
19	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
20	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
21	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
22	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
23	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
24	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
25	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
26	BKOND	☐	TB_BKOND	WERTV7	CURR	13	2	Interest rate as amount
27	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	*
28	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
29	SFORMREF	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	*
30	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	*
31	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
32	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	*
33	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	*
34	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
35	SZSREFVZ	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
36	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
37	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	*
38	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
39	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
40	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
41	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
42	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
43	RPNNR	☐	VVRPNNR	VVRPNNR	CHAR	10	0	Daybook no.
44	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
45	SVORGANG	☐	RVORGANG	RVORGANG	CHAR	8	0	Securities-Activity
46	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	*
47	SVORGKZ	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
48	KURS1	☐	KURSF	KURSF	DEC	9	5	Exchange rate
49	KURS2	☐	KURSF	KURSF	DEC	9	5	Exchange rate
50	SRUNIT	☐	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	*
51	KWKURS	☐	VVKWKURS	VVKWKURS	DEC	15	6	Security price
52	PWKURS	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
53	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
54	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
55	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
56	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
57	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
58	PSTRIKE	☐	TB_PSTRIKE	DECV3_7	DEC	10	7	Strike for cap/floor
59	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
60	JSOFVERR	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
61	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
62	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
63	TSCHLUSS	☐	VVTSCHLUSS	UZEIT	TIMS	6	0	Time of business closing
64	SREFZITI	☐	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
65	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
66	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
67	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
68	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
69	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
70	S_SSDREF	☐	VVS_SSDREF	SBEWZITI	CHAR	4	0	Reference flow category in borrower's note loan flow records	*
71	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
72	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
73	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
74	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
75	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
76	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
77	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
78	SOFFSET	☐	TV_SOFFSET	DECV3_7	DEC	10	7	Fixer offset for variable interest rate reference

History

Last changed by/on	SAP	20130529
SAP Release Created in