SAP ABAP Table JBRLISTVDD (RM: Template for List of Summarized Data Drilldown)

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	JBRLISTVDD	Table Relationship Diagram
Short Description	RM: Template for List of Summarized Data Drilldown

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in