SAP ABAP View V_VTB2TRD (View of Transaction Flows and TRD Flows)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTA (Package) R/3 appl. development for Treasury money,forex,forward gen

Basic Data

View Type	D	Database View
Database View	V_VTB2TRD
Short Description	View of Transaction Flows and TRD Flows
Root table	VTB2TRD	Link Between Financial Transaction Flow and Distributor Flow

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VTB2TRD	VTB2TRD
2	VTBFHAPO
3	TRDT_TRDBUSTRANS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VTB2TRD	MANDT	JL	EQ				0	0
2	VTBFHAPO	MANDT	JR	EQ			AND	0	0
3	VTB2TRD	BUKRS	JL	EQ				0	0
4	VTBFHAPO	BUKRS	JR	EQ			AND	0	0
5	VTB2TRD	RFHA	JL	EQ				0	0
6	VTBFHAPO	RFHA	JR	EQ			AND	0	0
7	VTB2TRD	RFHAZU	JL	EQ				0	0
8	VTBFHAPO	RFHAZU	JR	EQ			AND	0	0
9	VTB2TRD	DCRDAT	JL	EQ				0	0
10	VTBFHAPO	DCRDAT	JR	EQ			AND	0	0
11	VTB2TRD	TCRTIM	JL	EQ				0	0
12	VTBFHAPO	TCRTIM	JR	EQ			AND	0	0
13	VTB2TRD	RFHAZB	JL	EQ				0	0
14	VTBFHAPO	RFHAZB	JR	EQ			AND	0	0
15	VTB2TRD	MANDT	JL	EQ				0	0
16	TRDT_TRDBUSTRANS	MANDT	JR	EQ			AND	0	0
17	VTB2TRD	EXTBUSTRANSID	JL	EQ				0	0
18	TRDT_TRDBUSTRANS	EXTBUSTRANSID	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	200