SAP VWORDE Order Data Table

Overview

VWORDE is a standard SAP S/4HANA table that stores Order Data data. There are total 114 fields in the VWORDE table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VWORDE belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package Treasury Management: Securities (FVVW).

In addition, following links provide an overview of foreign key relationships, if any, that link VWORDE to other SAP tables and standard CDS views available based on VWORDE table in S/4HANA 2020.

Techincal Settings of VWORDE

Below are technical details of the table VWORDE

Buffering not allowed
No buffering
Storage type is Column Store

List of VWORDE Fields

The following table gives you an overview of the fields available in VWORDE

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	*	CLNT	3
BUKRS	Company Code	BUKRS	T001	CHAR	4
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 Creation	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 Class ID Number	VVRANLW	VWPANLA	CHAR	13
RLDEPO	Securities Account	VRLDEPO	TWD01	CHAR	10
SSTATI	Status of data record	SSTATI	TZC37	NUMC	2
INTEB	Financial Assets Management internal level	VVSINTEB	*	NUMC	2
SBEWART	Flow Type	SBEWART	TZB0A	CHAR	4
SBEWZITI	Flow category	SBEWZITI	TZB03	CHAR	4
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	TCURC	CUKY	5
SBWHR	Position Currency (Currency of Position Amount)	SBWHR	TCURC	CUKY	5
SCWHR	Settlement Currency	SCWHR	TCURC	CUKY	5
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	SKB1	CHAR	10
RKONTRA	Reference to Counterparty	RKONTRA_NEW	BUT000	CHAR	10
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	TCURC	CUKY	5
SCRWHR2	Currency Key	WAERS	TCURC	CUKY	5
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 Flag	CHAR1		CHAR	1
SVERFALL	Single-Character Flag	CHAR1		CHAR	1
RDEALER	Trader	RDEALER	TZDEA	CHAR	12
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	BUT000	CHAR	10
SROLEXTZB	External role of partner	SROLEXT	*	CHAR	3
JVERK6B	Single-Character Flag	CHAR1		CHAR	1
RHANDPL	Exchange	VVRHANDPL	TWH01	CHAR	10
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	ONR00	CHAR	22
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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VWORDE

Table Name	Field	Cardinality	Check Table
VWORDE	BUKRS	1: CN	T001
VWORDE	OBJNR	1: 1	ONR00
VWORDE	RANL	1: CN	VWPANLA
VWORDE	RBANKK	1: CN	SKB1
VWORDE	RDEALER	1: CN	TZDEA
VWORDE	RHANDPL	C: CN	TWH01
VWORDE	RKONTRA	1: CN	BUT000
VWORDE	RLDEPO	1: CN	TWD01
VWORDE	RZBANK	1: CN	BUT000
VWORDE	SBEWART	1: CN	TZB0A
VWORDE	SBEWZITI	1: CN	TZB03
VWORDE	SBWHR	1: CN	TCURC
VWORDE	SCRWHR1	1: CN	TCURC
VWORDE	SCRWHR2	1: CN	TCURC
VWORDE	SCWHR	1: CN	TCURC
VWORDE	SNWHR	1: CN	TCURC
VWORDE	SSTATI	1: CN	TZC37

SAP VWORDE Order Data Table

Overview

Techincal Settings of VWORDE

List of VWORDE Fields

Foreign Key Relationships

Other References