SAP ABAP Table JBRIORDE (RM: Reduced VWORDE Structure for Forw. Securities Selection)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-RA (Application Component) Risk Analysis
     ⤷ JBR (Package) Application development IS-B Risk Mangement

Basic Data

Table Category	INTTAB	Structure
Structure	JBRIORDE	Table Relationship Diagram
Short Description	RM: Reduced VWORDE Structure for Forw. Securities Selection

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
3	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
4	RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
5	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
6	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
7	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
8	INTEB	☐	VVSINTEB	INTEB	NUMC	2	0	Financial Assets Management internal level	*
9	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
10	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
11	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
12	DVORGANG	☐	DVORGANG	DATUM	DATS	8	0	Activity date
13	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
14	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
15	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
16	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
17	BWKURS	☐	BWKURS	BWKURS	CURR	13	2	Security price for unit quotation
18	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
19	PWKURS	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
20	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
21	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
22	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
23	KURS1	☐	KURSF	KURSF	DEC	9	5	Exchange rate
24	KURS2	☐	KURSF	KURSF	DEC	9	5	Exchange rate
25	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
26	DVALUT	☐	VVDZINVAL	DATUM	DATS	8	0	Interest Value Date/Calculation Date
27	DDISPO	☐	VVDWERTST	DATUM	DATS	8	0	Value date / planning day
28	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
29	SLIMIT	☐	SLIMIT	SLIMIT	CHAR	1	0	Order notation
30	BLIMIT	☐	BLIMIT	BWKURS	CURR	13	2	Limit price for unit quotation
31	PLIMIT	☐	PLIMIT	PWKURS	DEC	10	7	Limit price for percentage quotation
32	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	BUT000
33	JZINSBAS	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
34	JZINSZPT	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
35	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
36	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
37	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
38	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
39	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
40	SCRWHR1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	SCRWHR2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
42	KCROSS	☐	KURSF	KURSF	DEC	9	5	Exchange rate
43	NORDEXT	☐	NORDEXT	CHAR20	CHAR	20	0	External order number
44	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
45	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
46	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
47	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
48	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
49	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
50	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
51	DCOUPON	☐	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
52	SCOUPON	☐	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
53	SSWHR	☐	VVSSWHR	WAERS	CUKY	5	0	Stock price currency	*
54	BSWHR	☐	VVBSWHR	WERTV7	CURR	13	2	Market value
55	SRUNIT	☐	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	*
56	KWKURS	☐	VVKWKURS	VVKWKURS	DEC	15	6	Security price
57	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
58	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
59	TSCHLUSS	☐	VVTSCHLUSS	UZEIT	TIMS	6	0	Time of business closing
60	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
61	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
62	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
63	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
64	PEFFZCALL	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
65	SDELETE	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
66	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBRIORDE	BUKRS	T001	BUKRS	KEY	1	CN
2	JBRIORDE	OBJNR	ONR00	OBJNR	REF	1	1
3	JBRIORDE	RANL	VWPANLA	RANL	KEY	1	CN
4	JBRIORDE	RDEALER	TZDEA	RDEALER	KEY	1	CN
5	JBRIORDE	RHANDPL	TWH01	RHANDPL	REF	C	CN
6	JBRIORDE	RKONTRA	BUT000	PARTNER		1	CN
7	JBRIORDE	SBEWART	TZB0A	SBEWART	KEY	1	CN
8	JBRIORDE	SBEWZITI	TZB03	SBEWZITI	KEY	1	CN
9	JBRIORDE	SBWHR	TCURC	WAERS	KEY	1	CN
10	JBRIORDE	SCRWHR1	TCURC	WAERS	KEY	1	CN
11	JBRIORDE	SCRWHR2	TCURC	WAERS	KEY	1	CN
12	JBRIORDE	SCWHR	TCURC	WAERS	KEY	1	CN
13	JBRIORDE	SNWHR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in