SAP ABAP Table JBSSAMBA (Structure of Reporting Data Record Extended for SAMBA)

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	JBSSAMBA	Table Relationship Diagram
Short Description	Structure of Reporting Data Record Extended for SAMBA

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in