VWORDE - Order Data

Order Data information is stored in SAP table VWORDE.
It is part of development package FVVW in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Treasury Management: Securities".

Fields for table VWORDE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
NORDER	Order Number	X	NORDER	NUMC	16
DTRANS	Flow data key: System date	X	VVDTRANS	DATS	16
TTRANS	Transaction data key: system time	X	VVTTRANS	TIMS	12
NTRANS	Transaction data key: Consecutive number	X	VVNTRANS	NUMC	8
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
RANL	Security Class ID Number		VVRANLW	CHAR	26	VWPANLA
RLDEPO	Securities Account		VRLDEPO	CHAR	20	TWD01
SSTATI	Status of data record		SSTATI	NUMC	4	TZC37
INTEB	Financial Assets Management internal level		VVSINTEB	NUMC	4	*
SBEWART	Flow Type		SBEWART	CHAR	8	TZB0A
SBEWZITI	Flow category		SBEWZITI	CHAR	8	TZB03
SSOLHAB	Debit/credit indicator		VVSSOLHAB	CHAR	2
DVORGANG	Activity date		DVORGANG	DATS	16
SVORGANG	Securities-Activity		RVORGANG	CHAR	16
SNWHR	Currency of nominal amount		SNWHR	CUKY	10	TCURC
SBWHR	Position Currency (Currency of Position Amount)		SBWHR	CUKY	10	TCURC
SCWHR	Settlement Currency		SCWHR	CUKY	10	TCURC
ASTUECK	Number of units for unit-quoted securities		ASTUECK	DEC	8
BWKURS	Security price for unit quotation		BWKURS	CURR	7
BNWHR	Nominal amount		BNWHR	CURR	7
PWKURS	Security price for percentage quotation		PWKURS	DEC	6
BBWHR	Amount in position currency		BBWHR	CURR	7
BCWHR	Settlement Amount		BCWHR	CURR	7
BHWHR	Amount in local currency		BHWHR	CURR	7
KURS1	Exchange rate		KURSF	DEC	5
KURS2	Exchange rate		KURSF	DEC	5
DORDER	Order day		DORDER	DATS	16
DVALUT	Interest Value Date/Calculation Date		VVDZINVAL	DATS	16
DDISPO	Value Date / Planning Day		VVDWERTST	DATS	16
DBESTAND	Position value date		DBESTAND	DATS	16
DBEST6B	Date for �6b EstG relevant postings		DBEST6B	DATS	16
SSPESEN	Expenses key		SSPESEN	CHAR	2
SLIMIT	Order notation		SLIMIT	CHAR	2
BLIMIT	Limit price for unit quotation		BLIMIT	CURR	7
PLIMIT	Limit price for percentage quotation		PLIMIT	DEC	6
RBANKK	Bank account		RBANKK	CHAR	20	SKB1
RKONTRA	Reference to Counterparty		RKONTRA_NEW	CHAR	20	BUT000
SROLEXTKO	Dummy function		DUMMY_3	CHAR	6
SFDLEV	Planning Level		FDLEV	CHAR	4	*
JFDUPD	Record transferred to cash management and forecast		JFDUPD	CHAR	2
JONLAEN	Indicator for fixing a flow record		JONLAEN	CHAR	2
JZINSBAS	Flow in interest base		JZINSBAS	CHAR	2
JZINSZPT	Interest date		JZINSZPT	CHAR	2
PKOND	Percentage rate for condition items		PKOND	DEC	6
SSTCKKZ	Accrued interest method		SSTCKKZ	CHAR	2
SSTCKTG	Accrued interest: Daily method		SSTCKTG	CHAR	2
PEFFZINS	Effective Interest Rate		PEFFZINS	DEC	6
SEFFMETH	Effective Interest Method (Financial Mathematics)		SEFFMETH	NUMC	2
SCRWHR1	Currency Key		WAERS	CUKY	10	TCURC
SCRWHR2	Currency Key		WAERS	CUKY	10	TCURC
KCROSS	Exchange rate		KURSF	DEC	5
NORDEXT	External order number		NORDEXT	CHAR	40
SWOHER	Source of flow record		SWOHER	CHAR	2
XZUSATZ	Assignment		XZUSATZ	CHAR	36
DANST	Reservation date		DANST	DATS	16
TANST	Order time of day		TANST	TIMS	12
SANST	Reservation reason		SANST	CHAR	4	*
SABRECH	Single-Character Flag		CHAR1	CHAR	2
SVERFALL	Single-Character Flag		CHAR1	CHAR	2
RDEALER	Trader		RDEALER	CHAR	24	TZDEA
SOBJECT	Internal key for object		VVKEYOBJ	CHAR	20
KOSTL	Cost Center		KOSTL	CHAR	20	*
GSBER	Business Area		GSBER	CHAR	8	*
BBASIS	Calculation Base Amount		BBASIS	CURR	7
DBERVON	Start of Calculation Period		DBERVON	DATS	16
DBERBIS	End of Calculation Period		DBERBIS	DATS	16
ATAGE	Number of Days		VVATAGE	NUMC	12
ABASTAGE	Number of base days in a calculation period		ABASTAGE	NUMC	12
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
RZBANK	Paying Bank		VVRZBANK_NEW	CHAR	20	BUT000
SROLEXTZB	External role of partner		SROLEXT	CHAR	6	*
JVERK6B	Single-Character Flag		CHAR1	CHAR	2
RHANDPL	Exchange		VVRHANDPL	CHAR	20	TWH01
SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation		VVSFLAT	CHAR	2
DCOUPON	Coupon date of next delivered coupon		VVDCOUPON	DATS	16
SCOUPON	Coupon ID for interest and accrued interest calculation		VVSCOUPON	CHAR	2
SSWHR	Stock price currency		VVSSWHR	CUKY	10	*
BSWHR	Market value		VVBSWHR	CURR	7
SRUNIT	Currency unit		VVSRUNIT	CHAR	10	*
KWKURS	Security price		VVKWKURS	DEC	8
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
DSCHLUSS	Date of business closing		VVDSCHLUSS	DATS	16
TSCHLUSS	Time of business closing		VVTSCHLUSS	TIMS	12
SFGKZ	Release Indicator		VVSFGKZ	CHAR	2
RAHABKI	Short Key for Own House Bank		TB_RHABKI	CHAR	10	*
RAHKTID	Short Key for House Bank Account		TB_RHKTID	CHAR	10	*
RPBANK	Partner Bank Details		TB_RPBANK	CHAR	8
SZART	Payment Transaction		TB_SZART	CHAR	2
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period		VVSEXCLVON	NUMC	2
SULTVON	Month-End Indicator for Start of a Calculation Period		VVSULTVON	CHAR	2
SINCLBIS	Inclusive Indicator for the End of a Calculation Period		VVSINCLBIS	NUMC	2
SULTBIS	Month-End Indicator for the End of a Calculation Period		VVSULTBIS	CHAR	2
PEFFZCALL	Effective Interest Rate		PEFFZINS	DEC	6
RFHA	Financial Transaction		TB_RFHA	CHAR	26	*
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
SDELETE	Deletion indicator		VVSLOEKZ	NUMC	2
TBEGRU	Authorization Group		TBEGRU	CHAR	8	*
REFER	Internal Reference		TB_REFER	CHAR	32
MERKM	Characteristics		TB_MERKM	CHAR	50
DBUDAT	Posting Date in the Document		BUDAT	DATS	16
SPAYRQ	Generate Payment Request		TB_SPAYRQK	CHAR	2
SPRSNG	Individual Payment		TB_SPRSNGK	CHAR	2
RPZAHL	Payer/Payee		TB_RPZAHL_NEW	CHAR	20	*