SAP ABAP Table COER (Sales Order Value Revenue)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-REV-PLN-CAL (Application Component) Costing
     ⤷ KPSD (Package) Revenue/payment planning from cust.order and billing plan

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	COER	Table Relationship Diagram
Short Description	Sales Order Value Revenue

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LEDNR	☑	LEDNR	LEDNR	CHAR	2	0	Ledger for Controlling objects
3	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
4	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	WRTTP	☑	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
6	KSTAR	☑	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
7	HRKFT	☑	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
8	VRGNG	☑	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	*
9	VBUND	☑	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
10	TWAER	☑	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
11	PERBL	☑	PERBL	PERBL	NUMC	3	0	Period block
12	VERSN	☑	VERSN	COVERSI	CHAR	3	0	Version	TKA09
13	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
14	VPOSN	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
15	KONDZ	☑	PS_KONDZ	CHAR10	CHAR	10	0	Condition type counter (internal)
16	AENDZ	☑	PS_AENDZ	NUM4	NUMC	4	0	Change counter for customer order
17	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
18	STUNR	☐	STUNR	STUNR	NUMC	3	0	Level Number	*
19	ZAEHK	☐	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
20	LAENZ	☐	PS_LAENZ	NUM4	NUMC	4	0	Last change number for customer order
21	BEKNZ	☐	BEKNZ	BEKNZ	CHAR	1	0	Debit/credit indicator
22	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
23	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
24	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
25	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
26	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
27	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
28	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
29	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
30	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
31	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
32	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
33	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
34	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
35	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
36	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
37	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
38	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
39	BUDGJ	☐	BDATJ	GJAHR	NUMC	4	0	Posting Date YYYY
40	BUDPE	☐	POPER	POPER	NUMC	3	0	Posting period
41	WADGJ	☐	BDATJ	GJAHR	NUMC	4	0	Posting Date YYYY
42	WADPE	☐	POPER	POPER	NUMC	3	0	Posting period
43	FKDGJ	☐	BDATJ	GJAHR	NUMC	4	0	Posting Date YYYY
44	FKDPE	☐	POPER	POPER	NUMC	3	0	Posting period
45	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
46	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
47	SGTXT	☐	CO_SGTXT	TEXT50	CHAR	50	0	Segment text
48	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
49	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
50	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
51	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
52	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
53	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
54	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
55	MEINB	☐	MEINB	MEINS	UNIT	3	0	Posted Unit of Measure	T006
56	ORGWTH	☐	WERTH1	WERTV8	CURR	15	2	Planned value in local currency
57	WHGBTR	☐	WHGXXX	WERTV8	CURR	15	2	Total value in local currency
58	ORGWTT	☐	WERTT1	WERTV8	CURR	15	2	Planned value in transaction currency
59	WTGBTR	☐	WTGXXX	WERTV8	CURR	15	2	Total Value in Transaction Currency
60	ORGWTO	☐	WERTO1	WERTV8	CURR	15	2	Planned value in object currency
61	WOGBTR	☐	WOGXXX	WERTV8	CURR	15	2	Total Value in Object Currency
62	ORGWTL	☐	WERTL1	WERTV8	CURR	15	2	Planned value in ledger currency
63	WLGBTR	☐	WLGXXX	WERTV8	CURR	15	2	Total value in ledger currency
64	ORGWTK	☐	WERTK1	WERTV8	CURR	15	2	Planned value in controlling area currency
65	WKGBTR	☐	WKGXXX	WERTV8	CURR	15	2	Total Value in Controlling Area Currency
66	MEGBTR	☐	MEGXXX	MENGV8	QUAN	15	3	Total Quantity
67	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
68	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
69	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
70	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
71	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
72	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
73	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
74	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
75	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
76	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
77	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
78	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
79	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
80	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
81	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
82	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
83	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
84	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
85	KBVER	☐	KBVER	PACK2	DEC	3	0	Allowed deviation in quantity (in percent)
86	KEVER	☐	KEVER	PACK2	DEC	3	0	Days by which the quantity can be shifted
87	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
88	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
89	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
90	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
91	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
92	POSIT	☐	BP_POSIT	BP_POSIT	CHAR	8	0	Internal commitment item (8 chars)
93	ERLPL	☐	ERL_PLANKZ	FLAG	CHAR	1	0	Update revenue plan
94	WRTTP_PLAN	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
95	BP_LEDNR	☐	BP_LEDNR	LEDNR_BP	CHAR	4	0	Budget/Planning Ledger

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COER	AUBEL	VBUK	VBELN	REF	C	CN
2	COER	AUPOS	VBUP	POSNR	REF	C	CN
3	COER	BLART	T003	BLART	KEY	1	CN
4	COER	BONUS	TVBO	BONUS	REF	C	CN
5	COER	BUKRS	T001	BUKRS	KEY	1	CN
6	COER	CITYC	T005G	CITYC	REF	C	CN
7	COER	HWAER	TCURC	WAERS	REF	C	CN
8	COER	KALSM	T683	KALSM	REF	C	CN
9	COER	KAPPL	T681A	KAPPL	REF	C	CN
10	COER	KOKRS	TKA01	KOKRS	REF	C	CN
11	COER	KSTAR	CSKA	KSTAR	KEY	1	CN
12	COER	KUNNR	KNA1	KUNNR	KEY	1	CN
13	COER	MANDT	T000	MANDT	KEY	1	CN
14	COER	MATKL	T023	MATKL	REF	1	CN
15	COER	MATNR	MARA	MATNR	REF	C	CN
16	COER	MEINB	T006	MSEHI	KEY	1	CN
17	COER	MEINH	T006	MSEHI	KEY	1	CN
18	COER	MEINS	T006	MSEHI	REF	C	CN
19	COER	OBJNR	ONR00	OBJNR	KEY	1	CN
20	COER	PROVG	TVPR	PROVG	REF	C	CN
21	COER	SPART	TSPA	SPART	REF	C	CN
22	COER	TWAER	TCURC	WAERS	KEY	1	CN
23	COER	VBELN	VBUK	VBELN	KEY	1	CN
24	COER	VBUND	T880	RCOMP	KEY	1	CN
25	COER	VERSN	TKA09	VERSN	KEY	1	CN
26	COER	VKBUR	TVBUR	VKBUR	REF	C	CN
27	COER	VKGRP	TVKGR	VKGRP	REF	C	CN
28	COER	VPOSN	VBUP	POSNR	KEY	1	CN
29	COER	VRKME	T006	MSEHI	REF	C	CN
30	COER	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in