The FBICRC003T table in SAP ERP or S/4HANA stores ICRC: Open Items Customers/Vendors: Totals data. There are total 38 fields in FBICRC003T table. The ICRC: Open Items Customers/Vendors: Totals table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FBICRC003T table. It is in Cross-System Intercompany Reconciliation (FB_ICRC) ABAP package and is part of the Financial Accounting (FI) module.
SAP FBICRC003T Table Fields
Following is the list of fields that are available in SAP FBICRC003T table. The primary key fields of the table are RCLNT (Client), RLDNR (Ledger), RRCTY (Record Type), RVERS (Version), RYEAR (Fiscal Year), ROBJNR (Object number for objects (account assignment elements)), COBJNR (Object number for transaction attributes), SOBJNR (Object number for partner objects (accnt assignmnt elements)), RTCUR (Currency Key), DRCRK (Debit/Credit Indicator), RPMAX (Period).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RRCTY | Record Type | RRCTY | CHAR (1) | |
| RVERS | Version | RVERS | T894 | CHAR (3) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| ROBJNR | Object number for objects (account assignment elements) | GOBJNR_R | CHAR (18) | |
| COBJNR | Object number for transaction attributes | GOBJNR_C | CHAR (18) | |
| SOBJNR | Object number for partner objects (accnt assignmnt elements) | GOBJNR_S | CHAR (18) | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| DRCRK | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| RPMAX | Period | RPMAX | NUMC (3) | |
| RCOMP | Company | RCOMP_D | T880 | CHAR (6) |
| SEQNR | Segment number within a cycle | SQNR | NUMC (4) | |
| ROBUKRS | Original company code | OBUKR | T001 | CHAR (4) |
| RCUST | Customer Number | KUNNR | CHAR (10) | |
| RVEND | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| RASSC | Company ID of Trading Partner | RASSC | CHAR (6) | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR (10) |
| RTYPE | Record Type | FB_ICRC_RTYPE | CHAR (1) | |
| TSLVT | Balance carried forward in transaction currency | TSLVT9 | CURR (23) | |
| TSL01 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL02 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL03 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL04 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL05 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL06 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL07 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL08 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL09 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL10 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL11 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL12 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL13 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL14 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL15 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| TSL16 | Total of transactions of the period in transaction currency | TSLXX9 | CURR (23) | |
| CSPRED | Distribution key for currency amounts | CSPRED | T821S | CHAR (4) |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) |
