SAP ABAP Table JBWPORD_ALL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JBWPORD_ALL	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_ALL	BUKRS	T001	BUKRS	KEY	1	CN
2	JBWPORD_ALL	GSBER	TGSB	GSBER	KEY	1	CN
3	JBWPORD_ALL	KUNNR	KNA1	KUNNR	KEY	1	CN
4	JBWPORD_ALL	MANDT	T000	MANDT	KEY	1	CN
5	JBWPORD_ALL	OBJNR	ONR00	OBJNR	REF	1	1
6	JBWPORD_ALL	RANL	VWPANLA	RANL	KEY	1	CN
7	JBWPORD_ALL	RBANKK	SKA1	SAKNR	KEY	1	1
8	JBWPORD_ALL	RHABEN	SKA1	SAKNR	KEY	1	1
9	JBWPORD_ALL	RHANDPL	TWH01	RHANDPL	REF	C	CN
10	JBWPORD_ALL	RLDEPO	TWD01	RLDEPO	KEY	1	CN
11	JBWPORD_ALL	RSOLL	SKA1	SAKNR	KEY	1	1
12	JBWPORD_ALL	RZBANK	BUT000	PARTNER		C	CN
13	JBWPORD_ALL	RZKHABE	SKA1	SAKNR	KEY	1	1
14	JBWPORD_ALL	RZKSOLL	SKA1	SAKNR	KEY	1	1
15	JBWPORD_ALL	SBERFIMA	AT40	SBERFIMA
16	JBWPORD_ALL	SBEWART	TZB0A	SBEWART
17	JBWPORD_ALL	SBEWZITI	TZB03	SBEWZITI
18	JBWPORD_ALL	SBLART	T003	BLART	KEY	1	1
19	JBWPORD_ALL	SBWHR	TCURC	WAERS	KEY	1	1
20	JBWPORD_ALL	SCWHR	TCURC	WAERS	KEY	1	1
21	JBWPORD_ALL	SKOART	TZK01	SKOART	REF	C	CN
22	JBWPORD_ALL	SNWHR	TCURC	WAERS	KEY	1	1
23	JBWPORD_ALL	SRUNIT	TZUNI	SRUNIT	KEY	1	CN
24	JBWPORD_ALL	SSTOGRD	TZST	SSTOGRD	KEY	1	1
25	JBWPORD_ALL	SSWHR	TCURC	WAERS	KEY	1	CN
26	JBWPORD_ALL	TRSEDOCNR1	VWPOSTDOC	DOCNR	KEY	C	N
27	JBWPORD_ALL	TRSEDOCNR2	VWPOSTDOC	DOCNR	KEY	C	N

History

Last changed by/on	SAP	20141121
SAP Release Created in