SAP Table COFP

Document Lines (project cash management)

COFP (Document Lines (project cash management)) 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 COFP to other SAP tables.

COFP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
BELNR Document Number CO_BELNR COBK CHAR 10 0
BUZEI Posting row CO_BUZEI NUMC 3 0
TWAER Transaction Currency TWAER TCURC CUKY 5 0
ZHLDT Funds Management - Update Date FM_ZHLDT DATS 8 0
GJAHR Fiscal Year GJAHR NUMC 4 0
PERIO Period CO_PERIO 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
VRGNG CO Business Transaction CO_VORGANG CHAR 4 0
POSIT Internal commitment item (8 chars) BP_POSIT CHAR 8 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
HKONT General Ledger Account HKONT SKB1 CHAR 10 0
WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
WKGBTRO Original value in controlling area currency WKGXXO CURR 15 2
WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
WTGBTRO Original value in transaction currency WTGXXO CURR 15 2
WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
WOGBTRO Original value in object currency WOGXXO CURR 15 2
BUKRS1 Company Code BUKRS T001 CHAR 4 0
GJAHR1 Fiscal Year GJAHR NUMC 4 0
BELNR1 Accounting Document Number BELNR_D CHAR 10 0
BUZEI1 Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BUKRS2 Company Code BUKRS T001 CHAR 4 0
GJAHR2 Fiscal Year GJAHR NUMC 4 0
BELNR2 Accounting Document Number BELNR_D CHAR 10 0
BUZEI2 Number of Line Item Within Accounting Document BUZEI NUMC 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
ETENRM Delivery Schedule Line Number ETENR NUMC 4 0
STUNR Step number STUNR NUMC 3 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
EINDT Item Delivery Date EINDT DATS 8 0
SGTXT Item Text SGTXT CHAR 50 0
GEBER Fund BP_GEBER CHAR 10 0
KURSF Exchange rate KURSF DEC 9 5
KUFIX Indicator: Fixing of Exchange Rate KUFIX CHAR 1 0
X Yes
NULL No
GBETR Hedged Amount in Foreign Currency GBETR CURR 13 2
KURSR Hedged Exchange Rate KURSR DEC 9 5
KURSFIKRS Exchange rate KURSF DEC 9 5
KZKRS Group Currency Exchange Rate KZKRS DEC 9 5
UMBKZ Transfer flag FM_UMBKZ CHAR 1 0
KBLNR Document Number for Earmarked Funds KBLNR CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
HI_FIVOR Financial transaction FIVOR NUMC 2 0
05 Funds reservation
10 Purchase requisition
20 Purchase order commitment
30 Post revenue, expenditure, asset, inventory stocks...
40 Post goods receipt, goods issue
50 Company Code Clearing
60 Post rcvbls and pybls from goods + services, down payment
80 Post bank clearing, bill of exchange
90 Post cash holdings
LO_FIVOR Financial transaction FIVOR NUMC 2 0
05 Funds reservation
10 Purchase requisition
20 Purchase order commitment
30 Post revenue, expenditure, asset, inventory stocks...
40 Post goods receipt, goods issue
50 Company Code Clearing
60 Post rcvbls and pybls from goods + services, down payment
80 Post bank clearing, bill of exchange
90 Post cash holdings
HI_ACCOUNT General Ledger Account HKONT CHAR 10 0
LO_ACCOUNT General Ledger Account HKONT CHAR 10 0
HI_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
LO_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
HI_KUNNR Customer Number KUNNR CHAR 10 0
LO_KUNNR Customer Number KUNNR CHAR 10 0
XDELETE Checkbox XFELD CHAR 1 0
X Yes
NULL No
HI_XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
LO_XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
ZAEHK Condition counter DZAEHK NUMC 2 0
CHAINBELNR Accounting Document Number BELNR_D CHAR 10 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
LEDNR Budget/Planning Ledger BP_LEDNR CHAR 4 0
BELTP Debit type BP_INOUT NUMC 1 0
0
1 Costs and credit-side payments
2 Revenues and debit-side payments
VERSN Version VERSN TKA09 CHAR 3 0
OWAER Currency Key OWAER TCURC CUKY 5 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0

COFP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
COFP BELNR COFP MANDT COBK CO Object: Document Header MANDT
COFP BELNR COFP KOKRS COBK CO Object: Document Header KOKRS
COFP BELNR COFP BELNR COBK CO Object: Document Header BELNR
COFP BUKRS COBK_KEY MANDT T001 Company Codes MANDT
COFP BUKRS COFP BUKRS T001 Company Codes BUKRS
COFP BUKRS1 COFP MANDT T001 Company Codes MANDT
COFP BUKRS1 COFP BUKRS1 T001 Company Codes BUKRS
COFP BUKRS2 COFP MANDT T001 Company Codes MANDT
COFP BUKRS2 COFP BUKRS2 T001 Company Codes BUKRS
COFP EBELN COFP MANDT EKKO Purchasing Document Header MANDT
COFP EBELN COFP EBELN EKKO Purchasing Document Header EBELN
COFP EBELP COFP EBELN EKPO Purchasing Document Item EBELN
COFP EBELP COFP EBELP EKPO Purchasing Document Item EBELP
COFP EBELP COFP MANDT EKPO Purchasing Document Item MANDT
COFP GSBER COBK_KEY MANDT TGSB Business Areas MANDT
COFP GSBER COFP GSBER TGSB Business Areas GSBER
COFP HKONT COFP HKONT SKB1 G/L account master (company code) SAKNR
COFP HKONT COFP MANDT SKB1 G/L account master (company code) MANDT
COFP HKONT COFP BUKRS1 SKB1 G/L account master (company code) BUKRS
COFP KOKRS COFP MANDT TKA01 Controlling Areas MANDT
COFP KOKRS COFP KOKRS TKA01 Controlling Areas KOKRS
COFP KUNNR COBK_KEY MANDT KNA1 General Data in Customer Master MANDT
COFP KUNNR COFP KUNNR KNA1 General Data in Customer Master KUNNR
COFP LIFNR COFP LIFNR LFA1 Vendor Master (General Section) LIFNR
COFP LIFNR COBK_KEY MANDT LFA1 Vendor Master (General Section) MANDT
COFP MANDT COFP MANDT T000 Clients MANDT
COFP OBJNR COFP MANDT ONR00 General Object Number MANDT
COFP OBJNR COFP OBJNR ONR00 General Object Number OBJNR
COFP OWAER COFP MANDT TCURC Currency Codes MANDT
COFP OWAER COFP OWAER TCURC Currency Codes WAERS
COFP TWAER COFP TWAER TCURC Currency Codes WAERS
COFP TWAER COFP MANDT TCURC Currency Codes MANDT
COFP VERSN COFP MANDT TKA09 Basic Settings for Versions MANDT
COFP VERSN COFP KOKRS TKA09 Basic Settings for Versions KOKRS
COFP VERSN COFP VERSN TKA09 Basic Settings for Versions VERSN