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

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_VTIDERI	Table Relationship Diagram
Short Description	Master Data Listed Options and Futures

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	.INCLUDE	☐				0	0	Master Data Listed Options and Futures
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
4	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
5	DJAHR	☐	TI_DJAHR	GJAHR	NUMC	4	0	Expiration year
6	DMONAT	☐	TI_DMOANT	T_DMOANT	NUMC	2	0	Expiration month
7	SOFTYP	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
8	SOPTTYP	☐	TV_OPTTYP	T_OPTTYP	NUMC	3	0	Original option category (on closing)	*
9	SABRMET	☐	TI_SABRMET	T_SABRMET	CHAR	1	0	Settlement Method Option
10	SMARGART	☐	TB_MARGART	T_MARGART	CHAR	5	0	Margin type	*
11	SNOTTYPE	☐	TI_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type option/future
12	PPTICK	☐	TI_PPTICK	DECV3_7	DEC	10	7	Tick in percentage points
13	BETICK	☐	TI_BETICK	WERTV7	CURR	13	2	Tick as amount
14	PITICK	☐	TI_PITICK	T_PKTKUR	DEC	11	6	Tick in index points
15	BWTICK	☐	TI_BWTICK	WERTV7	CURR	13	2	Tick value
16	WWTICK	☐	TI_WWTICK	WAERS	CUKY	5	0	Tick Value Currency	TCURC
17	SPUTCALL	☐	TI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/call indicator
18	SSETTLFL	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
19	SOPTAUS	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
20	DVERFALL	☐	TI_DVERF	DATUM	DATS	8	0	Expiration date
21	DLHANDEL	☐	TI_DLHAND	DATUM	DATS	8	0	Last trade date
22	DERFUELL	☐	TI_DERFUE	DATUM	DATS	8	0	Settlement date
23	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
24	BNOMS	☐	BNOMS	BWHR	CURR	13	2	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	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
29	DENDF	☐	DENDF	DATUM	DATS	8	0	Final due date
30	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
31	URANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
32	UINDEX	☐	IDX	CHAR10	CHAR	10	0	Securities Index	INDEXD
33	BPINDEX	☐	TI_BPINDEX	WERTV7	CURR	13	2	Value of an index point
34	WPINDEX	☐	TI_WPINDEX	WAERS	CUKY	5	0	Index point currency	TCURC
35	BSTRIKE	☐	TI_BSTRIKE	WERTV7	CURR	13	2	Strike as amount
36	WSTRIKE	☐	TI_WSTRIKE	WAERS	CUKY	5	0	Strike Currency	TCURC
37	PKSTRIKE	☐	TI_PKSTRIK	DEC5_4	DEC	9	4	Strike in points
38	IPSTRIKE	☐	TI_IPSTRIK	DECV3_7	DEC	10	7	Strike as inverted percentage notation
39	.INCLU--AP	☐				0	0	Append Structure for VTIDERI
40	DEBEG	☐	DEBEG	DATUM	DATS	8	0	Issue start date
41	BETICK_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
42	BWTICK_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
43	BNOMS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
44	BPINDEX_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
45	BSTRIKE_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in