SAP ABAP Table IJBA_US_ALM_REP_UNIFIED (ALM Unified Structure For BW Extraction)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-SA-ALM (Application Component) Asset/Liability Management
     ⤷ JBA_US (Package) Analytical Banking US

Basic Data

Table Category	INTTAB	Structure
Structure	IJBA_US_ALM_REP_UNIFIED	Table Relationship Diagram
Short Description	ALM Unified Structure For BW Extraction

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	SAVE_ID	☐	JBRSAVEID	JBRSAVEID	NUMC	12	0	ID of a Saved Gap Analysis Result	*
2	PKNOTEN	☐	JBRPKNOTEN	JBRPHKNID	NUMC	6	0	Node in Portfolio Hierarchy	*
3	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
4	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
5	AUSW	☐	JBRGAPAUSW	JBRGAPAUSW	NUMC	2	0	Gap Evaluation (Position, Outflow, CF, Liquidity)
6	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
8	ZINSKAPB	☐	JBRZKB	JBRZKB	CHAR	1	0	Indicator for Interest or Capital Commitment
9	ABSCHR	☐	JBRABSCHRBETR	WERTV9	CURR	17	2	RM: ALM Write-Down Amount
10	AKT_GAP	☐	JBRGAPAKT	WERTV9	CURR	17	2	Asset Surplus
11	AKT_OZ	☐	JBRPALMAKTOZ	JBRPALM	DEC	7	3	Asset-Side Opportunity Interest Rate in Percentage
12	AKT_VOL	☐	JBRGAPVOLAKT	WERTV9	CURR	17	2	Asset-Side Volume
13	AKT_ZINS	☐	JBRPALMAKT	JBRPALM	DEC	7	3	Asset-Side Interest Rate
14	AUFWAND	☐	JBRALMZSAUFWAND	WERTV9	CURR	17	2	Interest Expense (Product Interest)
15	AUFWAND_OZ	☐	JBRALMZSAUFW_OZ	WERTV9	CURR	17	2	Interest Expense (Opportunity Interest)
16	AUSZAHLUNG	☐	JBRALMCASHVOLPAS	WERTV9	CURR	17	2	Disbursement Amount (Cash Flow Evaluation)
17	BUCHWERT	☐	JBRBUCHWERT	WERTV9	CURR	17	2	RM: ALM Book Value
18	EINZAHLUNG	☐	JBRALMCASHVOLAKT	WERTV9	CURR	17	2	Inpayment Amount (Cash Flow Evaluation)
19	ERTRAG	☐	JBRALMZSERTRAG	WERTV9	CURR	17	2	Interest Revenue (Product Interest)
20	ERTRAG_OZ	☐	JBRALMZSERTRAGOZ	WERTV9	CURR	17	2	Interest Revenue (Opportunity Interest)
21	GAP	☐	JBRALMLQ	WERTV9	CURR	17	2	Payment Gap in Liquidity Evaluation (ALM)
22	GAP_SUM	☐	JBRALMLQKUM	WERTV9	CURR	17	2	Cumulated Payment Gap in Liquidity Evaluation (ALM)
23	KOND_AKT	☐	JBRALMKONDAKT	JBRPALM	DEC	7	3	ALM Asset-Side Net Interest Margin
24	KOND_BTR	☐	JBRALMKONDBTR	JBRPALM	DEC	7	3	ALM Net Interest Margin
25	KOND_PASS	☐	JBRALMKONDPASS	JBRPALM	DEC	7	3	ALM Liability-Side Net Interest Margin
26	PASS_GAP	☐	JBRGAPPAS	WERTV9	CURR	17	2	Liability Surplus
27	PASS_OZ	☐	JBRPALMPASSOZ	JBRPALM	DEC	7	3	Liability-Side Opportunity Interest Rate in Percentage
28	PASS_VOL	☐	JBRGAPVOLPAS	WERTV9	CURR	17	2	Liability-Side Volume
29	PASS_ZINS	☐	JBRPALMPASS	JBRPALM	DEC	7	3	Liability-Side Interest Rate
30	PROFIT_ABS	☐	JBRPROFITABS	WERTV9	CURR	17	2	Interest Result (Absolute)
31	PROFIT_REL	☐	JBRPROFITREL	JBRPALM	DEC	7	3	Interest Result (Relative)
32	REALIZED	☐	JBRREALBETR	WERTV9	CURR	17	2	RM: ALM Realized Profit/Loss Amount
33	RESERVE	☐	JBRRESBETR	WERTV9	CURR	17	2	RM: ALM Amount of Hidden Reserve
34	RUECKST	☐	JBRRUECKSTBETR	WERTV9	CURR	17	2	RM: ALM Provision Amount
35	S_ABSCHR	☐	JBRABSCHRBETR_S	WERTV9	CURR	17	2	ALM: Simulated Write-Down Amount
36	S_AKT_GAP	☐	JBRGAPAKT_S	WERTV9	CURR	17	2	Asset Gap After Simulation (Actual+Simulated)
37	S_AKT_OZ	☐	JBRPALMAKTOZ_S	JBRPALM	DEC	7	3	Asset-Side Opportunity Interest in Percent After Simulation
38	S_AKT_VOL	☐	JBRGAPVOLAKT_S	WERTV9	CURR	17	2	Asset-Side Volume After Simulation
39	S_AKT_ZINS	☐	JBRPALMAKT_S	JBRPALM	DEC	7	3	Asset-Side Interest Rate After Simulation
40	S_AUFWAND	☐	JBRALMZSAUFWAND_S	WERTV9	CURR	17	2	Interest Expense (Product Interest) Act.+Sim. (ALM)
41	S_AUFWAND_OZ	☐	JBRALMZSAUFW_OZ_S	WERTV9	CURR	17	2	Interest Expense (Opportunity Interest) Act.+Sim. (ALM)
42	S_BUCHWERT	☐	JBRBUCHWERT_S	WERTV9	CURR	17	2	ALM: Simulated Book Value
43	S_ERTRAG	☐	JBRALMZSERTRAG_S	WERTV9	CURR	17	2	Interest Revenue (Product Interest) Act.+Sim. (ALM)
44	S_ERTRAG_OZ	☐	JBRALMZSERTRAGOZ_S	WERTV9	CURR	17	2	Interest Revenue (Opportunity Interest) Act.+Sim. (ALM)
45	S_GAP	☐	JBRALMLQ_S	WERTV9	CURR	17	2	Payment Gap Act.+Sim. in Liquidity Evaluation (ALM)
46	S_INPUT	☐	JBRALMCASHVOLAKT_S	WERTV9	CURR	17	2	Incoming Payment Amount Actual + Sim. (Cash Flow Evaluation)
47	S_KOND_AKT	☐	JBRALMKONDAKT_S	JBRPALM	DEC	7	3	Asset-Side Net Interest Margin Actual+Simulated (ALM)
48	S_KOND_BTR	☐	JBRALMKONDBTR_S	JBRPALM	DEC	7	3	Net Interest Margin, Actual+Simulated (ALM)
49	S_KOND_PASS	☐	JBRALMKONDPASS_S	JBRPALM	DEC	7	3	Liab.-Side Net Interest Margin Actual+Simulated (ALM)
50	S_OUTPUT	☐	JBRALMCASHVOLPAS_S	WERTV9	CURR	17	2	Outgoing Payment Amount Actual + Sim. (Cash Flow Evaluation)
51	S_PAS_GAP	☐	JBRGAPPAS_S	WERTV9	CURR	17	2	Liability Gap After Simulation
52	S_PAS_VOL	☐	JBRGAPVOLPAS_S	WERTV9	CURR	17	2	Liability-Side Volume After Simulation
53	S_PAS_ZINS	☐	JBRPALMPASS_S	JBRPALM	DEC	7	3	Liability-Side Interest Rate After Simulation
54	S_PASS_OZ	☐	JBRPALMPASSOZ_S	JBRPALM	DEC	7	3	Liability-Side Opportunity Interest in Percent After Sim.
55	S_PROFIT_ABS	☐	JBRPROFITABS_S	WERTV9	CURR	17	2	Interest Result (Absolute) Act.+Sim. (ALM)
56	S_PROFIT_REL	☐	JBRPROFITREL_S	JBRPALM	DEC	7	3	Interest Result (Relative) Act.+Sim. (ALM)
57	S_REALIZED	☐	JBRREALBETR_S	WERTV9	CURR	17	2	ALM: Simulated Realized Profit/Loss
58	S_RESERVE	☐	JBRRESBETR_S	WERTV9	CURR	17	2	ALM: Simulated Hidden Reserves
59	S_RUECKST	☐	JBRRUECKSTBETR_S	WERTV9	CURR	17	2	ALM: Simulated Provisions
60	S_STRUK_BTR	☐	JBRALMSTRUKBTR_S	JBRPALM	DEC	7	3	Profit/Loss from Mismatch Spread Actual + Simulated (ALM)
61	S_GAP_SUM	☐	JBRALMCASHGAP_S	WERTV9	CURR	17	2	Cash Flow Gap Act.+Sim. (ALM Cash Flow Evaluation)
62	S_ZUSCHR	☐	JBRZUSCHRBETR_S	WERTV9	CURR	17	2	ALM: Simulated Write-Up Amount
63	STRUK_BTR	☐	JBRALMSTRUKBTR	JBRPALM	DEC	7	3	ALM Profit or Loss from Mismatch Spread
64	ZUSCHR	☐	JBRZUSCHRBETR	WERTV9	CURR	17	2	RM: ALM Amount of Write-Up

History

Last changed by/on	SAP	20040819
SAP Release Created in	200