COER

Sales Order Value Revenue | #transactional | Component: Costing
Column Name Description
MANDT FK Client
LEDNR Ledger for Controlling Objects Show values
OBJNR FK Object number
GJAHR Fiscal Year
WRTTP Value Type Show values
KSTAR FK Cost Element
HRKFT Origin Group as Subdivision of Cost Element
VRGNG CO Business Transaction
VBUND FK Company ID of Trading Partner
TWAER FK Transaction Currency
PERBL Period Block
VERSN FK Version
VBELN Sales and Distribution Document Number
VPOSN Item number of the SD document
KONDZ Condition type counter (internal)
AENDZ Change counter for customer order
Column Name Description
💲 Currency Key (BKPF.WAERS):
SKFBT Amount Eligible for Cash Discount in Document Currency
ORGWTH Planned Value in Local Currency
WHGBTR Total Value in Local Currency
ORGWTL Planned Value in Ledger Currency
WLGBTR Total value in ledger currency
ORGWTK Planned Value in Controlling Area Currency
WKGBTR Total Value in Controlling Area Currency
💲 Transaction Currency (TWAER):
ORGWTT Planned Value in Transaction Currency
WTGBTR Total Value in Transaction Currency
ORGWTO Planned Value in Object Currency
WOGBTR Total Value in Object Currency
Column Name Description
📏 Unit of Measure (COEP.MEINH):
MEGBTR Total Quantity
📏 Sales unit (VRKME):
FKIMG Actual billed quantity
FKLMG Billing quantity in stock keeping unit
📏 Posted Unit of Measure (MEINB):
LFIMG Actual quantity delivered (in sales units)
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
WADAT Goods Issue Date
FKDAT Billing Date
ZFBDT Baseline Date for Due Date Calculation
FBUDA Date on which services are rendered
ANGDT Quotation/Inquiry is Valid From
BNDDT Date Until Which Bid/Quotation is Binding (Valid-To Date)
PRSDT Date for Pricing and Exchange Rate
Column Name Description
LEDNR Ledger for Controlling Objects Show values
WRTTP Value Type Show values
BEKNZ Debit/credit indicator Show values
VBTYP SD Document Category Show values
FKTYP Billing Category Show values
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) Show values
AWAHR Order Probability of the Item Show values
SHKZG Debit/Credit Indicator Show values
ERLPL Update revenue plan Show values
WRTTP_PLAN Value Type Show values
Column Name Description Domain name
KSCHL Condition Type KSCHL
STUNR Step Number STUNR
ZAEHK Condition Counter ZAEHK
LAENZ Last change number for customer order NUM4
FKART Billing Type FKART
PERIV Fiscal Year Variant PERIV
GSBER Business Area GSBER
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
KUNAG Sold-to Party KUNNR
BUDGJ Posting Date YYYY GJAHR
BUDPE Posting period POPER
WADGJ Posting Date YYYY GJAHR
WADPE Posting period POPER
FKDGJ Posting Date YYYY GJAHR
FKDPE Posting period POPER
FILKD Account Number of the Branch MAXKK
SGTXT Segment text TEXT50
ZTERM Terms of payment key ZTERM
WKURS Exchange Rate KURSP
AUBEL Sales Document VBELN
AUPOS Sales Document Item POSNR
PRCTR Profit Center PRCTR
KBVER Allowed deviation in quantity (in percent) PACK2
KEVER Days by which the quantity can be shifted PACK2
POSIT Internal commitment item (8 chars) BP_POSIT
BP_LEDNR Budget/Planning Ledger LEDNR_BP
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • COER.BLART == T003.BLART
  • COER.MANDT == T003.MANDT
Volume rebate group
  • Volume rebate group
  • Client
  • COER.BONUS == TVBO.BONUS
  • COER.MANDT == TVBO.MANDT
Company Code
  • COER.MANDT == T001.MANDT
  • COER.BUKRS == T001.BUKRS
City Code
  • ?
  • City Code
  • Client
  • ?
  • COER.[column in domain "REGIO"] == T005G.REGIO
  • COER.CITYC == T005G.CITYC
  • COER.MANDT == T005G.MANDT
  • COER.[column in domain "LAND1"] == T005G.LAND1
Local Currency
  • COER.MANDT == TCURC.MANDT
  • COER.HWAER == TCURC.WAERS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Application
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • COER.MANDT == T683.MANDT
  • COER.KAPPL == T683.KAPPL
  • COER.KALSM == T683.KALSM
  • COER.[column in domain "KVEWE"] == T683.KVEWE
Application COER.KAPPL == T681A.KAPPL
Controlling Area
  • COER.MANDT == TKA01.MANDT
  • COER.KOKRS == TKA01.KOKRS
Cost Element
  • ?
  • Cost Element
  • COER.MANDT == CSKA.MANDT
  • COER.[column in domain "KTOPL"] == CSKA.KTOPL
  • COER.KSTAR == CSKA.KSTAR
Customer Number
  • COER.MANDT == KNA1.MANDT
  • COER.KUNNR == KNA1.KUNNR
Client COER.MANDT == T000.MANDT
Material class
  • COER.MANDT == T023.MANDT
  • COER.MATKL == T023.MATKL
Material
  • Material Number
  • Client
  • COER.MATNR == MARA.MATNR
  • COER.MANDT == MARA.MANDT
Posted Unit of Measure
  • COER.MANDT == T006.MANDT
  • COER.MEINB == T006.MSEHI
Unit of Measure
  • COER.MANDT == T006.MANDT
  • COER.MEINH == T006.MSEHI
Base Unit of Measure
  • COER.MANDT == T006.MANDT
  • COER.MEINS == T006.MSEHI
Commission Group
  • Commission Group
  • Client
  • COER.PROVG == TVPR.PROVG
  • COER.MANDT == TVPR.MANDT
Division
  • COER.MANDT == TSPA.MANDT
  • COER.SPART == TSPA.SPART
Transaction Currency
  • COER.MANDT == TCURC.MANDT
  • COER.TWAER == TCURC.WAERS
Company ID of Trading Partner
  • COER.MANDT == T880.MANDT
  • COER.VBUND == T880.RCOMP
Version
  • Version
  • Client
  • Controlling Area
  • COER.VERSN == TKA09.VERSN
  • COER.MANDT == TKA09.MANDT
  • COER.KOKRS == TKA09.KOKRS
Sales office
  • Sales office
  • Client
  • COER.VKBUR == TVBUR.VKBUR
  • COER.MANDT == TVBUR.MANDT
Sales group
  • COER.MANDT == TVKGR.MANDT
  • COER.VKGRP == TVKGR.VKGRP
Sales unit
  • COER.MANDT == T006.MANDT
  • COER.VRKME == T006.MSEHI
Plant
  • COER.MANDT == T001W.MANDT
  • COER.WERKS == T001W.WERKS