SAP ABAP View JBWPORD_ALL (View of VWBEKI and WVBEPI (Active Orders))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-DP (Application Component) Transaction Data Pool
     ⤷ JBD (Package) Application development IS-B Data Pool

Basic Data

View Type	D	Database View
Database View	JBWPORD_ALL
Short Description	View of VWBEKI and WVBEPI (Active Orders)
Root table	VWBEKI	Treasury Securities: Actual Flows - Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VWBEKI	VWBEKI
2	VWBEPI

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VWBEKI	MANDT	JL	EQ				0	0
2	VWBEPI	MANDT	JR	EQ			AND	0	0
3	VWBEKI	BUKRS	JL	EQ				0	0
4	VWBEPI	BUKRS	JR	EQ			AND	0	0
5	VWBEKI	RBELNR	JL	EQ				0	0
6	VWBEPI	RBELNR	JR	EQ			AND	0	0
7	VWBEPI	SBEWZITI		EQ	'A'		OR	0	0
8	VWBEPI	SBEWZITI		EQ	'S'		AND	0	0
9	VWBEKI	SSTORNO		EQ	' '			0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in