SAP table JBSSICH (Regulatory Reporting - Collateral)

SAP table JBSSICH has 3 primary key fields being MANDT,RKEYS,RSICHER.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RKEYS Internally Assigned Key in Collateral Table CHAR 15 0 JBRKEYS
RSICHER Collateral reference number NUMC 8 0 RSICHER
JLOESCH Deletion Indicator CHAR 1 0 JBJLOESCH
Active
X Deleted
SPROD Indicator for Product in Collateral Management CHAR 2 0 JBSPROD
DA Loan
KK Current account
BUKRS Company Code CHAR 4 0 T001 BUKRS
SARCHIV Archiving Category Indicator CHAR 1 0 SARCHIV
RANL Contract Number CHAR 13 0 RANL
RBKONT Account Number CHAR 16 0 JBDKKON JBRBKONT
UPUSERS Last Changed By CHAR 12 0 TB_UPUSER
DUPDATS Changed On DATS 8 0 TB_DUPDAT
TUPTIMS Time Changed TIMS 6 0 TB_TUPTIM
WSICHW Currency of Collateral CUKY 5 0 * JBWSICHW
XC40 Text Field for User-Specific Identification CHAR 40 0 JBXC40
RPRTX External Business Partner Number, RR CHAR 15 0 JBRPRTX
BSIC1 RR Amount of Collateral no.1 CURR 17 2 JBBSICH1
BSIC2 RR Amount of Collateral no.2 CURR 17 2 JBBSICH2
BSIC3 RR Amount of Collateral no.3 CURR 17 2 JBBSICH3
BSIC4 RR Amount of Collateral no.4 CURR 17 2 JBBSICH4
BSIC5 RR Amount of Collateral no.5 CURR 17 2 JBBSICH5
BSIC6 RR Amount of Collateral no.6 CURR 17 2 JBBSICH6
SSIC1 RR Collateral Type No. 1 CHAR 3 0 JBSSTSIC JBSSICH1
SSIC2 RR Collateral Type No. 2 CHAR 3 0 JBSSTSIC JBSSICH2
SSIC3 RR Collateral Type No. 3 CHAR 3 0 JBSSTSIC JBSSICH3
SSIC4 RR Collateral Type No. 4 CHAR 3 0 JBSSTSIC JBSSICH4
SSIC5 RR Collateral Type No. 5 CHAR 3 0 JBSSTSIC JBSSICH5
SSIC6 RR Collateral Type No. 6 CHAR 3 0 JBSSTSIC JBSSICH6

JBSSICH foreign key relationships

Table Field Check Table Check Field
0 JBSSICH BUKRS T001 Company Codes BUKRS
1 JBSSICH MANDT T000 Clients MANDT
0 JBSSICH RBKONT JBDKKON SAP Banking: Business Partner Account BUKRS
1 JBSSICH SSIC1 JBSSTSIC Control Table for Formatting Collateral SSICH
0 JBSSICH SSIC2 JBSSTSIC Control Table for Formatting Collateral SSICH
1 JBSSICH SSIC3 JBSSTSIC Control Table for Formatting Collateral SSICH
0 JBSSICH SSIC4 JBSSTSIC Control Table for Formatting Collateral SSICH
1 JBSSICH SSIC5 JBSSTSIC Control Table for Formatting Collateral SSICH
0 JBSSICH SSIC6 JBSSTSIC Control Table for Formatting Collateral SSICH