SAP ABAP Table JBWPORD (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JBWPORD   Table Relationship Diagram
Short Description Generated Table for View    
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 RBELNR RBELKPF RBELKPF CHAR 10   0   Number of flow header *
4 RPOSNR NVORGANG CHAR3 CHAR 3   0   Activity number  
5 RANL VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
6 RLDEPO RLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
7 DVORGANG DVORGANG DATUM DATS 8   0   Activity date  
8 SVORGANG RVORGANG RVORGANG CHAR 8   0   Securities-Activity  
9 SSTATI SSTATI STATI NUMC 2   0   Status of data record *
10 INTEB VVSINTEB INTEB NUMC 2   0   Financial Assets Management internal level *
11 RREFKONT RREFKONT USTRU CHAR 8   0   Account Assignment Reference in Financial Assets Management *
12 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
13 RBELNRFI BELNR_D BELNR CHAR 10   0   Accounting Document Number  
14 RBELNRFI2 BELNR_D BELNR CHAR 10   0   Accounting Document Number  
15 SBLART BLART BLART CHAR 2   0   Document type T003
16 DBLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
17 DBUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
18 DGJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
19 DMONAT MONAT MONAT NUMC 2   0   Fiscal period  
20 RSTBLG STBLG BELNR CHAR 10   0   Reverse Document Number  
21 SSTORNO SSTORNO SSTORNO CHAR 1   0   Reversal indicator  
22 SSTOGRD SSTOGRD SSTOGRD CHAR 2   0   Reason for Reversal TZST
23 DORDER DORDER DATUM DATS 8   0   Order day  
24 DANJRNL DANJRNL DATUM DATS 8   0   Date of transferal to journal  
25 DANFIBU DANFIBU DATUM DATS 8   0   Date of transferal to FiAc  
26 UANFIBU UANFIBU TIMES TIMS 6   0   Time of transfer to financial accounting  
27 SSPESEN SSPESEN SSPESEN CHAR 1   0   Expenses key  
28 NORDER SECPOSITIONNUMBER NUM8 NUMC 8   0   Position number  
29 NORDEXT NORDEXT CHAR20 CHAR 20   0   External order number  
30 RBANKK RBANKK SAKNR CHAR 10   0   Bank account SKA1
31 RKONTRA RKONTRA_NEW BU_PARTNER CHAR 10   0   Reference to Counterparty *
32 SROLEXTKO DUMMY_3 CHAR3 CHAR 3   0   Dummy function  
33 RDEALER RDEALER RDEALER CHAR 12   0   Trader *
34 XZUSATZ XZUSATZ CHAR18 CHAR 18   0   Assignment  
35 SSTCKKZ SSTCKKZ SSTCKKZ CHAR 1   0   Accrued interest method  
36 SSTCKTG SSTCKTG SZBMETH CHAR 1   0   Accrued interest: Daily method  
37 PEFFZINS PEFFZINS DEC3_7 DEC 10   7   Effective Interest Rate  
38 SEFFMETH SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method (Financial Mathematics)  
39 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
40 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
41 SOBJEKT VVKEYOBJ VVKEY CHAR 10   0   Internal key for object  
42 RZBANK VVRZBANK_NEW BU_PARTNER CHAR 10   0   Paying Bank BUT000
43 SROLEXTZB DUMMY_3 CHAR3 CHAR 3   0   Dummy function  
44 DSTOCK VVDSTOCK DATUM DATS 8   0   Premium reserve fund date  
45 RPNNR VVRPNNR VVRPNNR CHAR 10   0   Daybook no.  
46 RHANDPL VVRHANDPL VVRHANDPL CHAR 10   0   Exchange TWH01
47 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
48 SEVALPOST SEVALPOST XFELD CHAR 1   0   PEC for flow executed indicator yes/no  
49 REFRLDEPO VVREFRLDEP RLDEPO CHAR 10   0   Reference sec.acct for sec.acct transfer (inflow/outflow) *
50 TRSEDOCNR1 TRSEDOCNR TRSEDOCNR CHAR 10   0   Document number of security posting document VWPOSTDOC
51 TRSEGJAHR1 GJAHR GJAHR NUMC 4   0   Fiscal Year  
52 TRSEDOCNR2 TRSEDOCNR TRSEDOCNR CHAR 10   0   Document number of security posting document VWPOSTDOC
53 TRSEGJAHR2 GJAHR GJAHR NUMC 4   0   Fiscal Year  
54 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
55 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
56 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
57 DEVALPOST DEVALPOST DATUM DATS 8   0   Date of period-end closing  
58 SHERKUNFT VVSHERK VVSHERK CHAR 1   0   Origin indicator: 'From planned record/actual record'  
59 RFHA TB_RFHA T_RFHA CHAR 13   0   Financial Transaction *
60 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
61 DERF DERF DATUM DATS 8   0   First Entered on  
62 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
63 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
64 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
65 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
66 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
67 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
68 SBEWART SBEWART SBEWART CHAR 4   0   Flow Type TZB0A
69 SBEWZITI SBEWZITI SBEWZITI CHAR 4   0   Flow category TZB03
70 SSOLHAB VVSSOLHAB VVSSOLHAB CHAR 1   0   Debit/credit indicator  
71 SNWHR SNWHR WAERS CUKY 5   0   Currency of nominal amount TCURC
72 SBWHR SBWHR WAERS CUKY 5   0   Position Currency (Currency of Position Amount) TCURC
73 SCWHR SCWHR WAERS CUKY 5   0   Settlement Currency TCURC
74 ASTUECK ASTUECK ASTUECK DEC 15   5   Number of units for unit-quoted securities  
75 BWKURS BWKURS BWKURS CURR 13   2   Security price for unit quotation  
76 BNWHR BNWHR WERTV7 CURR 13   2   Nominal amount  
77 PWKURS PWKURS PWKURS DEC 10   7   Security price for percentage quotation  
78 BBWHR BBWHR WERTV7 CURR 13   2   Amount in position currency  
79 BCWHR BCWHR WERTV7 CURR 13   2   Settlement Amount  
80 BHWHR BHWHR WERTV7 CURR 13   2   Amount in local currency  
81 KURS1 KURSF KURSF DEC 9   5   Exchange rate  
82 KURS2 KURSF KURSF DEC 9   5   Exchange rate  
83 DVALUT VVDZINVAL DATUM DATS 8   0   Interest Value Date/Calculation Date  
84 DDISPO VVDWERTST DATUM DATS 8   0   Value date / planning day  
85 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
86 DBEST6B DBEST6B DATUM DATS 8   0   Date for §6b EstG relevant postings  
87 RSOLL RSOLL SAKNR CHAR 10   0   Account for debit posting SKA1
88 SBSLSOLL BSCHL BSCHL CHAR 2   0   Posting Key *
89 RZKSOLL RZKSOLL SAKNR CHAR 10   0   Debit interim account SKA1
90 SBSLZKSO BSCHL BSCHL CHAR 2   0   Posting Key *
91 RZKHABE RZKHABE SAKNR CHAR 10   0   Credit interim account SKA1
92 SBSLZKHA BSCHL BSCHL CHAR 2   0   Posting Key *
93 RHABEN RHABEN SAKNR CHAR 10   0   Account for credit posting SKA1
94 SBSLHABEN BSCHL BSCHL CHAR 2   0   Posting Key *
95 SWHRT SWHRT SWHRT CHAR 1   0   Currency swap indicator  
96 JONLAEN JONLAEN VVSONLAEN CHAR 1   0   Indicator for fixing a flow record  
97 JZINSBAS JZINSBAS JANEI CHAR 1   0   Flow in interest base  
98 JZINSZPT JZINSZPT JANEI CHAR 1   0   Interest date  
99 PKOND PKOND DECV3_7 DEC 10   7   Percentage rate for condition items  
100 BBASIS BBASIS WERTV7 CURR 13   2   Calculation base amount  
101 DBERVON DBERVON DATUM DATS 8   0   Start of Calculation Period  
102 DBERBIS DBERBIS DATUM DATS 8   0   End of Calculation Period  
103 ATAGE VVATAGE INT6 NUMC 6   0   Number of days  
104 ABASTAGE ABASTAGE INT6 NUMC 6   0   Number of base days in a calculation period  
105 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
106 SKALIDWT TFMSKALIDWT WFCID CHAR 2   0   Interest Calendar *
107 JEXPOZINS TB_JZINSRE XFELD CHAR 1   0   Exponential Interest Calculation  
108 SWOHER TB_SWOHER TB_SWOHER CHAR 1   0   Treasury: Source of flow  
109 JSTOCK VVJSTOCK JANEI CHAR 1   0   Premium reserve fund-relevant indicator  
110 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
111 DFAELL DFAELL DATUM DATS 8   0   Due date  
112 SKOART SKOART SKOART NUMC 4   0   Condition Type (Smallest Subdivision of Condition Records) TZK01
113 SEXCLVON VVSEXCLVON VVSEXCLVON NUMC 1   0   Exclusive Indicator for the Start of a Calculation Period  
114 SULTVON VVSULTVON VVSULT CHAR 1   0   Month-End Indicator for Start of a Calculation Period  
115 SINCLVON VVSINCLBIS VVSINCLBIS NUMC 1   0   Inclusive Indicator for the End of a Calculation Period  
116 SULTBIS VVSULTBIS VVSULT CHAR 1   0   Month-End Indicator for the End of a Calculation Period  
117 DVERRECH VVDVERRECH DATUM DATS 8   0   Settlement date  
118 DPKOND VVDPKOND DATUM DATS 8   0   Determination date for percentage rate of condition items  
119 SREFZITI VVSREFZITI SBEWZITI CHAR 4   0   Refer.flow category in accrual/deferral flow records *
120 SINCL VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
121 SVULT VVSVULT VVSULT CHAR 1   0   Month-End Indicator for Value Date  
122 APERTAGE VVAPERTAGE INT6 NUMC 6   0   No. of days of a (calculation) period in cash flow  
123 STGMETH VVSTGMETH VVSTGMETH NUMC 1   0   Daily Method  
124 STGBASIS VVSTGBASIS VVSTGBASIS CHAR 1   0   Base Days Method  
125 DBPERIOD VVDBPERIOD DATUM DATS 8   0   Period start  
126 SPAEXCL TFMSPAEXCL TFMSPAEXCL NUMC 1   0   Exclusive Indicator for Start Date of a Period  
127 SPAULT TFMSPAULT VVSULT CHAR 1   0   Month-End Indicator for Start Date of a Period  
128 DEPERIOD VVDEPERIOD DATUM DATS 8   0   Period End  
129 SPEINCL TFMSPEINCL TFMSPEINCL NUMC 1   0   Inclusive Indicator for End Date of a Period  
130 SPEULT TFMSPEULT VVSULT CHAR 1   0   Month-End Indicator for End of a Period  
131 SINCLVERR VVSINCLVER VVSINCLVER NUMC 1   0   Inclusive Indicator for Clearing Date  
132 SULTVERR VVSULTVERR VVSULT CHAR 1   0   Month-End Indicator for Clearing Date  
133 DGUEL_KP DGUEL_KP DATUM DATS 8   0   Condition Item Valid From  
134 NSTUFE NSTUFE NUMC2 NUMC 2   0   Level number of condition item for recurring payments  
135 DCOUPON VVDCOUPON DATUM DATS 8   0   Coupon date of next delivered coupon  
136 SCOUPON VVSCOUPON VVSCOUPON CHAR 1   0   Coupon ID for interest and accrued interest calculation  
137 SFLAT VVSFLAT XFELD CHAR 1   0   Indicator 'Traded flat',i.e.no accrued interest calculation  
138 SBERFIMA SBEWFIMA SBEWFIMA CHAR 4   0   Calculation category for cash flow calculator AT40
139 SVORGKZ VVSVORGKZ VVSVORGKZ NUMC 2   0   Activity indicator for debit/credit control  
140 SREFBEW SREFBEW SBEWART CHAR 4   0   Reference flow type *
141 SINCLBIS VVSINCLBIS VVSINCLBIS NUMC 1   0   Inclusive Indicator for the End of a Calculation Period  
142 SSWHR VVSSWHR WAERS CUKY 5   0   Stock price currency TCURC
143 BSWHR VVBSWHR WERTV7 CURR 13   2   Market value  
144 SRUNIT VVSRUNIT VVSRUNIT CHAR 5   0   Currency unit TZUNI
145 KWKURS VVKWKURS VVKWKURS DEC 15   6   Security price  
146 DSCHLUSS VVDSCHLUSS DATUM DATS 8   0   Date of business closing  
147 TSCHLUSS VVTSCHLUSS UZEIT TIMS 6   0   Time of business closing  
148 SBUCHA VVSBUCHA CHAR1 CHAR 1   0   Indicator for postings to accruals/deferrals accounts  
149 RAHABKI TB_RHABKI HBKID CHAR 5   0   Short key for own house bank *
150 RAHKTID TB_RHKTID HKTID CHAR 5   0   Short key for house bank account *
151 RPBANK TB_RPBANK BVTYP CHAR 4   0   Partner bank details  
152 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method *
153 SZART TB_SZART XFELD CHAR 1   0   Payment transaction  
154 KGV_FLAG TKGV TKGV CHAR 1   0   Manages status of the related price gains/losses flows  
155 DZFEST TB_DZFEST DATUM DATS 8   0   Interest rate fixing date  
156 KMNR KMNR VKMNR CHAR 13   0   Corporate Action Number *
157 ERNR TER_HEADNUMBER TER_RIGHTNUMBER CHAR 13   0   ID number of exercised right  
158 SPAYRQ TB_SPAYRQK XFELD CHAR 1   0   Generate payment request  
159 SPRSNG TB_SPRSNGK XFELD CHAR 1   0   Individual payment  
160 PRKEY PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request *
161 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 JBWPORD BUKRS T001 BUKRS KEY 1 CN
2 JBWPORD GSBER TGSB GSBER KEY 1 CN
3 JBWPORD KUNNR KNA1 KUNNR KEY 1 CN
4 JBWPORD MANDT T000 MANDT KEY 1 CN
5 JBWPORD OBJNR ONR00 OBJNR REF 1 1
6 JBWPORD RANL VWPANLA RANL KEY 1 CN
7 JBWPORD RBANKK SKA1 SAKNR KEY 1 1
8 JBWPORD RHABEN SKA1 SAKNR KEY 1 1
9 JBWPORD RHANDPL TWH01 RHANDPL REF C CN
10 JBWPORD RLDEPO TWD01 RLDEPO KEY 1 CN
11 JBWPORD RSOLL SKA1 SAKNR KEY 1 1
12 JBWPORD RZBANK BUT000 PARTNER C CN
13 JBWPORD RZKHABE SKA1 SAKNR KEY 1 1
14 JBWPORD RZKSOLL SKA1 SAKNR KEY 1 1
15 JBWPORD SBERFIMA AT40 SBERFIMA    
16 JBWPORD SBEWART TZB0A SBEWART    
17 JBWPORD SBEWZITI TZB03 SBEWZITI    
18 JBWPORD SBLART T003 BLART KEY 1 1
19 JBWPORD SBWHR TCURC WAERS KEY 1 1
20 JBWPORD SCWHR TCURC WAERS KEY 1 1
21 JBWPORD SKOART TZK01 SKOART REF C CN
22 JBWPORD SNWHR TCURC WAERS KEY 1 1
23 JBWPORD SRUNIT TZUNI SRUNIT KEY 1 CN
24 JBWPORD SSTOGRD TZST SSTOGRD KEY 1 1
25 JBWPORD SSWHR TCURC WAERS KEY 1 CN
26 JBWPORD TRSEDOCNR1 VWPOSTDOC DOCNR KEY C N
27 JBWPORD TRSEDOCNR2 VWPOSTDOC DOCNR KEY C N
History
Last changed by/on SAP  20141121 
SAP Release Created in