SAP ABAP Table VTI_FUTURE (Structure for Futures Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTT (Package) R/3 application development for Treasury forward trading

Basic Data

Table Category	INTTAB	Structure
Structure	VTI_FUTURE	Table Relationship Diagram
Short Description	Structure for Futures Data

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	RANL	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
3	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
4	DJAHR	☐	TI_DJAHR	GJAHR	NUMC	4	0	Expiration year
5	DMONAT	☐	TI_DMOANT	T_DMOANT	NUMC	2	0	Expiration month
6	SOFTYP	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
7	XOFTYP	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
8	SMARGART	☐	TB_MARGART	T_MARGART	CHAR	5	0	Margin type	AT51
9	SNOTTYPE	☐	TI_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type option/future
10	XNOTTYPE	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
11	PPTICK	☐	TI_PPTICK	DECV3_7	DEC	10	7	Tick in percentage points
12	BETICK	☐	TI_BETICK	WERTV7	CURR	13	2	Tick as amount
13	PITICK	☐	TI_PITICK	T_PKTKUR	DEC	11	6	Tick in index points
14	BWTICK	☐	TI_BWTICK	WERTV7	CURR	13	2	Tick value
15	WWTICK	☐	TI_WWTICK	WAERS	CUKY	5	0	Tick Value Currency	TCURC
16	DVERFALL	☐	TI_DVERF	DATUM	DATS	8	0	Expiration date
17	XVERFALL	☐	TI_XVERF	T_XDATUM	CHAR	10	0	Expiration date
18	DLHANDEL	☐	TI_DLHAND	DATUM	DATS	8	0	Last trade date
19	XLHANDEL	☐	TI_XLHAND	T_XDATUM	CHAR	10	0	Last trade date
20	DERFUELL	☐	TI_DERFUE	DATUM	DATS	8	0	Settlement date
21	XERFUELL	☐	TI_XERFUE	T_XDATUM	CHAR	10	0	Settlement date
22	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
23	BNOMS	☐	BNOMS	BWHR	CURR	13	2	Nominal value
24	XNOMS	☐	TI_XNOMS	CHAR18	CHAR	18	0	Nominal value
25	RNWHR	☐	RNWHR	WAERS	CUKY	5	0	Nominal currency	TCURC
26	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
27	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
28	XZSREF	☐	KUZITEXT	TEXT15	CHAR	15	0	Short Text for Reference Interest Rate
29	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
30	DENDF	☐	DENDF	DATUM	DATS	8	0	Final due date
31	XENDF	☐	TI_XENDF	T_XDATUM	CHAR	10	0	Final due date
32	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
33	URANL	☐	RANL	RANL	CHAR	13	0	Contract Number
34	XRANL	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
35	UINDEX	☐	IDX	CHAR10	CHAR	10	0	Securities Index	INDEXD
36	XINDEX	☐	XKURZBEZ	XKBEZ	CHAR	15	0	Short name for ATAB tables
37	BPINDEX	☐	TI_BPINDEX	WERTV7	CURR	13	2	Value of an index point
38	WPINDEX	☐	TI_WPINDEX	WAERS	CUKY	5	0	Index point currency	TCURC
39	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
40	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
41	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
42	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
43	REPKE	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key	BUT000
44	XEPKE	☐	LINES	LINES	CHAR	80	0	Address line
45	BSTRIKE	☐	TI_BSTRIKE	WERTV7	CURR	13	2	Strike as amount
46	WSTRIKE	☐	TI_WSTRIKE	WAERS	CUKY	5	0	Strike Currency	TCURC
47	PKSTRIKE	☐	TI_PKSTRIK	DEC5_4	DEC	9	4	Strike in points
48	IPSTRIKE	☐	TI_IPSTRIK	DECV3_7	DEC	10	7	Strike as inverted percentage notation
49	SPUTCALL	☐	TI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/call indicator
50	XPUTCALL	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
51	SSETTLFL	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
52	XSETTLFL	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
53	SOPTAUS	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
54	XOPTAUS	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
55	SABRMET	☐	TI_SABRMET	T_SABRMET	CHAR	1	0	Settlement Method Option
56	XABRMET	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
57	REWHR	☐	REWHR	WAERS	CUKY	5	0	Issue currency	TCURC
58	XREFDAT	☐	TI_XREFDAT	T_XDATUM	CHAR	10	0	Reference date as text
59	DREFDAT	☐	TI_DREFDAT	DATUM	DATS	8	0	Reference date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTI_FUTURE	MANDT	T000	MANDT		1	CN
2	VTI_FUTURE	REPKE	BUT000	PARTNER		C	CN
3	VTI_FUTURE	REWHR	TCURC	WAERS		C	CN
4	VTI_FUTURE	RNWHR	TCURC	WAERS		C	CN
5	VTI_FUTURE	SGSART	TZPA	GSART		1	CN
6	VTI_FUTURE	SKALID	TFACD	IDENT		C	CN
7	VTI_FUTURE	SMARGART	AT51	MARGART		1	CN
8	VTI_FUTURE	SZSREF	T056R	REFERENZ		C	CN
9	VTI_FUTURE	UINDEX	INDEXD	IDX		C	CN
10	VTI_FUTURE	WPINDEX	TCURC	WAERS		C	CN
11	VTI_FUTURE	WSTRIKE	TCURC	WAERS		C	CN
12	VTI_FUTURE	WWTICK	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in