SAP table COVP (Generated Table for View)

SAP table COVP 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
PERIO Period NUMC 3 0 CO_PERIO
WTGBTR Total Value in Transaction Currency CURR 23 2 WTGXXX
WOGBTR Total Value in Object Currency CURR 23 2 WOGXXX
WKGBTR Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKFBTR Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
PAGBTR Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAFBTR Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
MEGBTR Total Quantity QUAN 15 3 MEGXXX
MEFBTR Fixed Quantity QUAN 15 3 MEFXXX
MBGBTR Total quantity entered QUAN 15 3 MBGXXX
MBFBTR Fixed quantity entered QUAN 15 3 MBFXXX
LEDNR Ledger for Controlling Objects CHAR 2 0 LEDNR
00 Standard ledger
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
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
VERSN Version CHAR 3 0 TKA09 VERSN
KSTAR Cost Element CHAR 10 0 CSKA KSTAR
HRKFT CO key subnumber CHAR 14 0 COKEY CO_SUBKEY
VRGNG CO Business Transaction CHAR 4 0 TJ01 CO_VORGANG
PAROB Partner Object CHAR 22 0 ONR00 PAROB
PAROB1 Partner object (always filled) CHAR 22 0 ONR00 PAROB1
USPOB Source Object (Cost Center/Activity Type) CHAR 22 0 ONR00 USPOB
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
PARGB Trading partner's business area CHAR 4 0 TGSB PARGB
BEKNZ Debit/credit indicator CHAR 1 0 BEKNZ
A Special: Sender credit from settlement
H Credit posting or sender credit posting
L Special: Sender credit from delivery to inventory
S Debit posting or receiver debit posting
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
OWAER Currency Key CUKY 5 0 TCURC OWAER
MEINH Unit of Measure UNIT 3 0 T006 CO_MEINH
MEINB Posted Unit of Measure UNIT 3 0 T006 MEINB
MVFLG Quantity Complete/Incomplete CHAR 1 0 CO_MVFLG
Quantity is incomplete if amount = 0
X Quantity is complete, even if amount = 0
Y Quantity is incomplete, even if amount <> 0
SGTXT Segment text CHAR 50 0 CO_SGTXT
REFBZ Posting Row of Reference Document NUMC 3 0 CO_REFBZ
ZLENR Document Item Number NUMC 3 0 DZLENR
BW_REFBZ Posting Row in Operative Version NUMC 3 0 BW_REFBZ
GKONT Offsetting Account Number CHAR 10 0 GKONT
GKOAR Offsetting Account Type CHAR 1 0 GKOAR
WERKS Plant CHAR 4 0 T001W WERKS_D
MATNR Material Number CHAR 40 0 MARA MATNR
RBEST Category of Reference Purchase Order NUMC 3 0 CO_RBEST
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
ERLKZ Completion Indicator for Line Item CHAR 1 0 KBLERLKZ
PERNR Personnel Number NUMC 8 0 PERNR_D
BTRKL Amount Class for Value in Controlling Area Currency NUMC 2 0 CO_BTRKL
OBJNR_N1 Auxiliary account assignment 1 CHAR 22 0 ONR00 OBJNR_N1
OBJNR_N2 Auxiliary account assignment 2 CHAR 22 0 ONR00 OBJNR_N2
OBJNR_N3 Auxiliary account assignment 3 CHAR 22 0 ONR00 OBJNR_N3
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
BELTP Debit Type NUMC 1 0 BP_INOUT
0
1 Costs and credit-side payments
2 Revenues and debit-side payments
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
FKBER Functional Area CHAR 16 0 TFKB FKBER
SCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
LOGSYSO Logical System of Object CHAR 10 0 TBDLS LOGSYSO
PKSTAR Cost element of partner CHAR 10 0 PKSTAR
PBUKRS Company Code of Partner CHAR 4 0 T001 PBUKRS
PFKBER Partner Functional Area CHAR 16 0 TFKB SFKBER
PSCOPE Partner object class CHAR 2 0 PSCOPE_CV
LOGSYSP Logical system of partner object CHAR 10 0 TBDLS LOGSYSP
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
BWSTRAT Strategy for Determining an Allocation Price CHAR 1 0 BWSTRAT
1 Plan price for the period
2 Plan price as average of all fiscal year periods
3 Plan price as average of remaining periods of fiscal year
4 Actual price of prior period
5 Most up-to-date actual price in the past
6 Most up-to-date plan price
7 Actual price for the period
8 External actual price
9 Frozen price (material ledger)
OBJNR_HK Object Number of Origin Object CHAR 22 0 OBJNR_HK
TIMESTMP Time created (Greenwich Meantime) DEC 16 0 RKE_HZSTMP
QMNUM Notification Number CHAR 12 0 QMNUM
GEBER Fund CHAR 10 0 FM_FUND
PGEBER Partner Fund CHAR 10 0 FM_PFUND
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
PGRANT_NBR Partner Grant CHAR 20 0 GM_GRANT_PARTNER
REFBZ_FI Posting Item of FI Reference Document NUMC 3 0 REFBZ_FI
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_PSEGMENT
PRCTR Profit Center CHAR 10 0 PRCTR
PPRCT Partner Profit Center CHAR 10 0 PPRCTR
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period CHAR 10 0 FM_PBUDGET_PERIOD
PRODPER Production Month for JVA in CO NUMC 6 0 PRODPER
PERAB From Period NUMC 3 0 CO_PERAB
PERBI To period NUMC 3 0 CO_PERBI
BLDAT Document Date DATS 8 0 CO_BLDAT
BUDAT Posting Date DATS 8 0 CO_BUDAT
CPUDT Date Document Was Created DATS 8 0 CO_CPUDT
USNAM User Name CHAR 12 0 SYUNAME
BLTXT Document Header Text CHAR 50 0 CO_BLTXT
STFLG Identifier for reversal document CHAR 1 0 CO_STFLG
STOKZ Indicator: Document was reversed CHAR 1 0 CO_STOKZ
REFBT Document Type of Reference Document CHAR 1 0 CO_REFBT
REFBN Reference Document Number CHAR 10 0 CO_REFBN
REFBK Company Code of FI Document CHAR 4 0 T001 CO_REFBK
REFGJ Fiscal Year of Reference Document NUMC 4 0 CO_REFGJ
BLART Document Type of FI Reference Document CHAR 2 0 T003 CO_REFBA
LDGRP Ledger Group CHAR 4 0 FAGL_LDGRP
ORGVG Original CO Business Transaction CHAR 4 0 T022 CO_ORGVG
SUMBZ Number of Posting Lines for Local Objects NUMC 3 0 CO_SUMBZ
DELBZ Number of Deleted Line Items NUMC 3 0 CO_DELBZ
WSDAT Value Date for Currency Translation DATS 8 0 WSDAT
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
VARNR CO actual postings fast input: Variant CHAR 5 0 CO_VARNR
KWAER Controlling area currency CUKY 5 0 TCURC KWAER
CTYP1 Currency Type 1 in CO Standard Ledger CHAR 2 0 CO_CTYP1
CTYP2 Currency Type 2 in CO Standard Ledger CHAR 2 0 CO_CTYP2
CTYP3 Currency Type 3 in CO Standard Ledger CHAR 2 0 CO_CTYP3
CTYP4 Currency Type 4 in CO Standard Ledger CHAR 2 0 CO_CTYP4
AWTYP Reference procedure CHAR 5 0 AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
CPUTM Time of Entry TIMS 6 0 CPUTM
ALEBZ Number of Posting Rows Sent to External Systems NUMC 3 0 CO_ALEBZ
ALEBN For ALE: CO Document Number in Generating System CHAR 10 0 CO_ALEBN
AWSYS Logical system of source document CHAR 10 0 AWSYS
AWREF_REV Reversal: Reference Document No. of Document to Be Reversed CHAR 10 0 AWREF_REV
AWORG_REV Reversal: Reference Organizations of Document to Be Reversed CHAR 10 0 AWORG_REV
AWKEY Reference Key CHAR 20 0 AWKEY
VALDT Special Valuation Date for Cost Accounting DATS 8 0 CO_VALDT
KOKRS_SENDER Controlling Area in Sender System CHAR 4 0 KOKRS_SENDER
BELNR_SENDER CO Document Number of Controlling Document in Sender System CHAR 10 0 COBELNR_SENDER
LOGSYSTEM_SENDER Logical System of the Sender CHAR 10 0 LOGSYSTEM_SENDER
REPROCESSING_STATUS_CODE Reprocessing status code CHAR 1 0 FINS_REPROCESSING_STATUS_CODE
1 Invalid after Correction
2 Reverses Document after Correction
3 Valid after Correction
4 Temporary Posting
5 Reverses Temporary Posting
K_GJAHR Fiscal Year NUMC 4 0 GJAHR
K_VERSN Version in CO Document Header CHAR 3 0 TKA09 VERSN_COBK
K_VRGNG CO Business Transaction CHAR 4 0 TJ01 CO_VORGANG
K_TIMESTMP Time created (Greenwich Meantime) DEC 16 0 RKE_HZSTMP
P_AWTYP Reference procedure CHAR 5 0 AWTYP
P_AWKEY Reference Key CHAR 20 0 AWKEY
P_AWSYS Logical system of source document CHAR 10 0 AWSYS
P_KWAER Controlling area currency CUKY 5 0 KWAER
ACCAS Account Assignment CHAR 30 0 ACCAS
ACCASTY Object Type CHAR 2 0 J_OBART
KOSTL Cost Center CHAR 10 0 KOSTL
LSTAR Activity Type CHAR 6 0 LSTAR
AUFNR Order Number CHAR 12 0 AUFNR
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
PSPNR Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
VBELN Sales Document CHAR 10 0 VBELN_VA
VBPOSNR Sales Document Item NUMC 6 0 POSNR_VA
CE4KEY Assignment Object Key for CO-PA Data Basis (CE4xxxx) NUMC 10 0 COPA_CE4KEY
ERKRS Operating concern CHAR 4 0 ERKRS
PACCAS Partner Account Assignment CHAR 30 0 PACCAS
PACCASTY Partner Object Type CHAR 2 0 CO_POBART
PKOSTL Partner Cost Center CHAR 10 0 PAR_KOSTL
PAUFNR Partner order number CHAR 12 0 PAR_AUFNR
PAUTYP Partner Order Category NUMC 2 0 FCO_PAR_AUFTYP
PPSPNR Partner Work Breakdown Structure Element CHAR 24 0 FCO_PAR_POSID
PCE4KEY Partner Assignment Object Key for CO-PA Data Basis (CE4xxxx) NUMC 10 0 PCOPA_CE4KEY
PLSTAR Partner activity CHAR 6 0 PAR_LSTAR
PVBELN Number of Partner Sales Order CHAR 10 0 PAR_KDAUF
PVBPOSNR Partner Sales Order Item NUMC 6 0 PAR_KDPOS
P_POSNR Accounting Document Line Item Number NUMC 10 0 POSNR_ACC
PSPID Project definition CHAR 24 0 PS_PSPID
PPSPID Partner Project CHAR 24 0 FCO_PAR_PSPID
QUANT1 Additional Quantity 1 QUAN 15 3 FCO_QUAN1
QUANT2 Additional Quantity 2 QUAN 15 3 FCO_QUAN2
QUANT3 Additional Quantity 3 QUAN 15 3 FCO_QUAN3
QUNIT1 Additional Unit of Measure 1 UNIT 3 0 FCO_QUNIT1
QUNIT2 Additional Unit of Measure 2 UNIT 3 0 FCO_QUNIT2
QUNIT3 Additional Unit of Measure 3 UNIT 3 0 FCO_QUNIT3

