1. Home
  2. Resources
  3. SAP Tables
  4. COFIS - Actual line items for reconciliation ledger

SAP Table COFIS

Actual line items for reconciliation ledger

COFIS (Actual line items for reconciliation ledger) 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 COFIS to other SAP tables.

COFIS table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
GL_SIRID Record number of the line item record GU_RECID CHAR 18 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version VERSN TKA09 CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RTCUR Currency Key for Amounts in Controlling Area Currency RACUR TCURC CUKY 5 0
RUNIT Base Unit of Measure MEINS T006 UNIT 3 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
POPER Posting period POPER NUMC 3 0
DOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Accounting Document Number BELNR_D CHAR 10 0
DOCLN Document line DOCLN CHAR 3 0
RBUKRS Company Code BUKRS T001 CHAR 4 0
RACCT Cost Element KSTAR CSKA CHAR 10 0
RHRKFT Origin Group as Subdivision of Cost Element HRKFT TKKH1 CHAR 4 0
ROBART Reconciliation ledger object type (technical) COFI_OB_CV CHAR 2 0
RSCOPE Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
RBUSA Business Area GSBER TGSB CHAR 4 0
RFAREA Functional Area FKBER TFKB CHAR 16 0
RFUND Fund BP_GEBER CHAR 10 0
RGRANT_NBR Receiver Grant GM_GRANT_RECEIVER CHAR 20 0
RLOGSYS Logical system of object LOGSYSO TBDLS CHAR 10 0
SBUKRS Company code of partner PBUKRS T001 CHAR 4 0
SACCT Cost element of partner PKSTAR CSKA CHAR 10 0
SHRKFT Origin of partner (subdivision of cost element) PHRKFT TKKH1 CHAR 4 0
SOBART Partner object type (for reconciliation ledger) COFI_PO_CV CHAR 2 0
SSCOPE Partner object class PSCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
SBUSA Trading partner's business area PARGB TGSB CHAR 4 0
SFAREA Partner Functional Area SFKBER TFKB CHAR 16 0
SFUND Partner Fund BP_P_GEBER CHAR 10 0
SGRANT_NBR Sender Grant GM_GRANT_SENDER CHAR 20 0
SLOGSYS Logical system of partner object LOGSYSP TBDLS CHAR 10 0
VRGNG CO Business Transaction CO_VORGANG TJ01 CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
OCLNT Original client OCLNT NUMC 3 0
WRTTP Value Type CO_WRTTP CHAR 2 0
01 Plan
02 Plan: Splitting Among Activity Types
03 Actual: Splitting Among Activity Types
04 Actual
05 Target
06 Target (WIP)
07 Target: Splitting Among Activity Types
08 Plan: Correction for Internal Bus.Vol Between Cost Centers
09 Actual: Correction for IBV Between Cost Centers
10 Statistical Plan
11 Statistical Actual
12 Down Payment as Operating Expense
13 Statistical Down Payments as Expense
19 Order Receipt/Orders Balance
21 Commitments from Purchase Requisition
22 Purchase Order Commitment
23 Reservation Commitment
24 Funds Commitment
25 Remainder from Apportioned Orders/Networks (Order Commitmts)
26 Commitments from Transfer Price Agreement
28 Value from Customer Quotation
29 Value from Sales Order
2A Funds Reservation
2B Funds Precommitment
30 Scrap
31 Variances
32 Results Analysis and WIP Calculation
33 Results Analysis: Credit Side/Debit Side
34 Results Analysis: Cost of Sales from Resource-Rel. Billing
35 Plan for True Investments
36 Budget for True Investments
37 Program Budget for True Investments
38 Program Plan for True Investments
39 Request Plan
40 Request Plan for True Investments
41 Budget
42 Assigned Budget
43 Payment Budget
44 Payment Budget: Assigned Funds
45 Payment budget: Releases
46 Cash Release
47 Program Budget
48 Program Plan
49 Planned Accrual Calculations: Results Analysis, WIP Calc.
4A Payment Budget: Statistical
4B Budget Balance
4C Payment Budget: Clear on Revenue Item
50 Purchase Requisitions
5A Payment Obligations from Purchasing Down Payments
51 Purchase Orders
52 Business Trip Commitments
53 User-Defined Payment Commitment (Financial Transaction 50)
54 Invoices
55 Bank clearings
56 User-Defined Payment Obligation (Financial Transaction 70)
57 Payments
58 Down Payment Requests
59 Down Payments for Bank Clearing
60 Parked Document
61 Down Payments
62 Planned Payments
6A Planned Down Payments
6B Clarification Worklist FI-CA
63 Down Payment Clearings
64 Funds Transfers
65 Funds Commitment
66 Profit Transfer Postings
67 Other Statistical Documents
68 Other Non-Statistical Document
69 Commitment Budget: Funds Reservations
70 Commitment Budget
71 Commitment Budget - Assigned Funds
72 Commitment Budget: Releases
73 Purchase Order: Cycle Counting Blocking Amount
74 Funds Reservation: Cycle Counting Blocking Amount
75 Commitment Budget: Funds Reservation Cycle Cntg Blckng Amt
76 Commitment Budget: Purchase Orders, Cycle Counting Blckg Amt
77 Commitment Budget: Purchase Orders
7C Commitment Budget: Expense Type Budget for Revenue Item
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation
85 Payment Budget: Reservations
86 Payment Budget: Earmarked Funds
87 Payment Budget: Reserved Releases
88 Payment Budget: Earmarked Releases
89 Commitment Budget: Reservations
90 Commitment Budget: Earmarked Funds
91 Commitment Budget: Reserved Releases
92 Commitment Budget: Earmarked Releases
93 Financial Budget
94 Payment Budget: Adjustment Field
95 Actual CO Postings
96 Purchase Order Overhead
97 Purchase Requisition Overhead
98 Funds Reservation (CO)
99 Financial Result
9A Financial Result: Statistical
9B Financial Budget: Statistical
9C Financial Budget Plan Balance
9D Funds Management: HR Integration
9E Approved Total Costs/Revenue
D1 Distribution of Actual Costs (By Source Assignment)
D2 Distribution of Commitments (By Source Assignment)
D3 Distribution of Work-in-Process (By Source Assignment)
D4 Distribution of Earned Value (By Source Assignment)
D5 Distribution of Payments (By Source Assignment)
D6 Distribution of Down Payments (By Source Assignment)
P1 Earned Value (Plan)
P2 Earned Value (Actual)
P3 Capitalized Remainder Costs
3C Control Costs
TSL Value in Controlling Area Currency VCCUR9 CURR 17 2
HSL Value in local currency VLCUR9 CURR 17 2
KSL Value in group currency VGCUR9 CURR 17 2
MSL Quantity QUAN1 QUAN 15 3
SGTXT Item Text SGTXT CHAR 50 0
AUTOM Indicator: Automatic posting lines AUTOM CHAR 1 0
DOCTY FI-SL Document Type DOCTY T889 CHAR 2 0
ACTIV Record type of reconciliation ledger RCL_TRIG CHAR 4 0
RKAL Summarized CO data
RKRF Confirmation to FI (admin. record)
BVORG Number of Cross-Company Code Posting Transaction BVORG CHAR 16 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
WSDAT Value Date for Currency Translation WSDAT DATS 8 0
REFDOCNR Accounting Document Number BELNR_D CHAR 10 0
REFRYEAR Fiscal Year GJAHR NUMC 4 0
REFDOCLN Number of Line Item Within Accounting Document BUZEI NUMC 3 0
REFDOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction GLVOR CHAR 4 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
AWTYP Reference Transaction AWTYP TTYP CHAR 5 0
AWORG Reference Organizational Units AWORG CHAR 10 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
STOKZ Indicator: Document Has Been Reversed CO_STOKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STFLG Identifier for reversal document CO_STFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
ACCOUNT Reconciliation Account for Reconciliation Posting RACCT_RCL SKB1 CHAR 10 0
VAL_REFDOCLN Posting Row in Operative Version VAL_REFDOCLN CHAR 3 0

