SAP ABAP Table JBRRPGAPEX (RM: Gap Eval. Results Structure for Drilldown Reporting)

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	JBRRPGAPEX	Table Relationship Diagram
Short Description	RM: Gap Eval. Results Structure for Drilldown Reporting

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	DATUM	☐	JBREVALDAT	SYDATS	DATS	8	0	Date of Evaluation
3	AUSWERTUNG	☐	JBREVAL_D	JBREVAL	CHAR	4	0	ID of Risk Management Evaluation	JBREVAL
4	SICHTID	☐	JBRSICHTID	JBRSICHTID	CHAR	3	0	View of an Analysis Structure	JBRSI
5	BPID	☐	JBRBPID	JBRBPID	CHAR	12	0	Base Portfolio ID	JBRBP
6	PHID	☐	JBRPHID	JBRPHID	NUMC	3	0	Portfolio Hierarchy	JBRPH
7	NAME	☐	JBRNAME	JBRNAME	CHAR	30	0	Node in Portfolio Hierarchy
8	RSIMLFNR	☐	JBRSIMLFNR	JBRSIMLFNR	CHAR	12	0	Number of a Simulation Run or Planning Run
9	RSIMBSTD	☐	JBRIDBSTD	JBRIDBSTD	CHAR	20	0	Internal Number for Position of Generic Transactions	*
10	LZBDATUM	☐	JBRLZBDATE	SYDATS	DATS	8	0	Date in Maturity Band Raster
11	LIQUIDST	☐	JBRLIQUID	JBRLIQ	CHAR	1	0	Liquidity Indicator for Cash Flow
12	BILKENNZ	☐	JBRBILKZ	JBRBILKZ	CHAR	1	0	Balance Sheet Indicator (On-Bal.Sheet/Off-Bal.Sheet)
13	DELTA_KNZ	☐	JBRKNZDELT	JBROPDELTA	CHAR	1	0	Treatment of Options (Gap Evaluation)
14	AGIO_KNZ	☐	JBRAGIOKNZ	JBRAUSWEIS	CHAR	1	0	Processing Indicator for Premium/Discount
15	.INCLUDE	☐				0	0	RM: Include for Gap Key Figures in Transaction Currency
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	DBS_A_Z	☐	JBRDBAZ	WERTV9	CURR	17	2	Asset-Side Average Position: Interest Rate Commitment
18	DBS_A_K	☐	JBRDBAK	WERTV9	CURR	17	2	Asset-Side Average Position: Capital Commitment
19	DBS_P_Z	☐	JBRDBPZ	WERTV9	CURR	17	2	Liability-Side Average Position: Interest Rate Commitment
20	DBS_P_K	☐	JBRDBPK	WERTV9	CURR	17	2	Liability-Side Average Position: Capital Commitment
21	SBS_A_Z	☐	JBRSBAZ	WERTV9	CURR	17	2	Gap: Asset-Side Key Date Position: Interest Commitment
22	SBS_A_K	☐	JBRSBAK	WERTV9	CURR	17	2	Gap: Asset-Side Key Date Position: Capital Commitment
23	SBS_P_Z	☐	JBRSBPZ	WERTV9	CURR	17	2	Gap: Liability-Side Key Date Position: Interest Commitment
24	SBS_P_K	☐	JBRSBPK	WERTV9	CURR	17	2	Gap: Liability-Side Key Date Position: Capital Commitment
25	ABL_A_Z	☐	JBRABAZ	WERTV9	CURR	17	2	Maturity of Asset: Interest Rate Commitment
26	ABL_A_K	☐	JBRABAK	WERTV9	CURR	17	2	Maturity of Asset: Capital Commitment
27	ABL_P_Z	☐	JBRABPZ	WERTV9	CURR	17	2	Maturity of Liability: Interest Rate Commitment
28	ABL_P_K	☐	JBRABPK	WERTV9	CURR	17	2	Maturity of Liability: Capital Commitment
29	CFL_A	☐	JBRCFLA	WERTV9	CURR	17	2	Asset-Side Cash Flow
30	CFL_P	☐	JBRCFLP	WERTV9	CURR	17	2	Liability-Side Cash Flow
31	LIQU_A	☐	JBRLIQUA	WERTV9	CURR	17	2	Asset-Side Liquidity
32	LIQU_P	☐	JBRLIQUP	WERTV9	CURR	17	2	Liability-Side Liquidity
33	GPZ_DB_A_Z	☐	JBRPZDBAZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Int Cmmt
34	GPZ_DB_A_K	☐	JBRPZDBAK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Cap.Cmmt
35	GPZ_DB_P_Z	☐	JBRPZDBPZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Int Cmmt
36	GPZ_DB_P_K	☐	JBRPZDBPK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Cap.Cmmt
37	GPZ_SB_A_Z	☐	JBRPZSBAZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Int Cmmt
38	GPZ_SB_A_K	☐	JBRPZSBAK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Cap.Cmmt
39	GPZ_SB_P_Z	☐	JBRPZSBPZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Int Cmmt
40	GPZ_SB_P_K	☐	JBRPZSBPK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Cap.Cmmt
41	GPZ_AB_A_Z	☐	JBRPZABAZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Maturity: Int Cmmt
42	GPZ_AB_A_K	☐	JBRPZABAK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Maturity: Cap.Cmmt
43	GPZ_AB_P_Z	☐	JBRPZABPZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Maturity: Int Cmmt
44	GPZ_AB_P_K	☐	JBRPZABPK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Maturity: Cap.Cmmt
45	.INCLUDE	☐				0	0	Gap: Fields in Display Currency
46	DBS_A_Z_AW	☐	JBRDBAZW	WERTV9	CURR	17	2	Asset-Side Average Position: Interest Rate Commitment in DC
47	DBS_A_K_AW	☐	JBRDBAKW	WERTV9	CURR	17	2	Asset-Side Average Position: Capital Commitment in DC
48	DBS_P_Z_AW	☐	JBRDBPZW	WERTV9	CURR	17	2	Liability-Side Average Position: Interest Rate Commt in DC
49	DBS_P_K_AW	☐	JBRDBPKW	WERTV9	CURR	17	2	Liability-Side Average Position: Capital Commitment in DC
50	SBS_A_Z_AW	☐	JBRSBAZW	WERTV9	CURR	17	2	Gap: Asset-Side Key Date Position: Interest Commitment in DC
51	SBS_A_K_AW	☐	JBRSBAKW	WERTV9	CURR	17	2	Gap: Asset-Side Key Date Position: Capital Commitment in DC
52	SBS_P_Z_AW	☐	JBRSBPZW	WERTV9	CURR	17	2	Gap: Liab.-Side Key Date Position: Interest Commitment in DC
53	SBS_P_K_AW	☐	JBRSBPKW	WERTV9	CURR	17	2	Gap: Liab.-Side Key Date Position: Capital Commitment in DC
54	ABL_A_Z_AW	☐	JBRABAZW	WERTV9	CURR	17	2	Maturity of Asset: Interest Rate Commitment in Display Crcy
55	ABL_A_K_AW	☐	JBRABAKW	WERTV9	CURR	17	2	Maturity of Asset: Capital Commitment in Display Currency
56	ABL_P_Z_AW	☐	JBRABPZW	WERTV9	CURR	17	2	Maturity of Liability: Interest Rate Commt in Display Crcy
57	ABL_P_K_AW	☐	JBRABPKW	WERTV9	CURR	17	2	Maturity of Liability: Capital Commitment in Display Crcy
58	CFL_A_AW	☐	JBRCFLAW	WERTV9	CURR	17	2	Asset-Side Cash Flow in Display Currency
59	CFL_P_AW	☐	JBRCFLPW	WERTV9	CURR	17	2	Liability-Side Cash Flow in Display Currency
60	LIQU_A_AW	☐	JBRLIQUAW	WERTV9	CURR	17	2	Asset-Side Liquidity in Display Currency
61	LIQU_P_AW	☐	JBRLIQUPW	WERTV9	CURR	17	2	Liability-Side Liquidity in Display Currency
62	GPW_DB_A_Z	☐	JBRPWDBAZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Int Cmmt DC
63	GPW_DB_A_K	☐	JBRPWDBAK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Cap.Cmmt DC
64	GPW_DB_P_Z	☐	JBRPWDBPZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Int Cmmt DC
65	GPW_DB_P_K	☐	JBRPWDBPK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Cap.Cmmt DC
66	GPW_SB_A_Z	☐	JBRPWSBAZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Int Cmmt DC
67	GPW_SB_A_K	☐	JBRPWSBAK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Cap.Cmmt DC
68	GPW_SB_P_Z	☐	JBRPWSBPZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Int Cmmt DC
69	GPW_SB_P_K	☐	JBRPWSBPK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Cap.Cmmt DC
70	GPW_AB_A_Z	☐	JBRPWABAZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Maturity: Int Cmmt DC
71	GPW_AB_A_K	☐	JBRPWABAK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Asset-Side Maturity: Cap.Cmmt DC
72	GPW_AB_P_Z	☐	JBRPWABPZ	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Maturity: Int Cmmt DC
73	GPW_AB_P_K	☐	JBRPWABPK	WERTV9	CURR	17	2	Vol.-Weighted Prod.Int of Liab.-Side Maturity: Cap.Cmmt DC
74	ANZGW	☐	JBRANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
75	.INCLUDE	☐				0	0	Additional Selections for Risk Management
76	PKNOTEN	☐	JBRPKNOTEN	JBRPHKNID	NUMC	6	0	Node in Portfolio Hierarchy	*
77	LZB	☐	JBRLZB_D	JBRLZB	CHAR	4	0	Maturity Band	JBRLZB
78	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBRRPGAPEX	ANZGW	TCURC	WAERS
2	JBRRPGAPEX	AUSWERTUNG	JBREVAL	AUSWERTUNG
3	JBRRPGAPEX	BPID	JBRBP	BPID
4	JBRRPGAPEX	LZB	JBRLZB	LZB
5	JBRRPGAPEX	MANDT	T000	MANDT
6	JBRRPGAPEX	PHID	JBRPH	PHID
7	JBRRPGAPEX	SICHTID	JBRSI	SICHTID
8	JBRRPGAPEX	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in