SAP Table JBSSICH
Regulatory Reporting - Collateral
JBSSICH (Regulatory Reporting - Collateral) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JBSSICH to other SAP tables.
JBSSICH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| RKEYS | Internally Assigned Key in Collateral Table | JBRKEYS | CHAR | 15 | 0 | |||||||
| RSICHER | Collateral reference number | RSICHER | NUMC | 8 | 0 | |||||||
| JLOESCH | Deletion Indicator | JBJLOESCH | CHAR | 1 | 0 |
Possible values
|
||||||
| SPROD | Indicator for Product in Collateral Management | JBSPROD | CHAR | 2 | 0 |
Possible values
|
||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||
| SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | 0 | |||||||
| RANL | Contract Number | RANL | CHAR | 13 | 0 | |||||||
| RBKONT | Account Number | JBRBKONT | JBDKKON | CHAR | 16 | 0 | ||||||
| UPUSERS | Last Changed by | TB_UPUSER | CHAR | 12 | 0 | |||||||
| DUPDATS | Changed on | TB_DUPDAT | DATS | 8 | 0 | |||||||
| TUPTIMS | Time changed | TB_TUPTIM | TIMS | 6 | 0 | |||||||
| WSICHW | Currency of Collateral | JBWSICHW | CUKY | 5 | 0 | |||||||
| XC40 | Text Field for User-Specific Identification | JBXC40 | CHAR | 40 | 0 | |||||||
| RPRTX | External Business Partner Number, RR | JBRPRTX | CHAR | 15 | 0 | |||||||
| BSIC1 | RR Amount of Collateral no.1 | JBBSICH1 | CURR | 17 | 2 | |||||||
| BSIC2 | RR Amount of Collateral no.2 | JBBSICH2 | CURR | 17 | 2 | |||||||
| BSIC3 | RR Amount of Collateral no.3 | JBBSICH3 | CURR | 17 | 2 | |||||||
| BSIC4 | RR Amount of Collateral no.4 | JBBSICH4 | CURR | 17 | 2 | |||||||
| BSIC5 | RR Amount of Collateral no.5 | JBBSICH5 | CURR | 17 | 2 | |||||||
| BSIC6 | RR Amount of Collateral no.6 | JBBSICH6 | CURR | 17 | 2 | |||||||
| SSIC1 | RR Collateral Type No. 1 | JBSSICH1 | JBSSTSIC | CHAR | 3 | 0 | ||||||
| SSIC2 | RR Collateral Type No. 2 | JBSSICH2 | JBSSTSIC | CHAR | 3 | 0 | ||||||
| SSIC3 | RR Collateral Type No. 3 | JBSSICH3 | JBSSTSIC | CHAR | 3 | 0 | ||||||
| SSIC4 | RR Collateral Type No. 4 | JBSSICH4 | JBSSTSIC | CHAR | 3 | 0 | ||||||
| SSIC5 | RR Collateral Type No. 5 | JBSSICH5 | JBSSTSIC | CHAR | 3 | 0 | ||||||
| SSIC6 | RR Collateral Type No. 6 | JBSSICH6 | JBSSTSIC | CHAR | 3 | 0 | ||||||
JBSSICH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JBSSICH | BUKRS | JBSSICH | MANDT | T001 | Company Codes | MANDT |
| JBSSICH | BUKRS | JBSSICH | BUKRS | T001 | Company Codes | BUKRS |
| JBSSICH | MANDT | JBSSICH | MANDT | T000 | Clients | MANDT |
| JBSSICH | RBKONT | JBSSICH | MANDT | JBDKKON | SAP Banking: Business Partner Account | MANDT |
| JBSSICH | RBKONT | JBSSICH | RBKONT | JBDKKON | SAP Banking: Business Partner Account | RBKONT |
| JBSSICH | RBKONT | JBSSICH | BUKRS | JBDKKON | SAP Banking: Business Partner Account | BUKRS |
| JBSSICH | SSIC1 | JBSSICH | SSIC1 | JBSSTSIC | Control Table for Formatting Collateral | SSICH |
| JBSSICH | SSIC2 | JBSSICH | SSIC2 | JBSSTSIC | Control Table for Formatting Collateral | SSICH |
| JBSSICH | SSIC3 | JBSSICH | SSIC3 | JBSSTSIC | Control Table for Formatting Collateral | SSICH |
| JBSSICH | SSIC4 | JBSSICH | SSIC4 | JBSSTSIC | Control Table for Formatting Collateral | SSICH |
| JBSSICH | SSIC5 | JBSSICH | SSIC5 | JBSSTSIC | Control Table for Formatting Collateral | SSICH |
| JBSSICH | SSIC6 | JBSSICH | SSIC6 | JBSSTSIC | Control Table for Formatting Collateral | SSICH |
