COER SAP table for – Sales Order Value Revenue

Here we would like to draw your attention to COER table in SAP. As we know it is being mainly used with the SAP PS-REV (Revenues and Earnings in PS) component which is coming under PS module (Project Systems). COER is a SAP standard transparent table used for storing Sales Order Value Revenue related data in SAP. It comes under the package KPSD.

SAP COER table

Table COER technical data

TableCOER
Data storingSales Order Value Revenue
ModulePS
ComponentPS-REV
SAP PackageKPSD
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP COER Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in COER table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • TWAER : Transaction Currency
    Its a key field. Its data type is C (Character String) with field length 5
  • PERBL
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • VERSN : Version
    Its a key field. Its data type is C (Character String) with field length 3
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • VPOSN
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • KONDZ
    Its a key field. Its data type is C (Character String) with field length 10
  • AENDZ
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • KSCHL : Condition Type
    Its data type is C (Character String) with field length 4
  • STUNR
    Its data type is N (Character String with Digits Only) with field length 3
  • ZAEHK
    Its data type is N (Character String with Digits Only) with field length 2
  • LEDNR
    Its a key field. Its data type is C (Character String) with field length 2
  • LAENZ
    Its data type is N (Character String with Digits Only) with field length 4
  • BEKNZ
    Its data type is C (Character String) with field length 1
  • VBTYP
    Its data type is C (Character String) with field length 1
  • FKART : Billing Type
    Its data type is C (Character String) with field length 4
  • FKTYP
    Its data type is C (Character String) with field length 1
  • PERIV
    Its data type is C (Character String) with field length 2
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • KUNAG : Sold-to party
    Its data type is C (Character String) with field length 10
  • OBJNR : Object number
    Its a key field. Its data type is C (Character String) with field length 22
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • BLART : Document type
    Its data type is C (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FKDAT : Billing date for billing index and printout
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BUDGJ
    Its data type is N (Character String with Digits Only) with field length 4
  • GJAHR : Fiscal Year
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • BUDPE
    Its data type is N (Character String with Digits Only) with field length 3
  • WADGJ
    Its data type is N (Character String with Digits Only) with field length 4
  • WADPE
    Its data type is N (Character String with Digits Only) with field length 3
  • FKDGJ
    Its data type is N (Character String with Digits Only) with field length 4
  • FKDPE
    Its data type is N (Character String with Digits Only) with field length 3
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • FILKD
    Its data type is C (Character String) with field length 10
  • SGTXT : Item Text
    Its data type is C (Character String) with field length 50
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • WRTTP : Value Type
    Its a key field. Its data type is C (Character String) with field length 2
  • ZTERM
    Its data type is C (Character String) with field length 4
  • ZFBDT : Baseline date for due date calculation
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SKFBT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WKURS : Exchange Rate
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • MEINH : Unit of Measure
    Its data type is C (Character String) with field length 3
  • MEINB
    Its data type is C (Character String) with field length 3
  • ORGWTH
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WHGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ORGWTT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WTGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KSTAR : Cost Element
    Its a key field. Its data type is C (Character String) with field length 10
  • ORGWTO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WOGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ORGWTL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WLGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ORGWTK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WKGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MEGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CITYC : City Code
    Its data type is C (Character String) with field length 4
  • BONUS
    Its data type is C (Character String) with field length 2
  • PROVG : Key for defining time intervals in a relationship
    Its data type is C (Character String) with field length 2
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its a key field. Its data type is C (Character String) with field length 4
  • VKGRP : Sales group
    Its data type is C (Character String) with field length 3
  • VKBUR : Sales office
    Its data type is C (Character String) with field length 4
  • FBUDA
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AUBEL : Sales Document
    Its data type is C (Character String) with field length 10
  • AUPOS : Sales Document Item
    Its data type is N (Character String with Digits Only) with field length 6
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • FKIMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • FKLMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • VRGNG
    Its a key field. Its data type is C (Character String) with field length 4
  • KAPPL : Application
    Its data type is C (Character String) with field length 2
  • KALSM : Costing Sheet
    Its data type is C (Character String) with field length 6
  • KNTYP
    Its data type is C (Character String) with field length 1
  • ANGDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BNDDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KBVER
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • KEVER
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • AWAHR
    Its data type is N (Character String with Digits Only) with field length 3
  • PRSDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • VBUND : Company ID of trading partner
    Its a key field. Its data type is C (Character String) with field length 6
  • LFIMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • HWAER : Local Currency
    Its data type is C (Character String) with field length 5
  • POSIT : Item
    Its data type is C (Character String) with field length 8
  • ERLPL
    Its data type is C (Character String) with field length 1
  • WRTTP_PLAN
    Its data type is C (Character String) with field length 2
  • BP_LEDNR
    Its data type is C (Character String) with field length 4
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.