SAP table COFP (Document Lines (project cash management))

SAP table COFP has 4 primary key fields being MANDT,KOKRS,BELNR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
BELNR Document Number CHAR 10 0 COBK CO_BELNR
BUZEI Posting Row NUMC 3 0 CO_BUZEI
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
ZHLDT Funds Management Update Date DATS 8 0 FM_ZHLDT
GJAHR Fiscal Year NUMC 4 0 GJAHR
PERIO Period NUMC 3 0 CO_PERIO
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
VRGNG CO Business Transaction CHAR 4 0 * CO_VORGANG
POSIT Internal commitment item (8 chars) CHAR 8 0 BP_POSIT
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
HKONT General Ledger Account CHAR 10 0 SKB1 HKONT
WKGBTR Total Value in Controlling Area Currency CURR 15 2 WKGXXX_CS
WKGBTRO Original value in controlling area currency CURR 15 2 WKGXXO
WTGBTR Total Value in Transaction Currency CURR 15 2 WTGXXX_CS
WTGBTRO Original value in transaction currency CURR 15 2 WTGXXO
WOGBTR Total Value in Object Currency CURR 15 2 WOGXXX_CS
WOGBTRO Original value in object currency CURR 15 2 WOGXXO
BUKRS1 Company Code CHAR 4 0 T001 BUKRS
GJAHR1 Fiscal Year NUMC 4 0 GJAHR
BELNR1 Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI1 Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BUKRS2 Company Code CHAR 4 0 T001 BUKRS
GJAHR2 Fiscal Year NUMC 4 0 GJAHR
BELNR2 Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI2 Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
ETENRM Schedule Line Number NUMC 4 0 * ETENR
STUNR Step Number NUMC 3 0 * STUNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
GSBER Business Area CHAR 4 0 TGSB GSBER
BUKRS Company Code CHAR 4 0 T001 BUKRS
EINDT Item delivery date DATS 8 0 EINDT
SGTXT Item Text CHAR 50 0 SGTXT
GEBER Fund CHAR 10 0 * BP_GEBER
KURSF Exchange rate DEC 9 5 KURSF
KUFIX Indicator for Fixed Exchange Rate CHAR 1 0 KUFIX
GBETR Hedged Amount in Foreign Currency CURR 13 2 GBETR_CS
KURSR Hedged Exchange Rate DEC 9 5 KURSR
KURSFIKRS Exchange rate DEC 9 5 KURSF
KZKRS Group Currency Exchange Rate DEC 9 5 KZKRS
UMBKZ Transfer Flag CHAR 1 0 FM_UMBKZ
KBLNR Document Number for Earmarked Funds CHAR 10 0 * KBLNR
KBLPOS Earmarked Funds: Document Item NUMC 3 0 * KBLPOS
HI_FIVOR Financial Transaction NUMC 2 0 FIVOR
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 NUMC 2 0 FIVOR
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 CHAR 10 0 * HKONT
LO_ACCOUNT General Ledger Account CHAR 10 0 * HKONT
HI_LIFNR Account Number of Supplier CHAR 10 0 LIFNR
LO_LIFNR Account Number of Supplier CHAR 10 0 LIFNR
HI_KUNNR Customer Number CHAR 10 0 KUNNR
LO_KUNNR Customer Number CHAR 10 0 KUNNR
XDELETE Checkbox CHAR 1 0 XFELD
No
X Yes
HI_XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
LO_XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
ZAEHK Condition Counter NUMC 3 0 DZAEHK
CHAINBELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
MWSKZ Tax on sales/purchases code CHAR 2 0 * MWSKZ
LEDNR Budget/Planning Ledger CHAR 4 0 BP_LEDNR
BELTP Debit Type NUMC 1 0 BP_INOUT
0
1 Costs and credit-side payments
2 Revenues and debit-side payments
VERSN Version CHAR 3 0 TKA09 VERSN
OWAER Currency Key CUKY 5 0 TCURC OWAER
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM

COFP foreign key relationships

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