COFIP SAP (Single plan items for reconciliation ledger) Table details
Dictionary Type: Table
Description: Single plan items for reconciliation ledger
Description: Single plan items for reconciliation ledger
Table field list including key, data, relationships and ABAP select examples
COFIP is a standard SAP Table which is used to store Single plan items for reconciliation ledger data and is available within R/3 SAP systems depending on the version and release level.
The COFIP table consists of various fields, each holding specific information or linking keys about Single plan items for reconciliation ledger data available in SAP. These include GL_SIRID (Record number of the line item record), RLDNR (Ledger), RRCTY (Record Type), RVERS (Version).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP COFIP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
RCLNT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
GL_SIRID | Record number of the line item record | GU_RECID | CHAR | 18 | OBJNR | OBN | |||
RLDNR | Ledger | RLDNR | CHAR | 2 | T881 | ALPHA | RLDNR | GLN | H_T881 |
RRCTY | Record Type | RRCTY | CHAR | 1 | RRCTY | ||||
RVERS | Version | VERSN | CHAR | 3 | TKA09 | ALPHA | COVERSI | KVS | |
RYEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
RTCUR | Currency Key for Amounts in Controlling Area Currency | RACUR | CUKY | 5 | TCURC | WAERS | FWS | ||
RUNIT | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
DRCRK | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
RPMAX | Period | RPMAX | NUMC | 3 | RPMAX | ||||
DOCCT | Document Type | DOCCT | CHAR | 1 | DOCCT | GCT | |||
DOCNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
DOCLN | Document line | DOCLN | CHAR | 3 | DOCLN | ||||
RBUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RACCT | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
RHRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | TKKH1 | HRKFT | |||
ROBART | Reconciliation ledger object type (technical) | COFI_OB_CV | CHAR | 2 | OBART | J_OBART_LD | |||
RSCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
RBUSA | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
RFAREA | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
RFUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
RGRANT_NBR | Receiver Grant | GM_GRANT_RECEIVER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
RLOGSYS | Logical system of object | LOGSYSO | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
SBUKRS | Company code of partner | PBUKRS | CHAR | 4 | T001 | BUKRS | BUK | ||
SACCT | Cost element of partner | PKSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
SHRKFT | Origin of partner (subdivision of cost element) | PHRKFT | CHAR | 4 | TKKH1 | HRKFT | |||
SOBART | Partner object type (for reconciliation ledger) | COFI_PO_CV | CHAR | 2 | OBART | J_OBART_LD | |||
SSCOPE | Partner object class | PSCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | |||
SBUSA | Trading partner's business area | PARGB | CHAR | 4 | TGSB | GSBER | GSB | ||
SFAREA | Partner Functional Area | SFKBER | CHAR | 16 | TFKB | FKBER | |||
SFUND | Partner Fund | BP_P_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
SGRANT_NBR | Sender Grant | GM_GRANT_SENDER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
SLOGSYS | Logical system of partner object | LOGSYSP | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
VRGNG | CO Business Transaction | CO_VORGANG | CHAR | 4 | TJ01 | J_VORGANG | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
OCLNT | Original client | OCLNT | NUMC | 3 | NUM3 | ||||
WRTTP | Value Type | CO_WRTTP | CHAR | 2 | CO_WRTTP | ||||
TSLVT | Balance carried forward in transaction currency | TSLVT9 | CURR | 17(2) | WERTV9 | ||||
TSL01 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL02 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL03 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL04 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL05 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL06 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL07 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL08 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL09 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL10 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL11 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL12 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL13 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL14 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL15 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
TSL16 | Total movements of period in controlling area currency | CSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSLVT | Balance carried forward in local currency | HSLVT9 | CURR | 17(2) | WERTV9 | ||||
HSL01 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL02 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL03 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL04 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL05 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL06 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL07 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL08 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL09 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL10 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL11 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL12 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL13 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL14 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL15 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
HSL16 | Total of transactions of the period in local currency | HSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSLVT | Balance carried forward in group currency | KSLVT9 | CURR | 17(2) | WERTV9 | ||||
KSL01 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL02 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL03 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL04 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL05 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL06 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL07 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL08 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL09 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL10 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL11 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL12 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL13 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL14 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL15 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
KSL16 | Total of transactions of the period in group currency | KSLXX9 | CURR | 17(2) | WERTV9 | ||||
MSLVT | Balance carried forward of quantity | MSLVT | QUAN | 15(3) | MENGV8 | ||||
MSL01 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL02 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL03 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL04 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL05 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL06 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL07 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL08 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL09 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL10 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL11 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL12 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL13 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL14 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL15 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
MSL16 | Total of the transactions of period in units of measure | MSLXX | QUAN | 15(3) | MENGV8 | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
AUTOM | Indicator: Automatic posting lines | AUTOM | CHAR | 1 | TEXT1 | ||||
DOCTY | FI-SL Document Type | DOCTY | CHAR | 2 | T889 | DOCTY | BAR | ||
ACTIV | Record type of reconciliation ledger | RCL_TRIG | CHAR | 4 | RCL_TRIG | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
WSDAT | Value Date for Currency Translation | WSDAT | DATS | 8 | DATUM | WSD | |||
REFDOCNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
REFRYEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
REFDOCLN | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
REFDOCCT | Document Type | DOCCT | CHAR | 1 | DOCCT | GCT | |||
REFACTIV | Business Transaction | GLVOR | CHAR | 4 | CHAR4 | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | TTYP | AWTYP | |||
AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC |
Key field | Non-key field |
How do I retrieve data from SAP table COFIP using ABAP code
The following ABAP code Example will allow you to do a basic selection on COFIP to SELECT all data from the tableDATA: WA_COFIP TYPE COFIP.
SELECT SINGLE *
FROM COFIP
INTO CORRESPONDING FIELDS OF WA_COFIP
WHERE...
How to access SAP table COFIP
Within an ECC or HANA version of SAP you can also view further information about COFIP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects