C_OpenSalesOrders_F2200

open sales orders | view: COPENSALESODR | Extraction: Not supported | Component: Sales Analytics
Tables used: VBKD, VEDA, VBAK, KNA1, TVBST
Column Name Description
SalesOrder Sales Order
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
OverallSDProcessStatusDesc Status Description TEXT20
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CriticalityCode null
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
Master Data Relations Join Conditions
Customer Account Group
  • Customer Account Group
  • Client
  • C_OPENSALESORDERS_F2200.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_OPENSALESORDERS_F2200.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • C_OPENSALESORDERS_F2200.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_OPENSALESORDERS_F2200.MANDT == TKUKL.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • C_OPENSALESORDERS_F2200.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_OPENSALESORDERS_F2200.SALESORGANIZATION == TVKOV.VKORG
  • C_OPENSALESORDERS_F2200.MANDT == TVKOV.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Sales Organization
  • Client
  • C_OPENSALESORDERS_F2200.ORGANIZATIONDIVISION == TVTA.SPART
  • C_OPENSALESORDERS_F2200.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_OPENSALESORDERS_F2200.SALESORGANIZATION == TVTA.VKORG
  • C_OPENSALESORDERS_F2200.MANDT == TVTA.MANDT
Sales group
  • Sales group
  • Sales office
  • Client
  • C_OPENSALESORDERS_F2200.SALESGROUP == TVBVK.VKGRP
  • C_OPENSALESORDERS_F2200.SALESOFFICE == TVBVK.VKBUR
  • C_OPENSALESORDERS_F2200.MANDT == TVBVK.MANDT
Order type in order header
  • Sales Order Type
  • Client
  • C_OPENSALESORDERS_F2200.SALESORDERTYPE == TVAK.AUART
  • C_OPENSALESORDERS_F2200.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_OPENSALESORDERS_F2200.SALESORGANIZATION == TVKO.VKORG
  • C_OPENSALESORDERS_F2200.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_OPENSALESORDERS_F2200.SOLDTOPARTY == KNA1.KUNNR
  • C_OPENSALESORDERS_F2200.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • C_OPENSALESORDERS_F2200.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_OPENSALESORDERS_F2200.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Distribution Channel
  • Sales office
  • Sales Organization
  • Client
  • C_OPENSALESORDERS_F2200.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_OPENSALESORDERS_F2200.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_OPENSALESORDERS_F2200.SALESOFFICE == TVKBZ.VKBUR
  • C_OPENSALESORDERS_F2200.SALESORGANIZATION == TVKBZ.VKORG
  • C_OPENSALESORDERS_F2200.MANDT == TVKBZ.MANDT