SAP ABAP Table VTIDERI (Master Data Listed Options and Futures)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ TR (Application Component) Treasury
     ⤷ FTT_CORE (Package) Former FTT Objects Required in AL0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTIDERI	Table Relationship Diagram
Short Description	Master Data Listed Options and Futures

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	VWPANLA
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	SOPTTYP	☐	TV_OPTTYP	T_OPTTYP	NUMC	3	0	Original option category (on closing)	ATO1
8	SABRMET	☐	TI_SABRMET	T_SABRMET	CHAR	1	0	Settlement Method Option
9	SMARGART	☐	TB_MARGART	T_MARGART	CHAR	5	0	Margin type	AT51
10	SNOTTYPE	☐	TI_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type option/future
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	SPUTCALL	☐	TI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/call indicator
17	SSETTLFL	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
18	SOPTAUS	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
19	DVERFALL	☐	TI_DVERF	DATUM	DATS	8	0	Expiration date
20	DLHANDEL	☐	TI_DLHAND	DATUM	DATS	8	0	Last trade date
21	DERFUELL	☐	TI_DERFUE	DATUM	DATS	8	0	Settlement date
22	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
23	BNOMS	☐	BNOMS	BWHR	CURR	13	2	Nominal value
24	RNWHR	☐	RNWHR	WAERS	CUKY	5	0	Nominal currency	TCURC
25	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
26	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
27	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
28	DENDF	☐	DENDF	DATUM	DATS	8	0	Final due date
29	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
30	URANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
31	UINDEX	☐	IDX	CHAR10	CHAR	10	0	Securities Index	INDEXD
32	BPINDEX	☐	TI_BPINDEX	WERTV7	CURR	13	2	Value of an index point
33	WPINDEX	☐	TI_WPINDEX	WAERS	CUKY	5	0	Index point currency	TCURC
34	BSTRIKE	☐	TI_BSTRIKE	WERTV7	CURR	13	2	Strike as amount
35	WSTRIKE	☐	TI_WSTRIKE	WAERS	CUKY	5	0	Strike Currency	TCURC
36	PKSTRIKE	☐	TI_PKSTRIK	DEC5_4	DEC	9	4	Strike in points
37	IPSTRIKE	☐	TI_IPSTRIK	DECV3_7	DEC	10	7	Strike as inverted percentage notation
38	.INCLU--AP	☐				0	0	Append Structure for VTIDERI
39	DEBEG	☐	DEBEG	DATUM	DATS	8	0	Issue start date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTIDERI	MANDT	T000	MANDT		1	CN
2	VTIDERI	RANL	VWPANLA	RANL		1	C
3	VTIDERI	RNWHR	TCURC	WAERS		C	CN
4	VTIDERI	SGSART	TZPA	GSART		1	CN
5	VTIDERI	SKALID	TFACD	IDENT		C	CN
6	VTIDERI	SMARGART	AT51	MARGART	REF	C	CN
7	VTIDERI	SOPTTYP	ATO1	OPTTYP	REF	C	CN
8	VTIDERI	SZSREF	T056R	REFERENZ		C	CN
9	VTIDERI	UINDEX	INDEXD	IDX		C	CN
10	VTIDERI	URANL	VWPANLA	RANL		C	CN
11	VTIDERI	WPINDEX	TCURC	WAERS		C	CN
12	VTIDERI	WSTRIKE	TCURC	WAERS		C	CN
13	VTIDERI	WWTICK	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in