Menu

SAP Table COER

Sales Order Value Revenue

The table COER (Sales Order Value Revenue) is a standard table in SAP ERP. It belongs to the package KPSD.

Technical Information

Table COER
Short Text Sales Order Value Revenue
Package KPSD
Table Type Transparent Table

Fields for Table COER

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
LEDNR Ledger for Controlling objects LEDNR CHAR 2
OBJNR Object number J_OBJNR CHAR 22 ONR00
GJAHR Fiscal Year GJAHR NUMC 4
WRTTP Value Type CO_WRTTP CHAR 2
KSTAR Cost Element KSTAR CHAR 10 CSKA
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 *
VRGNG CO Business Transaction CO_VORGANG CHAR 4 *
VBUND Company ID of trading partner RASSC CHAR 6 T880
TWAER Transaction Currency TWAER CUKY 5 TCURC
PERBL Period block PERBL NUMC 3
VERSN Version VERSN CHAR 3 TKA09
VBELN Sales and Distribution Document Number VBELN CHAR 10 VBUK
VPOSN Item number of the SD document POSNR NUMC 6 VBUP
KONDZ Condition type counter (internal) PS_KONDZ CHAR 10
AENDZ Change counter for customer order PS_AENDZ NUMC 4
KSCHL Condition type KSCHA CHAR 4 *
STUNR Step number STUNR NUMC 3 *
ZAEHK Condition counter DZAEHK NUMC 2
LAENZ Last change number for customer order PS_LAENZ NUMC 4
BEKNZ Debit/credit indicator BEKNZ CHAR 1
VBTYP SD document category VBTYP CHAR 1
FKART Billing Type FKART CHAR 4 *
FKTYP Billing category FKTYP CHAR 1
PERIV Fiscal Year Variant PERIV CHAR 2 *
GSBER Business Area GSBER CHAR 4 *
VKORG Sales Organization VKORG CHAR 4 *
VTWEG Distribution Channel VTWEG CHAR 2 *
KUNAG Sold-to party KUNAG CHAR 10 *
BUKRS Company Code BUKRS CHAR 4 T001
KOKRS Controlling Area KOKRS CHAR 4 TKA01
SPART Division SPART CHAR 2 TSPA
WERKS Plant WERKS_D CHAR 4 T001W
BLART Document Type BLART CHAR 2 T003
BLDAT Document Date in Document BLDAT DATS 8
BUDAT Posting Date in the Document BUDAT DATS 8
WADAT Goods Issue Date WADAT DATS 8
FKDAT Billing date for billing index and printout FKDAT DATS 8
BUDGJ Posting Date YYYY BDATJ NUMC 4
BUDPE Posting period POPER NUMC 3
WADGJ Posting Date YYYY BDATJ NUMC 4
WADPE Posting period POPER NUMC 3
FKDGJ Posting Date YYYY BDATJ NUMC 4
FKDPE Posting period POPER NUMC 3
FILKD Account Number of the Branch FILKD CHAR 10
SGTXT Segment text CO_SGTXT CHAR 50
MATNR Material Number MATNR CHAR 18 MARA
MATKL Material Group MATKL CHAR 9 T023
ZTERM Terms of Payment Key DZTERM CHAR 4
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13
WKURS Exchange Rate WKURS DEC 9
MEINH Unit of Measure CO_MEINH UNIT 3 T006
MEINB Posted Unit of Measure MEINB UNIT 3 T006
ORGWTH Planned value in local currency WERTH1 CURR 15
WHGBTR Total value in local currency WHGXXX CURR 15
ORGWTT Planned value in transaction currency WERTT1 CURR 15
WTGBTR Total Value in Transaction Currency WTGXXX CURR 15
ORGWTO Planned value in object currency WERTO1 CURR 15
WOGBTR Total Value in Object Currency WOGXXX CURR 15
ORGWTL Planned value in ledger currency WERTL1 CURR 15
WLGBTR Total value in ledger currency WLGXXX CURR 15
ORGWTK Planned value in controlling area currency WERTK1 CURR 15
WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15
MEGBTR Total Quantity MEGXXX QUAN 15
CITYC City Code CITYC CHAR 4 T005G
BONUS Volume rebate group BONUS CHAR 2 TVBO
PROVG Commission group PROVG CHAR 2 TVPR
VKGRP Sales Group VKGRP CHAR 3 TVKGR
VKBUR Sales Office VKBUR CHAR 4 TVBUR
FBUDA Date on which services rendered FBUDA DATS 8
AUBEL Sales Document VBELN_VA CHAR 10 VBUK
AUPOS Sales Document Item POSNR_VA NUMC 6 VBUP
PRCTR Profit Center PRCTR CHAR 10 *
FKIMG Actual Invoiced Quantity FKIMG QUAN 13
VRKME Sales unit VRKME UNIT 3 T006
FKLMG Billing quantity in stockkeeping unit FKLMG QUAN 13
MEINS Base Unit of Measure MEINS UNIT 3 T006
KAPPL Application KAPPL CHAR 2 T681A
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 T683
KNTYP Condition category (examples: tax, freight, price, cost) KNTYP CHAR 1
ANGDT Quotation/Inquiry is valid from ANGDT_V DATS 8
BNDDT Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8
KBVER Allowed deviation in quantity (in percent) KBVER DEC 3
KEVER Days by which the quantity can be shifted KEVER DEC 3
AWAHR Order probability of the item AWAHR NUMC 3
PRSDT Date for pricing and exchange rate PRSDT DATS 8
SHKZG Debit/Credit Indicator SHKZG CHAR 1
LFIMG Actual quantity delivered (in sales units) LFIMG QUAN 13
HWAER Local Currency HWAER CUKY 5 TCURC
POSIT Internal commitment item (8 chars) BP_POSIT CHAR 8
ERLPL Update revenue plan ERL_PLANKZ CHAR 1
WRTTP_PLAN Value Type CO_WRTTP CHAR 2
BP_LEDNR Budget/Planning Ledger BP_LEDNR CHAR 4