JBRRPGAPEX SAP (RM: Gap Eval. Results Structure for Drilldown Reporting) Structure details
Description: RM: Gap Eval. Results Structure for Drilldown Reporting
Structure field list including key, data, relationships and ABAP select examples
JBRRPGAPEX is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "RM: Gap Eval. Results Structure for Drilldown Reporting" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_JBRRPGAPEX TYPE JBRRPGAPEX.
The JBRRPGAPEX table consists of various fields, each holding specific information or linking keys about RM: Gap Eval. Results Structure for Drilldown Reporting data available in SAP. These include DATUM (Date of Evaluation), AUSWERTUNG (ID of Risk Management Evaluation), SICHTID (View of an Analysis Structure), BPID (Base Portfolio ID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP JBRRPGAPEX structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
DATUM | Date of Evaluation | JBREVALDAT | DATS | 8 | SYDATS | RMAUSWDATUM | |||
AUSWERTUNG | ID of Risk Management Evaluation | JBREVAL_D | CHAR | 4 | JBREVAL | JBREVAL | |||
SICHTID | View of an Analysis Structure | JBRSICHTID | CHAR | 3 | JBRSI | JBRSICHTID | SICHTID | ||
BPID | Base Portfolio ID | JBRBPID | CHAR | 12 | JBRBP | JBRBPID | |||
PHID | Portfolio Hierarchy | JBRPHID | NUMC | 3 | JBRPH | JBRPHID | PHID | S_AFWCH_PH | |
NAME | Node in Portfolio Hierarchy | JBRNAME | CHAR | 30 | PNAME | JBRNAME | |||
RSIMLFNR | Number of a Simulation Run or Planning Run | JBRSIMLFNR | CHAR | 12 | ALPHA | JBRSIMLFNR | RMSIMR | S_JBRSIMLFNR | |
RSIMBSTD | Internal Number for Position of Generic Transactions | JBRIDBSTD | CHAR | 20 | Assigned to domain | ALPHA | JBRIDBSTD | RIDBSTD | S_JBRDBRTBSTD_RIDBSTDEXT |
LZBDATUM | Date in Maturity Band Raster | JBRLZBDATE | DATS | 8 | SYDATS | ||||
LIQUIDST | Liquidity Indicator for Cash Flow | JBRLIQUID | CHAR | 1 | JBRLIQ | ||||
BILKENNZ | Balance Sheet Indicator (On-Bal.Sheet/Off-Bal.Sheet) | JBRBILKZ | CHAR | 1 | JBRBILKZ | ||||
DELTA_KNZ | Treatment of Options (Gap Evaluation) | JBRKNZDELT | CHAR | 1 | JBROPDELTA | ||||
AGIO_KNZ | Processing Indicator for Premium/Discount | JBRAGIOKNZ | CHAR | 1 | JBRAUSWEIS | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
DBS_A_Z | Asset-Side Average Position: Interest Rate Commitment | JBRDBAZ | CURR | 17(2) | WERTV9 | ||||
DBS_A_K | Asset-Side Average Position: Capital Commitment | JBRDBAK | CURR | 17(2) | WERTV9 | ||||
DBS_P_Z | Liability-Side Average Position: Interest Rate Commitment | JBRDBPZ | CURR | 17(2) | WERTV9 | ||||
DBS_P_K | Liability-Side Average Position: Capital Commitment | JBRDBPK | CURR | 17(2) | WERTV9 | ||||
SBS_A_Z | Gap: Asset-Side Key Date Position: Interest Commitment | JBRSBAZ | CURR | 17(2) | WERTV9 | ||||
SBS_A_K | Gap: Asset-Side Key Date Position: Capital Commitment | JBRSBAK | CURR | 17(2) | WERTV9 | ||||
SBS_P_Z | Gap: Liability-Side Key Date Position: Interest Commitment | JBRSBPZ | CURR | 17(2) | WERTV9 | ||||
SBS_P_K | Gap: Liability-Side Key Date Position: Capital Commitment | JBRSBPK | CURR | 17(2) | WERTV9 | ||||
ABL_A_Z | Maturity of Asset: Interest Rate Commitment | JBRABAZ | CURR | 17(2) | WERTV9 | ||||
ABL_A_K | Maturity of Asset: Capital Commitment | JBRABAK | CURR | 17(2) | WERTV9 | ||||
ABL_P_Z | Maturity of Liability: Interest Rate Commitment | JBRABPZ | CURR | 17(2) | WERTV9 | ||||
ABL_P_K | Maturity of Liability: Capital Commitment | JBRABPK | CURR | 17(2) | WERTV9 | ||||
CFL_A | Asset-Side Cash Flow | JBRCFLA | CURR | 17(2) | WERTV9 | ||||
CFL_P | Liability-Side Cash Flow | JBRCFLP | CURR | 17(2) | WERTV9 | ||||
LIQU_A | Asset-Side Liquidity | JBRLIQUA | CURR | 17(2) | WERTV9 | ||||
LIQU_P | Liability-Side Liquidity | JBRLIQUP | CURR | 17(2) | WERTV9 | ||||
GPZ_DB_A_Z | Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Int Cmmt | JBRPZDBAZ | CURR | 17(2) | WERTV9 | ||||
GPZ_DB_A_K | Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Cap.Cmmt | JBRPZDBAK | CURR | 17(2) | WERTV9 | ||||
GPZ_DB_P_Z | Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Int Cmmt | JBRPZDBPZ | CURR | 17(2) | WERTV9 | ||||
GPZ_DB_P_K | Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Cap.Cmmt | JBRPZDBPK | CURR | 17(2) | WERTV9 | ||||
GPZ_SB_A_Z | Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Int Cmmt | JBRPZSBAZ | CURR | 17(2) | WERTV9 | ||||
GPZ_SB_A_K | Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Cap.Cmmt | JBRPZSBAK | CURR | 17(2) | WERTV9 | ||||
GPZ_SB_P_Z | Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Int Cmmt | JBRPZSBPZ | CURR | 17(2) | WERTV9 | ||||
GPZ_SB_P_K | Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Cap.Cmmt | JBRPZSBPK | CURR | 17(2) | WERTV9 | ||||
GPZ_AB_A_Z | Vol.-Weighted Prod.Int of Asset-Side Maturity: Int Cmmt | JBRPZABAZ | CURR | 17(2) | WERTV9 | ||||
GPZ_AB_A_K | Vol.-Weighted Prod.Int of Asset-Side Maturity: Cap.Cmmt | JBRPZABAK | CURR | 17(2) | WERTV9 | ||||
GPZ_AB_P_Z | Vol.-Weighted Prod.Int of Liab.-Side Maturity: Int Cmmt | JBRPZABPZ | CURR | 17(2) | WERTV9 | ||||
GPZ_AB_P_K | Vol.-Weighted Prod.Int of Liab.-Side Maturity: Cap.Cmmt | JBRPZABPK | CURR | 17(2) | WERTV9 | ||||
DBS_A_Z_AW | Asset-Side Average Position: Interest Rate Commitment in DC | JBRDBAZW | CURR | 17(2) | WERTV9 | ||||
DBS_A_K_AW | Asset-Side Average Position: Capital Commitment in DC | JBRDBAKW | CURR | 17(2) | WERTV9 | ||||
DBS_P_Z_AW | Liability-Side Average Position: Interest Rate Commt in DC | JBRDBPZW | CURR | 17(2) | WERTV9 | ||||
DBS_P_K_AW | Liability-Side Average Position: Capital Commitment in DC | JBRDBPKW | CURR | 17(2) | WERTV9 | ||||
SBS_A_Z_AW | Gap: Asset-Side Key Date Position: Interest Commitment in DC | JBRSBAZW | CURR | 17(2) | WERTV9 | ||||
SBS_A_K_AW | Gap: Asset-Side Key Date Position: Capital Commitment in DC | JBRSBAKW | CURR | 17(2) | WERTV9 | ||||
SBS_P_Z_AW | Gap: Liab.-Side Key Date Position: Interest Commitment in DC | JBRSBPZW | CURR | 17(2) | WERTV9 | ||||
SBS_P_K_AW | Gap: Liab.-Side Key Date Position: Capital Commitment in DC | JBRSBPKW | CURR | 17(2) | WERTV9 | ||||
ABL_A_Z_AW | Maturity of Asset: Interest Rate Commitment in Display Crcy | JBRABAZW | CURR | 17(2) | WERTV9 | ||||
ABL_A_K_AW | Maturity of Asset: Capital Commitment in Display Currency | JBRABAKW | CURR | 17(2) | WERTV9 | ||||
ABL_P_Z_AW | Maturity of Liability: Interest Rate Commt in Display Crcy | JBRABPZW | CURR | 17(2) | WERTV9 | ||||
ABL_P_K_AW | Maturity of Liability: Capital Commitment in Display Crcy | JBRABPKW | CURR | 17(2) | WERTV9 | ||||
CFL_A_AW | Asset-Side Cash Flow in Display Currency | JBRCFLAW | CURR | 17(2) | WERTV9 | ||||
CFL_P_AW | Liability-Side Cash Flow in Display Currency | JBRCFLPW | CURR | 17(2) | WERTV9 | ||||
LIQU_A_AW | Asset-Side Liquidity in Display Currency | JBRLIQUAW | CURR | 17(2) | WERTV9 | ||||
LIQU_P_AW | Liability-Side Liquidity in Display Currency | JBRLIQUPW | CURR | 17(2) | WERTV9 | ||||
GPW_DB_A_Z | Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Int Cmmt DC | JBRPWDBAZ | CURR | 17(2) | WERTV9 | ||||
GPW_DB_A_K | Vol.-Weighted Prod.Int of Asset-Side Avg.Pos.: Cap.Cmmt DC | JBRPWDBAK | CURR | 17(2) | WERTV9 | ||||
GPW_DB_P_Z | Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Int Cmmt DC | JBRPWDBPZ | CURR | 17(2) | WERTV9 | ||||
GPW_DB_P_K | Vol.-Weighted Prod.Int of Liab.-Side Avg.Pos.: Cap.Cmmt DC | JBRPWDBPK | CURR | 17(2) | WERTV9 | ||||
GPW_SB_A_Z | Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Int Cmmt DC | JBRPWSBAZ | CURR | 17(2) | WERTV9 | ||||
GPW_SB_A_K | Vol.-Weighted Prod.Int of Asset-Side KD Pos.: Cap.Cmmt DC | JBRPWSBAK | CURR | 17(2) | WERTV9 | ||||
GPW_SB_P_Z | Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Int Cmmt DC | JBRPWSBPZ | CURR | 17(2) | WERTV9 | ||||
GPW_SB_P_K | Vol.-Weighted Prod.Int of Liab.-Side KD Pos.: Cap.Cmmt DC | JBRPWSBPK | CURR | 17(2) | WERTV9 | ||||
GPW_AB_A_Z | Vol.-Weighted Prod.Int of Asset-Side Maturity: Int Cmmt DC | JBRPWABAZ | CURR | 17(2) | WERTV9 | ||||
GPW_AB_A_K | Vol.-Weighted Prod.Int of Asset-Side Maturity: Cap.Cmmt DC | JBRPWABAK | CURR | 17(2) | WERTV9 | ||||
GPW_AB_P_Z | Vol.-Weighted Prod.Int of Liab.-Side Maturity: Int Cmmt DC | JBRPWABPZ | CURR | 17(2) | WERTV9 | ||||
GPW_AB_P_K | Vol.-Weighted Prod.Int of Liab.-Side Maturity: Cap.Cmmt DC | JBRPWABPK | CURR | 17(2) | WERTV9 | ||||
ANZGW | Display Currency | JBRANZGW | CUKY | 5 | TCURC | WAERS | |||
PKNOTEN | Node in Portfolio Hierarchy | JBRPKNOTEN | NUMC | 6 | Assigned to domain | JBRPHKNID | RMPHNODE | ||
LZB | Maturity Band | JBRLZB_D | CHAR | 4 | JBRLZB | ALPHA | JBRLZB | LZB | S_JBRLZB_LZBID |
NUMBR | Number of translation key in currency translation | CFNUMBR | NUMC | 3 | Assigned to domain | CFNUMBR | NBR |
Key field | Non-key field |
How do I retrieve data from SAP structure JBRRPGAPEX using ABAP code?
As JBRRPGAPEX is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on JBRRPGAPEX as there is no data to select.How to access SAP table JBRRPGAPEX
Within an ECC or HANA version of SAP you can also view further information about JBRRPGAPEX and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects