SAP ABAP Table VTIORDER (Structure for Order Items Listed Derivatives)

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	VTIORDER	Table Relationship Diagram
Short Description	Structure for Order Items Listed Derivatives

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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RFHA	☑	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
4	RFHAZU	☑	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
5	DCRDAT	☑	TB_CRDAT	DATUM	DATS	8	0	Entered On
6	TCRTIM	☑	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
7	RFHAZB	☑	TB_RFHAZB	T_RFHAZB	NUMC	4	0	Transaction flow
8	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
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	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
13	SFHAZBA	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	TZB0A
14	SBKKLAS	☐	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
15	SBKTYP	☐	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions	*
16	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
17	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
18	SHERKUNFT	☐	TB_SHERK	T_XFELD04	CHAR	4	0	Display Area of Flow or Condition
19	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
20	RKOND	☐	TB_KOND	T_KOND	NUMC	4	0	Condition
21	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
22	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
23	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
24	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
25	SBZVABW	☐	TB_SBZVABW	XFELD	CHAR	1	0	Alternative payment details stated in flow
26	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
27	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
28	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
29	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
30	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
31	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
32	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
33	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
34	SSPRGRD	☐	TB_SSPRGRD	T_SSPRGRD	NUMC	1	0	Reason Why Flow Is Blocked for Posting
35	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
36	SSTORNOBWG	☐	TB_SBWGSTO	XFELD	CHAR	1	0	Flow reversal in Treasury
37	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
38	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
39	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
40	DBUCHUNG	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
41	DFAELL	☐	TB_DFAELL	DATUM	DATS	8	0	Due date
42	DZTERM	☐	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
43	BZBETR	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
44	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
45	BHWBETR	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
46	KHWKURS	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
47	ASTUECK	☐	TB_ASTUECK	ASTUECK	DEC	15	5	No. of Units for Financial Instruments
48	XPRICE	☐	TI_XPRICE	CHAR18	CHAR	18	0	Price or rate
49	BPRICE	☐	TB_BPRICE	WERTV7	CURR	13	2	Price per unit
50	WPRICE	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	TCURC
51	BHWPREIS	☐	TB_HWPREIS	WERTV7	CURR	13	2	Price in local currency
52	BINDEX	☐	TB_BINDEX	BWHR	CURR	13	2	Value of a point
53	VVBASIS	☐	TB_VVBASIS	T_PKTKUR	DEC	11	6	Price in points
54	PWKURS	☐	TB_PWKURS	DEC3_7	DEC	10	7	Price as percentage quotation
55	BNWHR	☐	TB_BNWHR	WERTV7	CURR	13	2	Nominal amount
56	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
57	SKURSART	☐	TI_KURSART	VVSKURSART	CHAR	2	0	Rate/Price Type - Treasury Instruments	*
58	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
59	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
60	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
61	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
62	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
63	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
64	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
65	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
66	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
67	WBASIS	☐	TB_WBASIS	WAERS	CUKY	5	0	Currency of calculation basis	*
68	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
69	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
70	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
71	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
72	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
73	SAEND	☐	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
74	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
75	SVINCL	☐	VVSVINCL	VVSINCL	NUMC	1	0	Inclusive indicator for value date
76	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
77	SSTORNOMAN	☐	TB_SBWGSTM	T_SBWGSTM	CHAR	1	0	Manual reversal of flows posted in FI
78	SSTORNOART	☐	TB_SSTOART	T_SSTOART	CHAR	2	0	Type of manual reversal of flows posted in FI	*
79	SBWGARTREF	☐	TB_SBWGREF	SBEWART	CHAR	4	0	Referenced flow type	*
80	SKHWFIX	☐	TB_SKHWFIX	T_SKHWFIX	CHAR	1	0	Indicator for translation into local currency
81	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
82	XMERK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
83	XBEWART	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
84	XZTERM	☐	TB_XZTERM	T_XDATUM	CHAR	10	0	Payment or Delivery Date
85	RANL	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
86	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
87	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
88	DJAHR	☐	TI_DJAHR	GJAHR	NUMC	4	0	Expiration year
89	DMONAT	☐	TI_DMOANT	T_DMOANT	NUMC	2	0	Expiration month
90	SOFTYP	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
91	SOPTTYP	☐	TV_OPTTYP	T_OPTTYP	NUMC	3	0	Original option category (on closing)	ATO1
92	SMARGART	☐	TB_MARGART	T_MARGART	CHAR	5	0	Margin type	AT51
93	SNOTTYPE	☐	TI_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type option/future
94	PPTICK	☐	TI_PPTICK	DECV3_7	DEC	10	7	Tick in percentage points
95	BETICK	☐	TI_BETICK	WERTV7	CURR	13	2	Tick as amount
96	PITICK	☐	TI_PITICK	T_PKTKUR	DEC	11	6	Tick in index points
97	BWTICK	☐	TI_BWTICK	WERTV7	CURR	13	2	Tick value
98	WWTICK	☐	TI_WWTICK	WAERS	CUKY	5	0	Tick Value Currency	TCURC
99	SPUTCALL	☐	TI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/call indicator
100	SSETTLFL	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
101	SOPTAUS	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
102	DVERFALL	☐	TI_DVERF	DATUM	DATS	8	0	Expiration date
103	DLHANDEL	☐	TI_DLHAND	DATUM	DATS	8	0	Last trade date
104	DERFUELL	☐	TI_DERFUE	DATUM	DATS	8	0	Settlement date
105	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
106	BNOMS	☐	BNOMS	BWHR	CURR	13	2	Nominal value
107	RNWHR	☐	RNWHR	WAERS	CUKY	5	0	Nominal currency	TCURC
108	UPKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
109	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
110	USZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
111	DENDF	☐	DENDF	DATUM	DATS	8	0	Final due date
112	UASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
113	URANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
114	UINDEX	☐	IDX	CHAR10	CHAR	10	0	Securities Index
115	BPINDEX	☐	TI_BPINDEX	WERTV7	CURR	13	2	Value of an index point
116	WPINDEX	☐	TI_WPINDEX	WAERS	CUKY	5	0	Index point currency	TCURC
117	BSTRIKE	☐	TI_BSTRIKE	WERTV7	CURR	13	2	Strike as amount
118	WSTRIKE	☐	TI_WSTRIKE	WAERS	CUKY	5	0	Strike Currency	TCURC
119	PKSTRIKE	☐	TI_PKSTRIK	DEC5_4	DEC	9	4	Strike in points
120	IPSTRIKE	☐	TI_IPSTRIK	DECV3_7	DEC	10	7	Strike as inverted percentage notation
121	RTRBELNR	☐	TPM_DEDOC_RDOCNRINT	TPM_DEDOC_RDOCNRINT	CHAR	15	0	Internal document number of derivatives document
122	FISTOGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	T041C
123	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTIORDER	BUKRS	T001	BUKRS		1	CN
2	VTIORDER	FISTOGRD	T041C	STGRD
3	VTIORDER	MANDT	T000	MANDT		1	CN
4	VTIORDER	RHANDPL	TWH01	RHANDPL		C	CN
5	VTIORDER	RNWHR	TCURC	WAERS		C	CN
6	VTIORDER	SANLF	TZAF	SANLF		1	CN
7	VTIORDER	SFHAZBA	TZB0A	SBEWART		1	CN
8	VTIORDER	SKALID	TFACD	IDENT		C	CN
9	VTIORDER	SMARGART	AT51	MARGART		C	CN
10	VTIORDER	SOPTTYP	ATO1	OPTTYP		C	CN
11	VTIORDER	SZSREF	T056R	REFERENZ		C	CN
12	VTIORDER	URANL	VWPANLA	RANL		C	CN
13	VTIORDER	WPINDEX	TCURC	WAERS		C	CN
14	VTIORDER	WPRICE	TCURC	WAERS		C	CN
15	VTIORDER	WSTRIKE	TCURC	WAERS		C	CN
16	VTIORDER	WWTICK	TCURC	WAERS		C	CN
17	VTIORDER	WZBETR	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in