COER - Sales Order Value Revenue

Sales Order Value Revenue information is stored in SAP table COER.
It is part of development package KPSD in software component PS-REV-PLN-CAL. This development package consists of objects that can be grouped under "Revenue/payment planning from cust.order and billing plan".

Fields for table COER

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
LEDNR	Ledger for Controlling Objects	X	LEDNR	CHAR	4
OBJNR	Object number	X	J_OBJNR	CHAR	44	ONR00
GJAHR	Fiscal Year	X	GJAHR	NUMC	8
WRTTP	Value Type	X	CO_WRTTP	CHAR	4
KSTAR	Cost Element	X	KSTAR	CHAR	20	CSKA
HRKFT	Origin Group as Subdivision of Cost Element	X	HRKFT	CHAR	8
VRGNG	CO Business Transaction	X	CO_VORGANG	CHAR	8
VBUND	Company ID of Trading Partner	X	RASSC	CHAR	12	T880
TWAER	Transaction Currency	X	TWAER	CUKY	10	TCURC
PERBL	Period Block	X	PERBL	NUMC	6
VERSN	Version	X	VERSN	CHAR	6	TKA09
VBELN	Sales and Distribution Document Number	X	VBELN	CHAR	20
VPOSN	Item number of the SD document	X	POSNR	NUMC	12
KONDZ	Condition type counter (internal)	X	PS_KONDZ	CHAR	20
AENDZ	Change counter for customer order	X	PS_AENDZ	NUMC	8
KSCHL	Condition Type		KSCHA	CHAR	8
STUNR	Step Number		STUNR	NUMC	6
LAENZ	Last change number for customer order		PS_LAENZ	NUMC	8
BEKNZ	Debit/credit indicator		BEKNZ	CHAR	2
VBTYP	SD Document Category		VBTYPL	CHAR	8
FKART	Billing Type		FKART	CHAR	8
FKTYP	Billing Category		FKTYP	CHAR	2
PERIV	Fiscal Year Variant		PERIV	CHAR	4
GSBER	Business Area		GSBER	CHAR	8
VKORG	Sales Organization		VKORG	CHAR	8
VTWEG	Distribution Channel		VTWEG	CHAR	4
KUNAG	Sold-to Party		KUNAG	CHAR	20
BUKRS	Company Code		BUKRS	CHAR	8	T001
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
SPART	Division		SPART	CHAR	4	TSPA
WERKS	Plant		WERKS_D	CHAR	8	T001W
BLART	Document Type		BLART	CHAR	4	T003
BLDAT	Document Date in Document		BLDAT	DATS	16
BUDAT	Posting Date in the Document		BUDAT	DATS	16
WADAT	Goods Issue Date		WADAT	DATS	16
FKDAT	Billing Date		FKDAT	DATS	16
BUDGJ	Posting Date YYYY		BDATJ	NUMC	8
BUDPE	Posting period		POPER	NUMC	6
WADGJ	Posting Date YYYY		BDATJ	NUMC	8
WADPE	Posting period		POPER	NUMC	6
FKDGJ	Posting Date YYYY		BDATJ	NUMC	8
FKDPE	Posting period		POPER	NUMC	6
KUNNR	Customer Number		KUNNR	CHAR	20	KNA1
FILKD	Account Number of the Branch		FILKD	CHAR	20
SGTXT	Segment text		CO_SGTXT	CHAR	100
MATNR	Material Number		MATNR	CHAR	80	MARA
MATKL	Material Group		MATKL	CHAR	18	T023
SKFBT	Amount Eligible for Cash Discount in Document Currency		SKFBT_CS	CURR	7
WKURS	Exchange Rate		WKURS	DEC	5
MEINH	Unit of Measure		CO_MEINH	UNIT	6	T006
MEINB	Posted Unit of Measure		MEINB	UNIT	6	T006
ORGWTH	Planned Value in Local Currency		WERTH1_CS	CURR	8
WHGBTR	Total Value in Local Currency		WHGXXX_CS	CURR	8
ORGWTT	Planned Value in Transaction Currency		WERTT1_CS	CURR	8
WTGBTR	Total Value in Transaction Currency		WTGXXX_CS	CURR	8
ORGWTO	Planned Value in Object Currency		WERTO1_CS	CURR	8
WOGBTR	Total Value in Object Currency		WOGXXX_CS	CURR	8
ORGWTL	Planned Value in Ledger Currency		WERTL1_CS	CURR	8
WLGBTR	Total value in ledger currency		WLGXXX_CS	CURR	8
ORGWTK	Planned Value in Controlling Area Currency		WERTK1_CS	CURR	8
WKGBTR	Total Value in Controlling Area Currency		WKGXXX_CS	CURR	8
MEGBTR	Total Quantity		MEGXXX	QUAN	8
CITYC	City Code		CITYC	CHAR	8	T005G
BONUS	Volume rebate group		BONUS	CHAR	4	TVBO
PROVG	Commission Group		PROVG	CHAR	4	TVPR
VKGRP	Sales group		VKGRP	CHAR	6	TVKGR
VKBUR	Sales office		VKBUR	CHAR	8	TVBUR
FBUDA	Date on which services are rendered		FBUDA	DATS	16
AUBEL	Sales Document		VBELN_VA	CHAR	20
AUPOS	Sales Document Item		POSNR_VA	NUMC	12
PRCTR	Profit Center		PRCTR	CHAR	20
FKIMG	Actual billed quantity		FKIMG	QUAN	7
VRKME	Sales unit		VRKME	UNIT	6	T006
FKLMG	Billing quantity in stock keeping unit		FKLMG	QUAN	7
MEINS	Base Unit of Measure		MEINS	UNIT	6	T006
KAPPL	Application		KAPPL	CHAR	4	T681A
KALSM	Procedure (Pricing, Output Control, Acct. Det., Costing,...)		KALSM_D	CHAR	12	T683
KNTYP	Condition Category (Examples: Tax, Freight, Price, Cost)		KNTYP	CHAR	2
ANGDT	Quotation/Inquiry is Valid From		ANGDT_V	DATS	16
BNDDT	Date Until Which Bid/Quotation is Binding (Valid-To Date)		BNDDT	DATS	16
KBVER	Allowed deviation in quantity (in percent)		KBVER	DEC	2
KEVER	Days by which the quantity can be shifted		KEVER	DEC	2
AWAHR	Order Probability of the Item		AWAHR	NUMC	6
PRSDT	Date for Pricing and Exchange Rate		PRSDT	DATS	16
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
LFIMG	Actual quantity delivered (in sales units)		LFIMG	QUAN	7
HWAER	Local Currency		HWAER	CUKY	10	TCURC
POSIT	Internal commitment item (8 chars)		BP_POSIT	CHAR	16
ERLPL	Update revenue plan		ERL_PLANKZ	CHAR	2
WRTTP_PLAN	Value Type		CO_WRTTP	CHAR	4
BP_LEDNR	Budget/Planning Ledger		BP_LEDNR	CHAR	8