COER SAP (Sales Order Value Revenue) Table details
Dictionary Type: Table
Description: Sales Order Value Revenue
Description: Sales Order Value Revenue
Table field list including key, data, relationships and ABAP select examples
COER is a standard SAP Table which is used to store Sales Order Value Revenue data and is available within R/3 SAP systems depending on the version and release level.
The COER table consists of various fields, each holding specific information or linking keys about Sales Order Value Revenue data available in SAP. These include LEDNR (Ledger for Controlling objects), OBJNR (Object number), GJAHR (Fiscal Year), WRTTP (Value Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP COER table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| LEDNR | Ledger for Controlling objects | LEDNR | CHAR | 2 | ALPHA | LEDNR | |||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| WRTTP | Value Type | CO_WRTTP | CHAR | 2 | CO_WRTTP | ||||
| KSTAR | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
| HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | Assigned to domain | HRKFT | |||
| VRGNG | CO Business Transaction | CO_VORGANG | CHAR | 4 | Assigned to domain | J_VORGANG | |||
| VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
| TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
| PERBL | Period block | PERBL | NUMC | 3 | PERBL | VPE | |||
| VERSN | Version | VERSN | CHAR | 3 | TKA09 | ALPHA | COVERSI | KVS | |
| VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
| VPOSN | Item number of the SD document | POSNR | NUMC | 6 | VBUP | POSNR | |||
| KONDZ | Condition type counter (internal) | PS_KONDZ | CHAR | 10 | CHAR10 | ||||
| AENDZ | Change counter for customer order | PS_AENDZ | NUMC | 4 | NUM4 | ||||
| KSCHL | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
| STUNR | Step number | STUNR | NUMC | 3 | Assigned to domain | STUNR | |||
| ZAEHK | Condition counter | DZAEHK | NUMC | 2 | ZAEHK | ||||
| LAENZ | Last change number for customer order | PS_LAENZ | NUMC | 4 | NUM4 | ||||
| BEKNZ | Debit/credit indicator | BEKNZ | CHAR | 1 | BEKNZ | BEKNZ | |||
| VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
| FKART | Billing Type | FKART | CHAR | 4 | Assigned to domain | FKART | |||
| FKTYP | Billing category | FKTYP | CHAR | 1 | FKTYP | ||||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
| KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
| SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| WADAT | Goods Issue Date | WADAT | DATS | 8 | DATUM | ||||
| FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
| BUDGJ | Posting Date YYYY | BDATJ | NUMC | 4 | GJAHR | GJAHR | BDTJ | ||
| BUDPE | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
| WADGJ | Posting Date YYYY | BDATJ | NUMC | 4 | GJAHR | GJAHR | BDTJ | ||
| WADPE | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
| FKDGJ | Posting Date YYYY | BDATJ | NUMC | 4 | GJAHR | GJAHR | BDTJ | ||
| FKDPE | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
| KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
| FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
| SGTXT | Segment text | CO_SGTXT | CHAR | 50 | TEXT50 | ||||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
| SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
| WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
| MEINH | Unit of Measure | CO_MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| MEINB | Posted Unit of Measure | MEINB | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ORGWTH | Planned value in local currency | WERTH1 | CURR | 15(2) | WERTV8 | ||||
| WHGBTR | Total value in local currency | WHGXXX | CURR | 15(2) | WERTV8 | ||||
| ORGWTT | Planned value in transaction currency | WERTT1 | CURR | 15(2) | WERTV8 | ||||
| WTGBTR | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
| ORGWTO | Planned value in object currency | WERTO1 | CURR | 15(2) | WERTV8 | ||||
| WOGBTR | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
| ORGWTL | Planned value in ledger currency | WERTL1 | CURR | 15(2) | WERTV8 | ||||
| WLGBTR | Total value in ledger currency | WLGXXX | CURR | 15(2) | WERTV8 | ||||
| ORGWTK | Planned value in controlling area currency | WERTK1 | CURR | 15(2) | WERTV8 | ||||
| WKGBTR | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
| MEGBTR | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
| CITYC | City Code | CITYC | CHAR | 4 | T005G | CITYC | |||
| BONUS | Volume rebate group | BONUS | CHAR | 2 | TVBO | BONUS | |||
| PROVG | Commission group | PROVG | CHAR | 2 | TVPR | PROVG | |||
| VKGRP | Sales Group | VKGRP | CHAR | 3 | TVKGR | VKGRP | VKG | ||
| VKBUR | Sales Office | VKBUR | CHAR | 4 | TVBUR | VKBUR | VKB | ||
| FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
| AUBEL | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
| AUPOS | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
| VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| FKLMG | Billing quantity in stockkeeping unit | FKLMG | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | KALSM | |||
| KNTYP | Condition category (examples: tax, freight, price, cost) | KNTYP | CHAR | 1 | KNTYP | ||||
| ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | DATUM | ||||
| BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
| KBVER | Allowed deviation in quantity (in percent) | KBVER | DEC | 3 | PACK2 | ||||
| KEVER | Days by which the quantity can be shifted | KEVER | DEC | 3 | PACK2 | ||||
| AWAHR | Order probability of the item | AWAHR | NUMC | 3 | AWAHR | ||||
| PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
| LFIMG | Actual quantity delivered (in sales units) | LFIMG | QUAN | 13(3) | MENG13 | ||||
| HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
| POSIT | Internal commitment item (8 chars) | BP_POSIT | CHAR | 8 | BP_POSIT | ||||
| ERLPL | Update revenue plan | ERL_PLANKZ | CHAR | 1 | FLAG | ||||
| WRTTP_PLAN | Value Type | CO_WRTTP | CHAR | 2 | CO_WRTTP | ||||
| BP_LEDNR | Budget/Planning Ledger | BP_LEDNR | CHAR | 4 | NUMCV | LEDNR_BP |
| Key field | Non-key field |
How do I retrieve data from SAP table COER using ABAP code
The following ABAP code Example will allow you to do a basic selection on COER to SELECT all data from the tableDATA: WA_COER TYPE COER.
SELECT SINGLE *
FROM COER
INTO CORRESPONDING FIELDS OF WA_COER
WHERE...
How to access SAP table COER
Within an ECC or HANA version of SAP you can also view further information about COER and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects