SAP ABAP Table JBRBEST (General Risk Management position structure)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-MR (Application Component) Market Risk Analyzer
     ⤷ FTB (Package) Applic. development R/3 Treasury risk simulation analysis

Basic Data

Table Category	INTTAB	Structure
Structure	JBRBEST	Table Relationship Diagram
Short Description	General Risk Management position structure

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	RKEY1	☐	JBRKEY22	JBRKEY22	CHAR	22	0	Key field comprising 22 characters
3	RKEY2	☐	JBRKEY2	JBRKEY2	CHAR	2	0	Key field comprising 2 characters
4	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
5	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
6	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
7	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
8	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
9	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
10	SNOTTYPE	☐	TB_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type for option, future, security etc.
11	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
12	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
13	BNOMINAL	☐	BNOMINAL	WERTV8_TR	CURR	15	2	Nominal amount in position currency
14	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
15	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	*
16	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
17	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
18	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
19	URGATT	☐	TB_URGATT	T_URGATT	CHAR	13	0	Underlying ID for option/warrant/future	*
20	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
21	BSALDO	☐	BSALDO	WERTV7	CURR	13	2	Remaining Balance of a Contract (Account)
22	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
23	IDX	☐	IDX	CHAR10	CHAR	10	0	Securities Index	INDEXD
24	SOFTYP	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
25	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
26	KKURS	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
27	RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
28	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	JBRBEST	IDX	INDEXD	IDX		1	CN
2	JBRBEST	MANDT	T000	MANDT		1	CN
3	JBRBEST	SANLF	TZAF	SANLF		1	CN
4	JBRBEST	SBWHR	TCURC	WAERS
5	JBRBEST	SFGTYP	AT01	SFGTYP
6	JBRBEST	SGSART	TZPA	GSART		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in