SAP Table VWORDE

Order data

The table VWORDE (Order data) is a standard table in SAP ERP. It belongs to the package FVVW.

Technical Information

Table	VWORDE
Short Text	Order data
Package	FVVW
Table Type	Transparent Table

Fields for Table VWORDE

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