SAP table COFIS (Actual line items for reconciliation ledger)

SAP table COFIS has 2 primary key fields being RCLNT,GL_SIRID.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
GL_SIRID Record number of the line item record CHAR 18 0 GU_RECID
RLDNR Ledger CHAR 2 0 T881 RLDNR
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
RVERS Version CHAR 3 0 TKA09 VERSN
RYEAR Fiscal Year NUMC 4 0 GJAHR
RTCUR Currency Key for Amounts in Controlling Area Currency CUKY 5 0 TCURC RACUR
RUNIT Base Unit of Measure UNIT 3 0 T006 MEINS
DRCRK Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
POPER Posting period NUMC 3 0 POPER
DOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
DOCLN Document line CHAR 3 0 DOCLN
RBUKRS Company Code CHAR 4 0 T001 BUKRS
RACCT Cost Element CHAR 10 0 CSKA KSTAR
RHRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 TKKH1 HRKFT
ROBART Reconciliation ledger object type (technical) CHAR 2 0 COFI_OB_CV
RSCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
RBUSA Business Area CHAR 4 0 TGSB GSBER
RFAREA Functional Area CHAR 16 0 TFKB FKBER
RFUND Fund CHAR 10 0 BP_GEBER
RGRANT_NBR Receiver Grant CHAR 20 0 GM_GRANT_RECEIVER
RLOGSYS Logical System of Object CHAR 10 0 TBDLS LOGSYSO
SBUKRS Company Code of Partner CHAR 4 0 T001 PBUKRS
SACCT Cost element of partner CHAR 10 0 CSKA PKSTAR
SHRKFT Origin of partner (subdivision of cost element) CHAR 4 0 TKKH1 PHRKFT
SOBART Partner object type (for reconciliation ledger) CHAR 2 0 COFI_PO_CV
SSCOPE Partner object class CHAR 2 0 PSCOPE_CV
SBUSA Trading partner's business area CHAR 4 0 TGSB PARGB
SFAREA Partner Functional Area CHAR 16 0 TFKB SFKBER
SFUND Partner Fund CHAR 10 0 BP_P_GEBER
SGRANT_NBR Sender Grant CHAR 20 0 GM_GRANT_SENDER
SLOGSYS Logical system of partner object CHAR 10 0 TBDLS LOGSYSP
VRGNG CO Business Transaction CHAR 4 0 TJ01 CO_VORGANG
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
OCLNT Original client NUMC 3 0 OCLNT
WRTTP Value Type CHAR 2 0 CO_WRTTP
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
3C Control Costs
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
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
5A Payment Obligations from Purchasing Down Payments
60 Parked Document
61 Down Payments
62 Planned Payments
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
6A Planned Down Payments
6B Clarification Worklist FI-CA
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
U1 Source Document - Statistical Actuals
U4 Source Document - Actual
TSL Value in Controlling Area Currency CURR 23 2 VCCUR9
HSL Value in Local Currency CURR 23 2 VLCUR9
KSL Value in Group Currency CURR 23 2 VGCUR9
MSL Quantity QUAN 15 3 QUAN1
SGTXT Item Text CHAR 50 0 SGTXT
AUTOM Indicator: Automatic posting lines CHAR 1 0 AUTOM
DOCTY FI-SL Document Type CHAR 2 0 T889 DOCTY
ACTIV Record type of reconciliation ledger CHAR 4 0 RCL_TRIG
RKAL Summarized CO data
RKRF Confirmation to FI (admin. record)
BVORG Number of Cross-Company Code Posting Transaction CHAR 16 0 BVORG
BUDAT Posting Date in the Document DATS 8 0 BUDAT
WSDAT Value Date for Currency Translation DATS 8 0 WSDAT
REFDOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
REFRYEAR Fiscal Year NUMC 4 0 GJAHR
REFDOCLN Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
REFDOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction CHAR 4 0 GLVOR
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 USNAM
AWTYP Reference procedure CHAR 5 0 TTYP AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
STOKZ Indicator: Document was reversed CHAR 1 0 CO_STOKZ
STFLG Identifier for reversal document CHAR 1 0 CO_STFLG
ACCOUNT Reconciliation Account for Reconciliation Posting CHAR 10 0 SKB1 RACCT_RCL
VAL_REFDOCLN Posting Row in Operative Version CHAR 3 0 VAL_REFDOCLN

COFIS foreign key relationships

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