SAP ABAP Table JBRBPBEST (RM: Structure for JBRBEST + BP Supplements)

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	JBRBPBEST	Table Relationship Diagram
Short Description	RM: Structure for JBRBEST + BP Supplements

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	.INCLUDE	☐				0	0	RM: Base Portfolio - Additional Information
2	SICHTID	☐	JBRSICHTID	JBRSICHTID	CHAR	3	0	View of an Analysis Structure	*
3	BPID	☐	JBRBPID	JBRBPID	CHAR	12	0	Base Portfolio ID	*
4	WAEHRUNG	☐	JBWAER	JBWAER	CUKY	5	0	Currency
5	CFART	☐	JBRCFART_D	JBRCFART	CHAR	3	0	Cash Flow Type	*
6	OBJNR	☐	JBOBJNR	J_OBJNR	CHAR	22	0	Object number for financial transactions	*
7	APKENNZ	☐	JBRAKTPAS	JBRAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
8	BETRAG	☐	JBBBBETR	WERTV9	CURR	17	2	Position - Nominal Amount
9	DKAUFPREIS	☐	JBBDKPREIS	WERTV9	CURR	17	2	Average Purchase Price
10	MENGE	☐	JBABMENG	MENGE	QUAN	13	3	Position - Number of Units
11	MEINHEIT	☐	JBSMPREI	MEINS	UNIT	3	0	Unit of Measure for Position	*
12	SALDENART	☐	JBSSART	JBSSART	CHAR	3	0	Control Indicator for Balance Type	*
13	SALDO	☐	JBBSALDO	T_BETRAG	CURR	17	2	Acct balance
14	.INCLUDE	☐				0	0	General Risk Management position structure
15	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
16	RKEY1	☐	JBRKEY22	JBRKEY22	CHAR	22	0	Key field comprising 22 characters
17	RKEY2	☐	JBRKEY2	JBRKEY2	CHAR	2	0	Key field comprising 2 characters
18	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
19	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
20	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
21	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
22	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
23	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
24	SNOTTYPE	☐	TB_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type for option, future, security etc.
25	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
26	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
27	BNOMINAL	☐	BNOMINAL	WERTV8_TR	CURR	15	2	Nominal amount in position currency
28	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
29	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	*
30	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
31	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
32	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
33	URGATT	☐	TB_URGATT	T_URGATT	CHAR	13	0	Underlying ID for option/warrant/future	*
34	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
35	BSALDO	☐	BSALDO	WERTV7	CURR	13	2	Remaining Balance of a Contract (Account)
36	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
37	IDX	☐	IDX	CHAR10	CHAR	10	0	Securities Index	INDEXD
38	SOFTYP	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
39	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
40	KKURS	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
41	RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
42	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBRBPBEST	IDX	INDEXD	IDX		1	CN
2	JBRBPBEST	MANDT	T000	MANDT		1	CN
3	JBRBPBEST	SANLF	TZAF	SANLF		1	CN
4	JBRBPBEST	SBWHR	TCURC	WAERS
5	JBRBPBEST	SFGTYP	AT01	SFGTYP
6	JBRBPBEST	SGSART	TZPA	GSART		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in