COVP foreign key relationships

Table Field Check Table Check Field
0 COVP BELNR COBK CO Object: Document Header KOKRS
0 COVP BELNR COBK CO Object: Document Header BELNR
1 COVP BLART T003 Document Types MANDT
0 COVP BUKRS T001 Company Codes BUKRS
1 COVP FKBER TFKB Functional areas FKBER
0 COVP GSBER TGSB Business Areas MANDT
0 COVP GSBER TGSB Business Areas GSBER
1 COVP HRKFT COKEY CO key sub-numbers MANDT
1 COVP HRKFT COKEY CO key sub-numbers HRKFT
0 COVP KOKRS TKA01 Controlling Areas MANDT
1 COVP KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
1 COVP KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
0 COVP KURST TCURV Exchange rate types for currency translation MANDT
0 COVP KURST TCURV Exchange rate types for currency translation KURST
1 COVP KWAER TCURC Currency Codes MANDT
1 COVP KWAER TCURC Currency Codes WAERS
0 COVP K_VERSN TKA09 Basic Settings for Versions MANDT
0 COVP K_VERSN TKA09 Basic Settings for Versions KOKRS
0 COVP K_VERSN TKA09 Basic Settings for Versions VERSN
1 COVP K_VRGNG TJ01 Business Transactions VRGNG
0 COVP LOGSYSO TBDLS Logical system LOGSYS
1 COVP LOGSYSP TBDLS Logical system LOGSYS
0 COVP LOGSYSTEM TBDLS Logical system LOGSYS
1 COVP MANDT T000 Clients MANDT
0 COVP MATNR MARA General Material Data MATNR
1 COVP MEINB T006 Units of Measurement MSEHI
0 COVP MEINH T006 Units of Measurement MSEHI
1 COVP OBJNR ONR00 General Object Number MANDT
0 COVP OBJNR_N1 ONR00 General Object Number MANDT
1 COVP OBJNR_N2 ONR00 General Object Number MANDT
0 COVP OBJNR_N3 ONR00 General Object Number MANDT
1 COVP OWAER TCURC Currency Codes MANDT
1 COVP OWAER TCURC Currency Codes WAERS
0 COVP PARGB TGSB Business Areas MANDT
0 COVP PARGB TGSB Business Areas GSBER
1 COVP PAROB ONR00 General Object Number MANDT
0 COVP PAROB1 ONR00 General Object Number MANDT
1 COVP PBUKRS T001 Company Codes BUKRS
0 COVP PFKBER TFKB Functional areas FKBER
1 COVP PSEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 COVP REFBK T001 Company Codes BUKRS
1 COVP SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 COVP TWAER TCURC Currency Codes MANDT
0 COVP TWAER TCURC Currency Codes WAERS
1 COVP USPOB ONR00 General Object Number MANDT
0 COVP VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 COVP VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 COVP VERSN TKA09 Basic Settings for Versions MANDT
1 COVP VERSN TKA09 Basic Settings for Versions KOKRS
1 COVP VERSN TKA09 Basic Settings for Versions VERSN
0 COVP VRGNG TJ01 Business Transactions VRGNG
1 COVP WERKS T001W Plants/Branches MANDT
1 COVP WERKS T001W Plants/Branches WERKS