SAP ABAP Table VWORDE (Order Data)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities
Basic Data
Table Category TRANSP    Transparent table 
Transparent table VWORDE   Table Relationship Diagram
Short Description Order Data    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 *
2 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
3 NORDER NORDER NUM8 NUMC 8   0   Order Number  
4 DTRANS VVDTRANS DATUM DATS 8   0   Flow data key: System date  
5 TTRANS VVTTRANS UZEIT TIMS 6   0   Transaction data key: system time  
6 NTRANS VVNTRANS NUMC4 NUMC 4   0   Transaction data key: Consecutive number  
7 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
8 DERF DERF DATUM DATS 8   0   First Entered on  
9 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
10 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
11 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
12 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
13 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
14 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
15 RANL VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
16 RLDEPO VRLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
17 SSTATI SSTATI STATI NUMC 2   0   Status of data record TZC37
18 INTEB VVSINTEB INTEB NUMC 2   0   Financial Assets Management internal level *
19 SBEWART SBEWART SBEWART CHAR 4   0   Flow Type TZB0A
20 SBEWZITI SBEWZITI SBEWZITI CHAR 4   0   Flow category TZB03
21 SSOLHAB VVSSOLHAB VVSSOLHAB CHAR 1   0   Debit/credit indicator  
22 DVORGANG DVORGANG DATUM DATS 8   0   Activity date  
23 SVORGANG RVORGANG RVORGANG CHAR 8   0   Securities-Activity  
24 SNWHR SNWHR WAERS CUKY 5   0   Currency of nominal amount TCURC
25 SBWHR SBWHR WAERS CUKY 5   0   Position Currency (Currency of Position Amount) TCURC
26 SCWHR SCWHR WAERS CUKY 5   0   Settlement Currency TCURC
27 ASTUECK ASTUECK ASTUECK DEC 15   5   Number of units for unit-quoted securities  
28 BWKURS BWKURS BWKURS CURR 13   2   Security price for unit quotation  
29 BNWHR BNWHR WERTV7 CURR 13   2   Nominal amount  
30 PWKURS PWKURS PWKURS DEC 10   7   Security price for percentage quotation  
31 BBWHR BBWHR WERTV7 CURR 13   2   Amount in position currency  
32 BCWHR BCWHR WERTV7 CURR 13   2   Settlement Amount  
33 BHWHR BHWHR WERTV7 CURR 13   2   Amount in local currency  
34 KURS1 KURSF KURSF DEC 9   5   Exchange rate  
35 KURS2 KURSF KURSF DEC 9   5   Exchange rate  
36 DORDER DORDER DATUM DATS 8   0   Order day  
37 DVALUT VVDZINVAL DATUM DATS 8   0   Interest Value Date/Calculation Date  
38 DDISPO VVDWERTST DATUM DATS 8   0   Value date / planning day  
39 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
40 DBEST6B DBEST6B DATUM DATS 8   0   Date for §6b EstG relevant postings  
41 SSPESEN SSPESEN SSPESEN CHAR 1   0   Expenses key  
42 SLIMIT SLIMIT SLIMIT CHAR 1   0   Order notation  
43 BLIMIT BLIMIT BWKURS CURR 13   2   Limit price for unit quotation  
44 PLIMIT PLIMIT PWKURS DEC 10   7   Limit price for percentage quotation  
45 RBANKK RBANKK SAKNR CHAR 10   0   Bank account SKB1
46 RKONTRA RKONTRA_NEW BU_PARTNER CHAR 10   0   Reference to Counterparty BUT000
47 SROLEXTKO DUMMY_3 CHAR3 CHAR 3   0   Dummy function  
48 SFDLEV FDLEV FDLEV CHAR 2   0   Planning Level *
49 JFDUPD JFDUPD JANEI CHAR 1   0   Record transferred to cash management and forecast  
50 JONLAEN JONLAEN VVSONLAEN CHAR 1   0   Indicator for fixing a flow record  
51 JZINSBAS JZINSBAS JANEI CHAR 1   0   Flow in interest base  
52 JZINSZPT JZINSZPT JANEI CHAR 1   0   Interest date  
53 PKOND PKOND DECV3_7 DEC 10   7   Percentage rate for condition items  
54 SSTCKKZ SSTCKKZ SSTCKKZ CHAR 1   0   Accrued interest method  
55 SSTCKTG SSTCKTG SZBMETH CHAR 1   0   Accrued interest: Daily method  
56 PEFFZINS PEFFZINS DEC3_7 DEC 10   7   Effective Interest Rate  
57 SEFFMETH SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method (Financial Mathematics)  
58 SCRWHR1 WAERS WAERS CUKY 5   0   Currency Key TCURC
59 SCRWHR2 WAERS WAERS CUKY 5   0   Currency Key TCURC
60 KCROSS KURSF KURSF DEC 9   5   Exchange rate  
61 NORDEXT NORDEXT CHAR20 CHAR 20   0   External order number  
62 SWOHER SWOHER CHAR1 CHAR 1   0   Source of flow record  
63 XZUSATZ XZUSATZ CHAR18 CHAR 18   0   Assignment  
64 DANST DANST DATUM DATS 8   0   Reservation date  
65 TANST TANST TIMES TIMS 6   0   Order time of day  
66 SANST SANST SANST CHAR 2   0   Reservation reason *
67 SABRECH CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
68 SVERFALL CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
69 RDEALER RDEALER RDEALER CHAR 12   0   Trader TZDEA
70 SOBJECT VVKEYOBJ VVKEY CHAR 10   0   Internal key for object  
71 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
72 GSBER GSBER GSBER CHAR 4   0   Business Area *
73 BBASIS BBASIS WERTV7 CURR 13   2   Calculation base amount  
74 DBERVON DBERVON DATUM DATS 8   0   Start of Calculation Period  
75 DBERBIS DBERBIS DATUM DATS 8   0   End of Calculation Period  
76 ATAGE VVATAGE INT6 NUMC 6   0   Number of days  
77 ABASTAGE ABASTAGE INT6 NUMC 6   0   Number of base days in a calculation period  
78 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
79 RZBANK VVRZBANK_NEW BU_PARTNER CHAR 10   0   Paying Bank BUT000
80 SROLEXTZB SROLEXT SROLEXT CHAR 3   0   External role of partner *
81 JVERK6B CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
82 RHANDPL VVRHANDPL VVRHANDPL CHAR 10   0   Exchange TWH01
83 SFLAT VVSFLAT XFELD CHAR 1   0   Indicator 'Traded flat',i.e.no accrued interest calculation  
84 DCOUPON VVDCOUPON DATUM DATS 8   0   Coupon date of next delivered coupon  
85 SCOUPON VVSCOUPON VVSCOUPON CHAR 1   0   Coupon ID for interest and accrued interest calculation  
86 SSWHR VVSSWHR WAERS CUKY 5   0   Stock price currency *
87 BSWHR VVBSWHR WERTV7 CURR 13   2   Market value  
88 SRUNIT VVSRUNIT VVSRUNIT CHAR 5   0   Currency unit *
89 KWKURS VVKWKURS VVKWKURS DEC 15   6   Security price  
90 SINCL VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
91 DSCHLUSS VVDSCHLUSS DATUM DATS 8   0   Date of business closing  
92 TSCHLUSS VVTSCHLUSS UZEIT TIMS 6   0   Time of business closing  
93 SFGKZ VVSFGKZ VVSFGKZ CHAR 1   0   Release Indicator  
94 RAHABKI TB_RHABKI HBKID CHAR 5   0   Short key for own house bank *
95 RAHKTID TB_RHKTID HKTID CHAR 5   0   Short key for house bank account *
96 RPBANK TB_RPBANK BVTYP CHAR 4   0   Partner bank details  
97 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method *
98 SZART TB_SZART XFELD CHAR 1   0   Payment transaction  
99 SEXCLVON VVSEXCLVON VVSEXCLVON NUMC 1   0   Exclusive Indicator for the Start of a Calculation Period  
100 SULTVON VVSULTVON VVSULT CHAR 1   0   Month-End Indicator for Start of a Calculation Period  
101 SINCLBIS VVSINCLBIS VVSINCLBIS NUMC 1   0   Inclusive Indicator for the End of a Calculation Period  
102 SULTBIS VVSULTBIS VVSULT CHAR 1   0   Month-End Indicator for the End of a Calculation Period  
103 PEFFZCALL PEFFZINS DEC3_7 DEC 10   7   Effective Interest Rate  
104 RFHA TB_RFHA T_RFHA CHAR 13   0   Financial Transaction *
105 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
106 SDELETE VVSLOEKZ VVSLOEKZ NUMC 1   0   Deletion indicator  
107 TBEGRU TBEGRU TRBEGRU CHAR 4   0   Authorization Group *
108 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
109 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
110 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
111 DBUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
112 SPAYRQ TB_SPAYRQK XFELD CHAR 1   0   Generate payment request  
113 SPRSNG TB_SPRSNGK XFELD CHAR 1   0   Individual payment  
114 RPZAHL TB_RPZAHL_NEW BU_PARTNER CHAR 10   0   Payer/payee *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VWORDE BUKRS T001 BUKRS KEY 1 CN
2 VWORDE OBJNR ONR00 OBJNR REF 1 1
3 VWORDE RANL VWPANLA RANL KEY 1 CN
4 VWORDE RBANKK SKB1 SAKNR KEY 1 CN
5 VWORDE RDEALER TZDEA RDEALER KEY 1 CN
6 VWORDE RHANDPL TWH01 RHANDPL REF C CN
7 VWORDE RKONTRA BUT000 PARTNER 1 CN
8 VWORDE RLDEPO TWD01 RLDEPO KEY 1 CN
9 VWORDE RZBANK BUT000 PARTNER 1 CN
10 VWORDE SBEWART TZB0A SBEWART KEY 1 CN
11 VWORDE SBEWZITI TZB03 SBEWZITI KEY 1 CN
12 VWORDE SBWHR TCURC WAERS KEY 1 CN
13 VWORDE SCRWHR1 TCURC WAERS KEY 1 CN
14 VWORDE SCRWHR2 TCURC WAERS KEY 1 CN
15 VWORDE SCWHR TCURC WAERS KEY 1 CN
16 VWORDE SNWHR TCURC WAERS KEY 1 CN
17 VWORDE SSTATI TZC37 STATU KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in