SAP ABAP Table JBSMDS (SAP Report Data Record (only as structure due to size))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B (Application Component) Bank Components
     ⤷ JBS (Package) Application development IS-B Statutory Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	JBSMDS	Table Relationship Diagram
Short Description	SAP Report Data Record (only as structure due to size)

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	RRECID	☑	JBRRECID	JBRRECID	NUMC	12	0	Record ID for the RR Data Record
3	RALTRECID	☐	JBRARECID	JBRARECID	NUMC	5	0	Additional Record ID for Reporting Dataset
4	.INCLUDE	☐				0	0	Substructure for Technical Information in Report Data Rec.
5	TERFAS	☐	TERFAS	T	TIMS	6	0	Time Reporting Data Record Created
6	DERFAS	☐	DERFAS	DATUM	DATS	8	0	Date Reporting Data Record Created
7	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
8	.INCLUDE	☐				0	0	Substructure for Amount Fields in Report Data Record
9	BABSCH	☐	JBBABSCH	WERTV9	CURR	17	2	Depreciation of Own Holdings
10	BAUSBT	☐	JBBAUSBT	WERTV9	CURR	17	2	Disbursement in Reporting Period
11	BDIFSL	☐	JBBDIFSL	WERTV9	CURR	17	2	Balance Difference for Zero Bonds
12	BEWBRE	☐	JBBEWBRE	WERTV9	CURR	17	2	Individual Value Adjustment Surplus Amount
13	BOFLIM	☐	JBBOFLIM	WERTV9	CURR	17	2	Open Commitments (Principle 1 and BISTA)
14	BSREAL	☐	JBBSREAL	WERTV9	CURR	17	2	Real Estate Loan according to SA1.1 031/QS1.1 031
15	BSPARB	☐	JBBSPARB	WERTV9	CURR	17	2	Balance of Debits in Savings Transactions
16	BSPARG	☐	JBBSPARG	WERTV9	CURR	17	2	Balance of Credits in Savings Transactions
17	BWKTSL	☐	JBBWKTSL	WERTV9	CURR	17	2	Balance in Original Currency
18	BWNOML	☐	JBBWNOML	WERTV9	CURR	17	2	Nominal Value in Currency
19	BWTFSL	☐	JBBWTFSL	WERTV9	CURR	17	2	Special Balance Receivables Due Daily
20	BWTVSL	☐	JBBWTVSL	WERTV9	CURR	17	2	Special Balance Payables Due Daily
21	BZINSL	☐	JBBZINSL	WERTV9	CURR	17	2	Balance Interest Accrued for Zero Bonds
22	BZUSAG	☐	JBBZUSAG	WERTV9	CURR	17	2	Amount Commitments (Commitment Statistics)
23	BGSIKO	☐	JBBGSIKO	WERTV9	CURR	17	2	Correction Value for Principle I Balance
24	BSBE80	☐	JBBSBE80	WERTV9	CURR	17	2	Pledge with 20% Weighting in Principle I
25	BSBEVO	☐	JBBSBEVO	WERTV9	CURR	17	2	Pledge with 0% Weighting in Principle I
26	BSVOLL	☐	JBBSVOLL	WERTV9	CURR	17	2	Guarantees with 0% Weighting in Provision I
27	BSW80K	☐	JBBSW80K	WERTV9	CURR	17	2	Securities Pledge with 20% Weighting in Provision I
28	BSW80N	☐	JBBSW80N	WERTV9	CURR	17	2	Securities Pledge with 20% Weighting in Provision I
29	BSWPVO	☐	JBBSWPVO	WERTV9	CURR	17	2	Securities Pledge with 0% Weighting in Provision I
30	BSZENB	☐	JBBSZENB	WERTV9	CURR	17	2	Guarantees from Central Banks in Zone B
31	BIKI80	☐	JBBIKI80	WERTV9	CURR	17	2	Collat.of CI with 20% Weight.for Simul.Rep.Agreement in Pr.I
32	BIPKIB	☐	JBBIPKIB	WERTV9	CURR	17	2	Guarantee of CI in Zone B with Simul.Rep.Agreement in Pr.I
33	BINB80	☐	JBBINB80	WERTV9	CURR	17	2	Collateral of Non-Bank w.20% Weight.for Simul.Rep.Agreement
34	BIVOLL	☐	JBBIVOLL	WERTV9	CURR	17	2	Collateral for Simul.Rep.Agreement with 0% Weighting in Pr.I
35	BIZENB	☐	JBBIZENB	WERTV9	CURR	17	2	Guarantees from Foreign Central Banks, 0% Weighting
36	BIASL1	☐	JBBIASL1	WERTV9	CURR	17	2	Balance for Principle Ia
37	BIASL2	☐	JBBIASL2	WERTV9	CURR	17	2	Balance 2 for Principle Ia
38	BSF80K	☐	JBBSF80K	WERTV9	CURR	17	2	Collateral for Financial Innov.of CI with 20% Weight.in PrI
39	BSF80N	☐	JBBSF80N	WERTV9	CURR	17	2	Collat. for Financ. Innov. of Non-Banks w.20% Weight.in PrI
40	BSFKIB	☐	JBBSFKIB	WERTV9	CURR	17	2	Collateral for Financ. Innov. of CI w. 20% Weight. in Pr.I
41	BSFVOL	☐	JBBSFVOL	WERTV9	CURR	17	2	Collateral for Fin.Innov.with 0% Weighting in Pr.I
42	BTERMP	☐	JBBTERMP	DEC6_5	DEC	11	5	Forward Price for Option Price Model
43	BSIBT0	☐	JBBSIBT0	WERTV9	CURR	17	2	Secured Amount 0
44	BSIBT1	☐	JBBSIBT1	WERTV9	CURR	17	2	Secured Amount 1
45	BSIBT2	☐	JBBSIBT2	WERTV9	CURR	17	2	Secured Amount 2
46	BSIBT3	☐	JBBSIBT3	WERTV9	CURR	17	2	Secured Amount 3
47	BSIBT4	☐	JBBSIBT4	WERTV9	CURR	17	2	Secured Amount 4
48	BSIBT5	☐	JBBSIBT5	WERTV9	CURR	17	2	Secured Amount 5
49	BSIBT6	☐	JBBSIBT6	WERTV9	CURR	17	2	Secured Amount 6
50	BSIBT7	☐	JBBSIBT7	WERTV9	CURR	17	2	Secured Amount 7
51	BSIBT8	☐	JBBSIBT8	WERTV9	CURR	17	2	Secured Amount 8
52	BSIBT9	☐	JBBSIBT9	WERTV9	CURR	17	2	Secured Amount 9
53	BZUSGA	☐	JBBZUSGA	WERTV9	CURR	17	2	Amount Open Commitment for Foreign Loan Portfolio
54	BZUSGC	☐	JBBZUSGC	WERTV9	CURR	17	2	Amount Open Commitments for COOKE
55	BKRAEQ	☐	JBBKRAEQ	WERTV9	CURR	17	2	Credit Equivalence Amount
56	BNETLZ	☐	JBBNETLZ	WERTV9	CURR	17	2	Amount Used as Calculation Base for Netting
57	BNETMB	☐	JBBNETMB	WERTV9	CURR	17	2	Net Coverage Cost (with Netting)
58	BOFFLS	☐	JBBOFFLS	WERTV9	CURR	17	2	Secondary Balance from Direct Debit Transactions
59	BZAHLB	☐	JBBZAHLB	WERTV9	CURR	17	2	Reporting Amount Payments
60	BSONSA	☐	JBBSONSA	WERTV9	CURR	17	2	Reporting Amount for Other Expenses
61	BSONSE	☐	JBBSONSE	WERTV9	CURR	17	2	Reporting Amount for Other Revenue
62	BZAUFW	☐	JBBZAUFW	WERTV9	CURR	17	2	Reporting Amount Costs Equivalent to Interest
63	BZERTR	☐	JBBZERTR	WERTV9	CURR	17	2	Reporting Amount Interest Equivalent to Income
64	BZAUSB	☐	JBBZAUSB	WERTV9	CURR	17	2	Reporting Amount Interest Costs
65	BZEINB	☐	JBBZEINB	WERTV9	CURR	17	2	Reporting Amount Interest Income
66	BRLZ1J	☐	JBBRLZ1J	WERTV9	CURR	17	2	Loan Parts w.Resid.Term of Upto 1 Year to For.Parties in DM
67	BRLZ2J	☐	JBBRLZ2J	WERTV9	CURR	17	2	Loan Parts w.Resid.Term of 1 Year Plus to For.Parties in DM
68	BAVALD	☐	JBBAVALD	WERTV9	CURR	17	2	Amount of Guarantee
69	BSB1_1	☐	JBBSB1_1	WERTV9	CURR	17	2	Collateral Amount according to §13(1) for Collateral Key 1
70	BSB1_2	☐	JBBSB1_2	WERTV9	CURR	17	2	Collateral Amount according to §13(2) for Collateral Key 1
71	BSB14E	☐	JBBSB14E	WERTV9	CURR	17	2	Collateral Amount acc. §13(4)(Indiv.) for Collateral Key 1
72	BSB14G	☐	JBBSB14G	WERTV9	CURR	17	2	Collateral Amount acc. §13(4)(Overall) for Collateral Key 1
73	BSB2_1	☐	JBBSB2_1	WERTV9	CURR	17	2	Collateral Amount according to §13(1) for Collateral Key 2
74	BSB2_2	☐	JBBSB2_2	WERTV9	CURR	17	2	Collateral Amount according to §13(2) for Collateral Key 2
75	BSB24E	☐	JBBSB24E	WERTV9	CURR	17	2	Collateral Amount acc. §13(4) (Indiv.) for Collateral Key 2
76	BSB24G	☐	JBBSB24G	WERTV9	CURR	17	2	Collateral Amount acc. §13(4) (Overall) for Collateral Key 2
77	BSB3_1	☐	JBBSB3_1	WERTV9	CURR	17	2	Collateral Amount according to §13(1) for Collateral Key 3
78	BSB3_2	☐	JBBSB3_2	WERTV9	CURR	17	2	Collateral Amount according to §13(2) for Collateral Key 3
79	BSB34E	☐	JBBSB34E	WERTV9	CURR	17	2	Collateral Amount acc. §13(4)(Indiv.) for Collateral Key 3
80	BSB34G	☐	JBBSB34G	WERTV9	CURR	17	2	Collateral Amount acc. §13(4)(Overall) for Collateral Key 3
81	BSB4_1	☐	JBBSB4_1	WERTV9	CURR	17	2	Collateral Amount acc. to §13(1) for Collateral Key 4
82	BSB4_2	☐	JBBSB4_2	WERTV9	CURR	17	2	Collateral Amount acc. to §13(2) for Collateral Key 4
83	BSB44E	☐	JBBSB44E	WERTV9	CURR	17	2	Collateral Amount acc. §13(4)(Indiv.) for Collateral Key 4
84	BSB44G	☐	JBBSB44G	WERTV9	CURR	17	2	Collateral Amount acc. §13(4)(Overall) for Collateral Key 4
85	BSB5_1	☐	JBBSB5_1	WERTV9	CURR	17	2	Collateral Amount acc. to §13(1) for Collateral Key 5
86	BSB5_2	☐	JBBSB5_2	WERTV9	CURR	17	2	Collateral Amount acc. to §13(2) for Collateral Key 5
87	BSB54E	☐	JBBSB54E	WERTV9	CURR	17	2	Collateral Amount acc. to §13(4)(single) for Coll.Key 5
88	BSB54G	☐	JBBSB54G	WERTV9	CURR	17	2	Collateral Amount acc.to §13(4)(total) for Collateral Key 5
89	BAKAKN	☐	JBBAKAKN	WERTV9	CURR	17	2	Syndicate Share of the Lender
90	BDMGEG	☐	JBBDMGEG	WERTV9	CURR	17	2	DM Equivalent
91	BEWBER	☐	JBBEWBER	WERTV9	CURR	17	2	Individual Value Adjustments
92	BIANOM	☐	JBBIANOM	WERTV9	CURR	17	2	Nominal Amount Forward/Option Transaction in DM
93	BILIMT	☐	JBBILIMT	WERTV9	CURR	17	2	Internal Credit Limit
94	BINNOM	☐	JBBINNOM	WERTV9	CURR	17	2	Securities in Investment Fund/ GBA Nominal Values
95	BKKOST	☐	JBBKKOST	PRZ33V	DEC	6	3	Credit Costs Effective p.a. (§13 Display)
96	BKLIM2	☐	JBBKLIM2	WERTV9	CURR	17	2	2nd External Credit Commitment
97	BKLIMI	☐	JBBKLIMI	WERTV9	CURR	17	2	Irreducible Credit Limit
98	BKOMPE	☐	JBBKOMPE	WERTV9	CURR	17	2	Netting Amount
99	BMBMTP	☐	JBBMBMTP	WERTV9	CURR	17	2	MVM Amount Valued with Forward Rate
100	BMBMBP	☐	JBBMBMBP	WERTV9	CURR	17	2	MVM Amount Valued with Base Price
101	BMBMSL	☐	JBBMBMSL	WERTV9	CURR	17	2	Amount for Market Valuation Method
102	BMIOS2	☐	JBBMIOS2	WERTV9	CURR	17	2	Second Secured Amount in Millions
103	BMIOSI	☐	JBBMIOSI	WERTV9	CURR	17	2	Secured Amount in Millions
104	BNACHH	☐	JBBNACHH	WERTV9	CURR	17	2	Risk Amount for Underwriting Bank with Pass-Through Security
105	BORGSI	☐	JBBORGSI	WERTV9	CURR	17	2	Secured Staff Loan
106	BRUECK	☐	JBBRUECK	WERTV9	CURR	17	2	Separate Display of Arrears with Display in Millions
107	BSKI80	☐	JBBSKI80	WERTV9	CURR	17	2	Guarantee CI with 20% Weighting in Provision I
108	BSKIZB	☐	JBBSKIZB	WERTV9	CURR	17	2	Guarantee from Credit Institution in Zone B
109	BSNB80	☐	JBBSNB80	WERTV9	CURR	17	2	Guarantees fr.Non-Banks with 20% Weighting in Pr.I
110	BSPBET	☐	JBBSPBET	WERTV9	CURR	17	2	Special Amount for Exempted Partial Balance
111	BSTRIB	☐	JBBSTRIB	WERTV9	CURR	17	2	Exercise Price or Percentage Rate
112	BUNEPG	☐	JBBUNEPG	WERTV9	CURR	17	2	Simulated Repurchase Transaction
113	BUNTER	☐	JBBUNTER	WERTV9	CURR	17	2	Subparticipation
114	BVORHA	☐	JBBVORHA	WERTV9	CURR	17	2	Risk Amount for Suggested CI with Pass-Through Loans
115	BBETRG	☐	JBBKONBE	WERTV9	CURR	17	2	Contract Size of a Security Contract (amount)
116	BSTUCK	☐	JBBSTUCK	ASTUECK	DEC	15	5	Contract Size of a Security Contract (number)
117	BKONAN	☐	JBBKONAN	ASTUECK	DEC	15	5	Contract Size of a Security Contract (number)
118	.INCLUDE	☐				0	0	Substructure for Date Fields in Report Data Record
119	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
120	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
121	DAUSWE	☐	JBDAUSWE	DATUM	DATS	8	0	Date of RR Evaluation
122	DKNTGB	☐	JBDKNTBG	DATUM	DATS	8	0	Start of Contract Period for Financial Innovations
123	DKNTFL	☐	JBDKNTFL	DATUM	DATS	8	0	End of Contract Period for Financial Innovations
124	DUNDLB	☐	JBDUNDLB	DATUM	DATS	8	0	End of Term for Underlier
125	DUNDLV	☐	JBDUNDLV	DATUM	DATS	8	0	Start of Term for Underlier
126	DVALUT	☐	JBDVALUT	DATUM	DATS	8	0	Value Date
127	DZHLTG	☐	JBDZHLTG	DATUM	DATS	8	0	Payment Date
128	DZUSBE	☐	JBDZUSBE	DATUM	DATS	8	0	Start of External Loan Commitment
129	DZUSEN	☐	JBDZUSEN	DATUM	DATS	8	0	Expiry Date of External Loan Commitment
130	.INCLUDE	☐				0	0	Substructure for Interest Rates in Report Data Record
131	IZINSS	☐	JBIZINSS	PRZ23	DEC	5	3	Credit Interest Rate Savings Accounts
132	.INCLUDE	☐				0	0	Substructure for Indicator in Report Data Record
133	JAEQRE	☐	JBJAEQRE	JBJAEQRE	CHAR	1	0	Indicator Showing Who Calculates Loan Equivalence Amount	*
134	JTIEIG	☐	JBJTIEIG	JBJTIEIG	CHAR	1	0	Indicator for 'Own Securities'
135	JUMTSH	☐	JBJUMTSH	JBJUMTSH	CHAR	1	0	Indicator - Exchange Option for Debentures
136	JWOBAU	☐	JBJWOBAU	JBJWOBAU	CHAR	1	0	Indicator - Loans for House-Building	*
137	JZUSTA	☐	JBJZUSTA	JBJZUSTA	CHAR	1	0	Indicator for Commitment Statistics	*
138	.INCLUDE	☐				0	0	Substructure for Rates + Prices in Report Data Structure
139	KKKURS	☐	JBKKKURS	WHRBTRG	CURR	10	2	Spot Price of Securities
140	KKURS1	☐	JBKKURS1	UKURS	DEC	9	5	Current Exchange Rate Account to Translation Currency
141	AFFACT1	☐	JBAFFACT1	DEC9	DEC	9	0	Exchange Ratio of "from" Currency Account/Conversion
142	ATFACT1	☐	JBATFACT1	DEC9	DEC	9	0	Exchange Ratio of "to" Currency Account/Conversion
143	KKURS2	☐	JBKKURS2	UKURS	DEC	9	5	Current Exchange Rate: Account Currency to Book Currency
144	AFFACT2	☐	JBAFFACT2	DEC9	DEC	9	0	Exchange Ratio of "from" Currency Account/Bal.sheet
145	ATFACT2	☐	JBATFACT2	DEC9	DEC	9	0	Exchange Ratio of "to" Currency Account/Balance Sheet Crcy
146	KBUGLD	☐	JBKBUGLD	WHRBTRG	CURR	10	2	Account-Based Moving Average Rate
147	.INCLUDE	☐				0	0	Substructure for Percentage Rates in Report Data Record
148	PEWBPR	☐	JBPEWBPR	DEC3_2	DEC	5	2	Percentage Value Adjustment for Country Risks
149	PGBRQT	☐	JBPGBRQT	PRZ33	DEC	6	3	Private Company Quota in Percentage
150	PPROZE	☐	JBPPROZE	PRZ31	DEC	4	1	Percentage for the Principles
151	PTILGS	☐	JBPTILGS	PRZ33V	DEC	6	3	Repayment Rate According to § 16
152	.INCLUDE	☐				0	0	Substructure for Numbers in Report Data Record
153	OBJNR	☐	JBOBJNR	J_OBJNR	CHAR	22	0	Object number for financial transactions	*
154	RINTNUM	☐	JBRINTNUM	CHAR18	CHAR	18	0	Internal Number of Reporting Object
155	REXTNUM	☐	JBREXTNUM	CHAR18	CHAR	18	0	External Number of Reporting Object
156	RFIKON	☐	JBRFIKON	SAKNR	CHAR	10	0	Account Number of Bank's General Ledger Acount	*
157	RGBRGS	☐	JBRGBRGS	CHAR10	CHAR	10	0	Sort Key - Partner in Private Company
158	RKNSFH	☐	JBRKNSFH	CHAR010	CHAR	10	0	Syndicate Leader
159	RVREGL	☐	JBRVREGL	JBRVREGL	CHAR	4	0	Processing Rule (Regulatory Reporting)
160	RWPKNR	☐	JBRWPKNR	CHAR10	CHAR	10	0	Securities ID Number
161	RZUSNR	☐	JBRZUSNR	CHAR20	CHAR	20	0	Number for the Merging of Accounts
162	RBRSAP	☐	JBRBRSAP	JBRBRSAP	NUMC	6	0	Industry Key in SAP Format	*
163	RREFNR	☐	JBRREFNR	JBSREFNR	CHAR	5	0	Contact Person's Number
164	.INCLUDE	☐				0	0	Substructure for Control Fields in Reporting Data Record
165	SPGRUP	☐	JBSPGRUP	JBSPGRUP	CHAR	2	0	Product Group of Bank Product
166	SSART1	☐	JBSSART1	JBSSART1	CHAR	2	0	Collateral Key 1 for §13 German Banking Act	*
167	SSART2	☐	JBSSART2	JBSSART2	CHAR	2	0	Collateral Key 2 for §13 German Banking Act	*
168	SSART3	☐	JBSSART3	JBSSART3	CHAR	2	0	Collateral Key 3 for §13 German Banking Act	*
169	SSART4	☐	JBSSART4	JBSSART4	CHAR	2	0	Collateral Key 4 for §13 German Banking Act	*
170	SSART5	☐	JBSSART5	JBSSART5	CHAR	2	0	Collateral key 5 for §13 German Banking Act	*
171	SAMRFR	☐	JBSAMRFR	JBSAMRFR	CHAR	1	0	Exemptions According to Minimum Reserve Directive	*
172	SAMRKZ	☐	JBSAMRKZ	JBSAMRKZ	CHAR	1	0	MRD indicator	*
173	SAMRKR	☐	JBSAMRKR	JBSAMRKR	CHAR	3	0	MRD Adjustment Item	*
174	SAMRSN	☐	JBSAMRSN	JBSAMRSN	CHAR	1	0	Other Reserve-Carrying Liabilities	*
175	SBEBGB	☐	JBSBEGBG	JBSBEGBG	CHAR	1	0	Issue of a Bearer Bond Abroad	*
176	SBZLND	☐	JBSBZLND	LAND1	CHAR	3	0	Country Key of Bill of Exchange Drawee	*
177	SGMPAP	☐	JBSGMPAP	JBSGMPAP	CHAR	1	0	Indicator for Differentiation of Money Market Securities	*
178	SHYPKR	☐	JBSHYPKR	JBSHYPKR	CHAR	1	0	Mortgage Loans	*
179	SKNLND	☐	JBSKNLND	JBSKNLND	CHAR	1	0	Country Information for Borrower Statistics	*
180	SKNSKZ	☐	JBSKNSKZ	JBSKNSKZ	CHAR	1	0	Consolidation Indicator	*
181	SSNDLZ	☐	JBSSNDLZ	JBSSNDLZ	CHAR	3	0	Special Terms Key	*
182	SREIHN	☐	JBSREIHN	JBSREIHN	CHAR	1	0	Row Indicator for Treasury Bills and Interest-Free Notes	*
183	SSNDER	☐	JBSSNDER	JBSSNDER	CHAR	3	0	Special Conditions/Adjustments	*
184	SVRARB	☐	JBSVRARB	JBSVRARB	CHAR	2	0	Processing Indicator	*
185	SVRBRT	☐	JBSVRBRT	JBSVRBRT	CHAR	2	0	Subdivision for Various Liabilities-Side Items	*
186	SVRSIC	☐	JBSVRSIC	JBSVRSIC	CHAR	2	0	Payables Against Collateral	*
187	SWPART	☐	JBSWPART	JBSWPART	CHAR	2	0	Security Type for Differentiation in Sec. Account Statistics	*
188	SWPVRZ	☐	JBSWPVRZ	JBSWPVRZ	CHAR	1	0	Return on Securities
189	SFNLFZ	☐	JBSFNLFZ	JBSFNLFZ	CHAR	4	0	Term Calculation with Warranties on Financial Innovations	*
190	SIA1PN	☐	JBSIA1PN	JBSIA1PN	CHAR	1	0	Statistical Repurchase Agreements	*
191	SIA3GE	☐	JBSIA3GE	JBSIA3GE	CHAR	13	0	Number for Calculating the Net Difference Amount
192	SKTKLS	☐	JBSKTKLS	JBSKTKLS	CHAR	3	0	Differentiation of Transactions (Principle 1A)	*
193	SMICRO	☐	JBSMICRO	JBSMICRO	CHAR	1	0	Indicator for Micro Hedge	*
194	SWPVAL	☐	JBSWPVAL	JBSWPVAL	CHAR	1	0	Indicator for Forward Securities Transactions	*
195	SMRGIN	☐	JBSMRGIN	JBSMRGIN	CHAR	1	0	Indicator for Margin System	*
196	SRSAKT	☐	JBSRSAKT	JBSRSAKT	CHAR	3	0	Transaction Differentiation for COOKE or GAB
197	SZUSKC	☐	JBSZUSKC	JBSZUSKC	CHAR	1	0	Indicator - Irrevocable Loan Commitment
198	SUEBKZ	☐	JBSUEBKZ	JBSUEBKZ	CHAR	2	0	Indicator for Supervisory Case acc. to § 13, 14, 16 GAB
199	SABTRT	☐	JBSABTRT	JBSABTRT	CHAR	1	0	Indicator - Assignment of Loan Receivables for Collateral	*
200	SEMITL	☐	JBSEMITL	LAND1	CHAR	3	0	Country of Issuer	*
201	SGESAR	☐	JBSGESAR	JBSGESAR	CHAR	4	0	Transaction Type of Account from RR Perspective
202	SKNZHL	☐	JBSKNZHL	JBSKNZHL	CHAR	3	0	Key Figure According to Service List
203	SKZMEL	☐	JBSKZMEL	JBSKZMEL	CHAR	1	0	Status Indicator German Foreign Trade Regulations Data
204	SLAUFG	☐	JBSLAUFG	JBSLAUFG	CHAR	2	0	Term Group of Account
205	SWPBRN	☐	JBSWPBRN	JBSWPBRN	CHAR	5	0	Sector of Security
206	SWPEIN	☐	JBSWPEIN	JBSWPEIN	CHAR	1	0	Unit of Security Quotation
207	SZABER	☐	JBSZABER	JBSZABER	CHAR	3	0	Indicator - Payment Area acc.to German Foreign Trade Reg.
208	SSIART	☐	JBSSIART	JBSSIART	CHAR	1	0	Collateral Type
209	SPFAND	☐	JBSPFAND	JBSPFAND	CHAR	1	0	Seizability of a Security
210	SBONKD	☐	JBSBONKD	JBSBONKD	CHAR	1	0	Indicator - Debtor's Credit Standing
211	SKUEFR	☐	JBSKUEFR	JBSKUEFR	CHAR	1	0	Indicator - Period of Notice
212	SKUEND	☐	JBSKUEND	JBSKUEND	CHAR	1	0	Indicator - Withdrawal Restriction
213	SMUTLD	☐	JBSMUTLD	JBSMUTLD	CHAR	2	0	Country of Parent Bank's Headquarters
214	S13AWV	☐	JBS13AWV	JBS13AWV	CHAR	1	0	Indicator for Further Processing with § 13 a	*
215	SABZUG	☐	JBSABZUG	JBSABZUG	CHAR	1	0	Deduction of Liable Equity Capital	*
216	SANART	☐	JBSANART	JBSANART	CHAR	2	0	Display Type	*
217	SANWKA	☐	JBSANWKA	CHAR15	CHAR	15	0	User-Specific Credit Type Text
218	SANWZ1	☐	JBSANWZ1	CHAR20	CHAR	20	0	User-Specific Supplementary Text
219	SANWZ2	☐	JBSANWZ2	CHAR60	CHAR	60	0	User-Specific Additional Details for Large Exposures etc.
220	SAUFRE	☐	JBSAUFRE	JBSAUFRE	CHAR	2	0	Indicator - Account Netting Type	*
221	SBERBN	☐	JBSBERBN	JBSBERBN	CHAR	2	0	Reporting Country Banks	*
222	SBNKVR	☐	JBSBNKVR	JBSBNKVR	CHAR	1	0	Settlement of Day-to-Day Bank Accounts	*
223	SBOEKZ	☐	JBSBOEKZ	JBSBORKZ	CHAR	1	0	Stock Market Indicator	*
224	SBOERS	☐	JBSBOERS	JBSBOERS	CHAR	1	0	Eligibility for Stock Market Listing/Marketabilty	*
225	SBUEKZ	☐	JBSBUEKZ	JBSBUEKZ	CHAR	1	0	Indicator - Guarantee / $ 14 GAB Double Display	*
226	SKDREF	☐	JBSKDREF	JBSKDREF	CHAR	2	0	Indicator for Legal Form of Customer
227	SDUPLK	☐	JBSDUPLK	JBSDUPLK	CHAR	2	0	Duplikats-Kennzeichen
228	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
229	SEBENI	☐	JBSEBENI	JBSEBENI	NUMC	8	0	Internal Hierarchy Level	*
230	SFOART	☐	JBSFOART	JBSFOART	CHAR	2	0	Subdivision for Various Asset-Side Items	*
231	SGEART	☐	JBSGEART	JBSGEART	CHAR	3	0	Transaction Type for Financial Innovations	*
232	SGEMKR	☐	JBSGEMKR	JBSGEMKR	CHAR	2	0	Indicator - Joint Loan	*
233	SGEWKZ	☐	JBSGEWKZ	JBSGEWKZ	CHAR	1	0	Indicator for Warranties Assumed
234	SKNEIN	☐	JBSKNEIN	BU_PARTNER	CHAR	10	0	Number for Borrower Entity	*
235	SKNSVR	☐	JBSKNSVR	JBSKNSVR	CHAR	1	0	Consolidation Settlement	*
236	SKNZKD	☐	JBSKNZKD	JBSKNZKD	CHAR	1	0	Group/Non-Group Customer	*
237	SKREDT	☐	JBSKREDT	JBSKREDT	CHAR	2	0	Credit Type for German Banking Act	*
238	SKTART	☐	JBSKTART	JBSKTART	CHAR	3	0	Regulatory Reporting - Account Type	*
239	SKTAUS	☐	JBSKTAUS	JBSKTAUS	CHAR	2	0	Account Print-Out	*
240	SKVKKZ	☐	JBSKVKKZ	SBEWZITI	CHAR	4	0	Indicator - Purchase/Sale of Forward and Spot Transactions	*
241	SLKFIN	☐	JBSLKFIN	JBSLKFIN	CHAR	1	0	Locally-Funded Transactions	*
242	SLNZON	☐	JBSLNZON	JBSLNZON	CHAR	1	0	Indicator - Zone Allocation of Countries	*
243	SNDLLD	☐	JBSNDLLD	JBSNDLLD	CHAR	1	0	Indicator - Business Activity in Country	*
244	SNERWR	☐	JBSNERWR	JBSNERWR	CHAR	1	0	Domestic State Adminisitration not Pursuing Business Goal	*
245	SNETAR	☐	JBSNETAR	JBSNETAR	CHAR	2	0	Type of Contractual Netting	*
246	SNRANG	☐	JBSNRANG	JBSNRANG	CHAR	1	0	Indicator for Subordinated Receivables/Payables	*
247	SRDISK	☐	JBSRDISK	JBSRDISK	CHAR	2	0	Bill Rediscount Point	*
248	SREFIN	☐	JBSREFIN	JBSREFIN	CHAR	1	0	Indicator for Refinanceability	*
249	SRLAND	☐	JBSRLAND	LAND1	CHAR	3	0	Country Key for Rediscount Point	*
250	SSICHA	☐	JBSSICHA	JBSSICHA	CHAR	2	0	Type of Loan Collateral - § 14 /16	*
251	SSWPFZ	☐	JBSSWPFZ	JBSSWPFZ	CHAR	1	0	Indicator - Fixed Rate for Swap	*
252	STRHND	☐	JBSTRHND	JBSTRHND	CHAR	1	0	Indicator for Trust Assets	*
253	SUTRAG	☐	JBSUTRAG	JBSUTRAG	CHAR	2	0	Indicator for Transmission Type	*
254	SVERWZ	☐	JBSVERWZ	JBSVERWZ	CHAR	3	0	Intended Use of Loan
255	SWPDIF	☐	JBSWPDIF	JBSWPDIF	CHAR	1	0	Security Differentiation Bista and Principle I	*
256	SWPDOP	☐	JBSWPDOP	JBSWPDOP	CHAR	10	0	Double Notification for Securities Lending Transactions
257	SZNSAN	☐	JBSZNSAN	JBSZNSAN	CHAR	2	0	Indicator for Interest Adjustment Mode	*
258	SZUSKZ	☐	JBSZUSKZ	JBSZUSKZ	CHAR	2	0	External Loan Commitment	*
259	SGOLDD	☐	JBSGOLDD	JBSGOLDD	CHAR	1	0	Gold Holdings Covered by Gold Payables	*
260	SHANDW	☐	JBSHANDW	JBSHANDW	CHAR	1	0	Indicator - Craftsperson (Borrower Statistics)	*
261	SOPTMO	☐	JBSOPTMO	JBSOPTMO	CHAR	1	0	Indicator for Option Price Model Calculation
262	SKRART	☐	JBSKRART	JBSKRART	CHAR	2	0	Credit Type Text	*
263	SWEART	☐	JBSWEART	JBSWEART	CHAR	2	0	Bill of Exchange Type	*
264	SDUPPF	☐	JBSDUPPF	JBSDUPPF	CHAR	8	0	Kennzeichen Duplikats-Pflicht
265	.INCLUDE	☐				0	0	Substructure for Currencies in Report Data Record
266	WBUCHW	☐	JBWBUCHW	WAERS	CUKY	5	0	Book Currency of Bank	TCURC
267	WGWAER	☐	JBWGWAER	WAERS	CUKY	5	0	Currency of transaction	TCURC
268	WUMREW	☐	JBWUMREW	WAERS	CUKY	5	0	Reporting Currency (Currency Translated Into)	TCURC
269	WWAEH2	☐	JBWWAEH2	WAERS	CUKY	5	0	SCB Currency Key 2 (for Payment Amount)	TCURC
270	WWPWAE	☐	JBWWPWAE	WAERS	CUKY	5	0	Security Currency	*
271	WWAEH3	☐	JBWWAEH3	WAERS	CUKY	5	0	SCB Currency Key 3 (for Premium Balance)	TCURC
272	.INCLUDE	☐				0	0	Substructure for Texts in Report Data Record
273	XKNNAM	☐	JBXKNNAM	JBXKNNAM	CHAR	40	0	Description of Borrower Entity
274	XSITKU	☐	JBXSITKU	JBXSITKU	CHAR	40	0	Customer's Place of Residence
275	XSITZK	☐	JBXSITZK	JBXSITZK	CHAR	40	0	Seat of Borrower Entity
276	.INCLUDE	☐				0	0	Substructure for Treasury Fields in Report Data Record
277	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
278	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
279	RBPROD	☐	RBPROD	RBPROD	NUMC	4	0	Product Number
280	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
281	SETTLFL	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
282	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
283	BZBETR	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
284	OSSIGN	☐	TB_OSSIGN	T_SSIGN	CHAR	1	0	Direction of strike amount (Put/Call)
285	RANLW	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
286	.INCLUDE	☐				0	0	Substructure for Business Partner Fields
287	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
288	KWG_ORG	☐	BP_KWG_ORG	BP_KWG_ORG	NUMC	2	0	Loan to Manager According to Paragraph 15 German Banking Act	*
289	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	*
290	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
291	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
292	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
293	KWG_NR	☐	BP_KWG_NR	CHAR8	CHAR	8	0	Borrower Number for Reporting a Loan According to GBA
294	KWG_ENR	☐	BP_KWG_ENR	CHAR8	CHAR	8	0	Borrower Entity Number Used to Report Loan acc. to GBA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBSMDS	MANDT	T000	MANDT	KEY	1	CN
2	JBSMDS	WBUCHW	TCURC	WAERS	KEY	1	CN
3	JBSMDS	WGWAER	TCURC	WAERS	KEY	1	CN
4	JBSMDS	WUMREW	TCURC	WAERS	KEY	1	CN
5	JBSMDS	WWAEH2	TCURC	WAERS	KEY	1	CN
6	JBSMDS	WWAEH3	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in