COFIS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
COFIS ACCOUNT COFIS ACCOUNT SKB1 G/L account master (company code) SAKNR
COFIS ACCOUNT COFIS RCLNT SKB1 G/L account master (company code) MANDT
COFIS ACCOUNT COFIS RBUKRS SKB1 G/L account master (company code) BUKRS
COFIS AWTYP COFIS AWTYP TTYP Object Types for Accounting AWTYP
COFIS DOCTY COFIS DOCTY T889 FI-SL Document Types DOCTY
COFIS DOCTY COFIS RCLNT T889 FI-SL Document Types MANDT
COFIS KOKRS COFIS KOKRS TKA01 Controlling Areas KOKRS
COFIS KOKRS COFIS RCLNT TKA01 Controlling Areas MANDT
COFIS LOGSYS COFIS LOGSYS TBDLS Logical system LOGSYS
COFIS RACCT COFIS RCLNT CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
COFIS RACCT * CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
COFIS RACCT COFIS RACCT CSKA Cost Elements (Data Dependent on Chart of Accounts) KSTAR
COFIS RBUKRS COFIS RCLNT T001 Company Codes MANDT
COFIS RBUKRS COFIS RBUKRS T001 Company Codes BUKRS
COFIS RBUSA COFIS RBUSA TGSB Business Areas GSBER
COFIS RBUSA COFIS RCLNT TGSB Business Areas MANDT
COFIS RCLNT COFIS RCLNT T000 Clients MANDT
COFIS RFAREA COFIS RCLNT TFKB Functional areas MANDT
COFIS RFAREA COFIS RFAREA TFKB Functional areas FKBER
COFIS RHRKFT COFIS KOKRS TKKH1 Origin in CO Object KOKRS
COFIS RHRKFT * TKKH1 Origin in CO Object KOATY
COFIS RHRKFT COFIS RHRKFT TKKH1 Origin in CO Object HRKFT
COFIS RHRKFT COFIS RCLNT TKKH1 Origin in CO Object MANDT
COFIS RLDNR COFIS RCLNT T881 Ledger Master MANDT
COFIS RLDNR COFIS RLDNR T881 Ledger Master RLDNR
COFIS RLOGSYS COFIS RLOGSYS TBDLS Logical system LOGSYS
COFIS RTCUR COFIS RTCUR TCURC Currency Codes WAERS
COFIS RTCUR COFIS RCLNT TCURC Currency Codes MANDT
COFIS RUNIT COFIS RCLNT T006 Units of Measurement MANDT
COFIS RUNIT COFIS RUNIT T006 Units of Measurement MSEHI
COFIS RVERS COFIS RCLNT TKA09 Basic Settings for Versions MANDT
COFIS RVERS COFIS KOKRS TKA09 Basic Settings for Versions KOKRS
COFIS RVERS COFIS RVERS TKA09 Basic Settings for Versions VERSN
COFIS SACCT COFIS RCLNT CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
COFIS SACCT * CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
COFIS SACCT COFIS SACCT CSKA Cost Elements (Data Dependent on Chart of Accounts) KSTAR
COFIS SBUKRS COFIS RCLNT T001 Company Codes MANDT
COFIS SBUKRS COFIS SBUKRS T001 Company Codes BUKRS
COFIS SBUSA COFIS RCLNT TGSB Business Areas MANDT
COFIS SBUSA COFIS SBUSA TGSB Business Areas GSBER
COFIS SFAREA COFIS RCLNT TFKB Functional areas MANDT
COFIS SFAREA COFIS SFAREA TFKB Functional areas FKBER
COFIS SHRKFT COFIS SHRKFT TKKH1 Origin in CO Object HRKFT
COFIS SHRKFT COFIS RCLNT TKKH1 Origin in CO Object MANDT
COFIS SHRKFT COFIS KOKRS TKKH1 Origin in CO Object KOKRS
COFIS SHRKFT * TKKH1 Origin in CO Object KOATY
COFIS SLOGSYS COFIS SLOGSYS TBDLS Logical system LOGSYS
COFIS VRGNG COFIS VRGNG TJ01 Business Transactions VRGNG