SAP ABAP Table VTBRATE (Rate for Activity)

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

Table Category	TRANSP	Transparent table
Transparent table	VTBRATE	Table Relationship Diagram
Short Description	Rate for Activity

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	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
5	RKURS	☑	TB_RKURS	T_RKURS	NUMC	2	0	Sequential Number for Activity/Class Rates/Prices
6	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
7	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
8	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
9	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
10	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
11	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
12	DFESTSP	☐	TB_DFESTSP	DATUM	DATS	8	0	Planned rate fixing date
13	TFESTSP	☐	TB_TFESTSP	SYTIME	TIMS	6	0	Planned rate fixing time
14	DFESTSI	☐	TB_DFESTSI	DATUM	DATS	8	0	Actual rate fixing date
15	TFESTSI	☐	TB_TFESTSI	SYTIME	TIMS	6	0	Actual time of rate fixing
16	JMANU	☐	TB_JMANU	XFELD	CHAR	1	0	Indicator: Manual entry
17	REFERENZ	☐	REFERENZ	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
18	ZSOLL	☐	DZINSSATZ	ZINSSATZ	DEC	10	7	Interest rate
19	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
20	SPOT1	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
21	SPOT2	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
22	SWAP1	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
23	SWAP2	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
24	SPOT_SE	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
25	SRUNIT_SE	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
26	RFEEDNAME	☐	TB_DFNAME	T_DFCHAR10	CHAR	10	0	Market Data: Data Provider	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTBRATE	BUKRS	T001	BUKRS	KEY	1	CN
2	VTBRATE	MANDT	T000	MANDT	KEY	1	CN
3	VTBRATE	REFERENZ	T056R	REFERENZ	KEY	1	CN
4	VTBRATE	RFHA	VTBFHA	RFHA	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in