SAP ABAP Table V_VTB2TRD (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_VTB2TRD	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RFHA	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
4	RFHAZU	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity	VTBFHAZU
5	DCRDAT	TB_CRDAT	DATUM	DATS	8	0	Entered On
6	TCRTIM	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
7	RFHAZB	TB_RFHAZB	T_RFHAZB	NUMC	4	0	Transaction flow
8	EXTBUSTRANSID	TPM_EXTBUSTRANSID	TPM_EXTBUSTRANSID	CHAR	60	0	Default ID from Creator for Distributor Business Transaction
9	FLOW_NUMBER	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
10	CRUSER	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
11	UPUSER	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
12	DUPDAT	TB_DUPDAT	DATUM	DATS	8	0	Changed on
13	TUPTIM	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
14	RANTYP	RANTYP	RANTYP	CHAR	1	0	Contract Type
15	SFHAZBA	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type
16	SBKKLAS	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
17	SBKTYP	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions
18	SBERFIMA	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator
19	SSIGN	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
20	SHERKUNFT	TB_SHERK	T_XFELD04	CHAR	4	0	Display Area of Flow or Condition
21	SABVERF	TB_SABVERF	T_SABVERF	CHAR	5	0	Procedure to Generate Derived Flows
22	RKONDGR	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
23	RKOND	TB_KOND	T_KOND	NUMC	4	0	Condition
24	DGUEL_KP	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
25	NSTUFE	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
26	SKOART	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)
27	RREFKONT	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management
28	SBZVABW	TB_SBZVABW	XFELD	CHAR	1	0	Alternative payment details stated in flow
29	RAHABKI	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank
30	RAHKTID	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account
31	SBEWEBE	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
32	SSPRGRD	TB_SSPRGRD	T_SSPRGRD	NUMC	1	0	Reason Why Flow Is Blocked for Posting
33	SBFREI	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
34	SSTORNOBWG	TB_SBWGSTO	XFELD	CHAR	1	0	Flow reversal in Treasury
35	PRKEY	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request
36	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
37	BELNR2	TB_BELNR2	BELNR	CHAR	10	0	Doc. no. of a second accounting doc. for currency swap
38	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
39	DBUCHUNG	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
40	DFAELL	TB_DFAELL	DATUM	DATS	8	0	Due date
41	DZTERM	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
42	BZBETR	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
43	WZBETR	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
44	BHWBETR	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
45	KHWKURS	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
46	ASTUECK	TB_ASTUECK	ASTUECK	DEC	15	5	No. of Units for Financial Instruments
47	BPRICE	TB_BPRICE	WERTV7	CURR	13	2	Price per unit
48	WPRICE	TB_WPRICE	WAERS	CUKY	5	0	Price currency
49	BHWPREIS	TB_HWPREIS	WERTV7	CURR	13	2	Price in local currency
50	BINDEX	TB_BINDEX	BWHR	CURR	13	2	Value of a point
51	VVBASIS	TB_VVBASIS	T_PKTKUR	DEC	11	6	Price in points
52	PWKURS	TB_PWKURS	DEC3_7	DEC	10	7	Price as percentage quotation
53	PRKKURS	TI_PRKUR	TB_KKURS	DEC	13	9	Currency option premium with price in points
54	BNWHR	TB_BNWHR	WERTV7	CURR	13	2	Nominal amount
55	RHANDPL	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange
56	SKURSART	TI_KURSART	VVSKURSART	CHAR	2	0	Rate/Price Type - Treasury Instruments
57	DBERVON	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
58	DBERBIS	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
59	ATAGE	VVATAGE	INT6	NUMC	6	0	Number of days
60	ABASTAGE	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
61	PKOND	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
62	DPKOND	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
63	DZFEST	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
64	SZBMETH	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
65	SKALIDWT	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar
66	BBASIS	BBASIS	WERTV7	CURR	13	2	Calculation base amount
67	WBASIS	TB_WBASIS	WAERS	CUKY	5	0	Currency of calculation basis	TCURC
68	JEXPOZINS	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
69	SINCL	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
70	SINCLBIS	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
71	SULTBIS	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
72	SEXCLVON	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
73	SULTVON	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
74	SAEND	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
75	DVALUT	DVALUT	DATUM	DATS	8	0	Calculation Date
76	SVINCL	VVSVINCL	VVSINCL	NUMC	1	0	Inclusive indicator for value date
77	SVULT	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
78	JSOFVERR	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
79	DVERRECH	VVDVERRECH	DATUM	DATS	8	0	Settlement date
80	SINCLVERR	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
81	SULTVERR	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
82	SSTORNOMAN	TB_SBWGSTM	T_SBWGSTM	CHAR	1	0	Manual reversal of flows posted in FI
83	SSTORNOART	TB_SSTOART	T_SSTOART	CHAR	2	0	Type of manual reversal of flows posted in FI
84	SBWGARTREF	TB_SBWGREF	SBEWART	CHAR	4	0	Referenced flow type
85	SKHWFIX	TB_SKHWFIX	T_SKHWFIX	CHAR	1	0	Indicator for translation into local currency
86	ZUONR	DZUONR	ZUONR	CHAR	18	0	Assignment number
87	RLDEPO	RLDEPO	RLDEPO	CHAR	10	0	Securities Account
88	RANL	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number
89	RTRBELNR	TPM_DEDOC_RDOCNRINT	TPM_DEDOC_RDOCNRINT	CHAR	15	0	Internal document number of derivatives document
90	BUPRC	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
91	BPPRC	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
92	WBBETR	TB_WBBETR	WAERS	CUKY	5	0	Currency of Position Amount
93	BBBETR	TB_BBBETR	WERTV7	CURR	13	2	Amount that Changes the Position
94	WEBETR	TB_WEBETR	WAERS	CUKY	5	0	Price currency
95	BEBETR	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
96	SRUNIT	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate
97	KZWKURS	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
98	KBWKURS	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
99	WSBETR	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency
100	DBESTAND	TB_DBESTAND	DATUM	DATS	8	0	Position Value Date
101	SSTCKKZ	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
102	SSTCKTG	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
103	SFLAT	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
104	SCOUPON	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
105	DCOUPON	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
106	AWKEY	AWKEY	AWKEY	CHAR	20	0	Object key
107	INDEX_VALUE	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
108	SBASIS	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator
109	REGI_STATE	TB_IRA_REGISTRATION_STATE	T_IRA_REGISTRATION_STATE	CHAR	2	0	Status of Interest Rate Adjustment
110	HEDGE_ID	TPM_HEDGE_ID		CHAR	10	0	Identification for Hedging Relationship
111	DBPERIOD	VVDBPERIOD	DATUM	DATS	8	0	Period start
112	SPAEXCL	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
113	SPAULT	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
114	DEPERIOD	VVDEPERIOD	DATUM	DATS	8	0	Period End
115	SPEINCL	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
116	SPEULT	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
117	AMMRHY	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
118	PPAYMENT	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
119	AMMRHYZV	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
120	BDIRTY	TB_BDIRTY	WERTV7	CURR	13	2	Dirty Price
121	BAMOUNTCOMP	TB_AMOUNTCOMP	WERTV7	CURR	13	2	Amount to be Capitalized
122	RPZAHL	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee
123	RPBANK	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
124	SZART	TB_SZART	XFELD	CHAR	1	0	Payment transaction
125	ZLSCH	DZLSCH	ZLSCH	CHAR	1	0	Payment method
126	UZAWE	UZAWE	UZAWE	CHAR	2	0	Payment method supplement
127	SPAYRQ	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
128	SPRSNG	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
129	SPRGRD	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
130	SCSPAY	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
131	ZWELS	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
132	PAYGR	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
133	RPCODE	RPCODE	RPCODE	CHAR	20	0	Repetitive Code
134	RP_TEXT	RPCODE_TEXT	XTEXT50	CHAR	50	0	Reference Text for Repetitive Code
135	LZBKZ	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
136	LANDL	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
137	OS_GUID	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
138	USER_DATA_OID	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
139	VERSION	TPM_TRDVERSION	TPM_TRDVERSION	CHAR	6	0	Distributor Version in Generation of Data
140	OWNER	TPM_BUSTRANS_OWNER	TPM_BUSTRANS_OWNER	INT1	3	0	Origin of a Distributor Business Transaction
141	COMPANY_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
142	VALUATION_AREA	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
143	BUSTRANSID	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
144	BUSTRANSCAT	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
145	PRODUCT_GROUP	TPM_PRODUCT_GROUP	TPM_PRODUCT_GROUP	NUMC	3	0	Product Group
146	PRODUCT_CATEGORY	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
147	BUSTRANS_STATE	TPM_BUSTRANS_STATE	TPM_BUSTRANS_STATE	CHAR	1	0	Status of Distributor Business Transaction
148	PLANNED_ACTION	TPM_PLANNED_ACTION	TPM_PLANNED_ACTION	INT1	3	0	Planned Action in a Business Transaction
149	POSITION_DATE	TPM_POSTING_DATE	DATUM	DATS	8	0	Posting Date for the Subledger
150	CREATE_DATE	TPM_BT_CREATE_DATE	DATUM	DATS	8	0	Creation Date of the Operative Business Transaction
151	CREATE_TIME	TPM_BT_CREATE_TIME	UZEIT	TIMS	6	0	Creation Time of the Operative Business Transaction
152	REF_BUSTRANSID	TPM_REFBUSTRANSID	SYSUUID	RAW	16	0	Business Transaction ID of Reference Business Transaction
153	TR_REV_REASON	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
154	DOCUMENT_DATE	BLDAT	DATUM	DATS	8	0	Document Date in Document
155	FI_POST_DATE	TPM_FI_POSTING_DATE	DATUM	DATS	8	0	Different FI Posting Date
156	FI_POST_PERIOD	TPM_FI_POSTING_PERIOD	MONAT	NUMC	2	0	Different FI Posting Period
157	FI_REV_DATE	TPM_FI_REVERSAL_DATE	DATUM	DATS	8	0	Different FI Reversal Date
158	FI_REV_PERIOD	TPM_FI_REVERSAL_PERIOD	MONAT	NUMC	2	0	Alternative FI Reversal Period
159	DEAL_NUMBER	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_VTB2TRD	BUKRS	T001	BUKRS	KEY	1	CN
2	V_VTB2TRD	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	KEY	1	CN
3	V_VTB2TRD	COMPANY_CODE	T001	BUKRS	KEY	1	CN
4	V_VTB2TRD	LANDL	T005	LAND1
5	V_VTB2TRD	LZBKZ	T015L	LZBKZ
6	V_VTB2TRD	MANDT	T000	MANDT	KEY	1	CN
7	V_VTB2TRD	PRODUCT_CATEGORY	TZAF	SANLF	KEY	1	CN
8	V_VTB2TRD	RFHA	VTBFHA	RFHA	KEY	1	CN
9	V_VTB2TRD	RFHAZU	VTBFHAZU	RFHAZU	KEY	1	CN
10	V_VTB2TRD	TR_REV_REASON	TZST	SSTOGRD	KEY	1	CN
11	V_VTB2TRD	USER_DATA_OID	TRGT_USER_DATA	OS_GUID	KEY	1	CN
12	V_VTB2TRD	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA	KEY	1	CN
13	V_VTB2TRD	WBASIS	TCURC	WAERS
14	V_VTB2TRD	WZBETR	TCURC	WAERS	KEY	1	CN