C_OpenQuotations_F2200

Open Sales Quotations | view: COPENQUOTATIONS | Extraction: Not supported | Component: Sales Analytics
Tables used: VBKD, VEDA, VBAK, KNA1, T000, TVBST
Column Name Description
SalesQuotation Sales Quotation
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
LastChangeDate Last Changed On
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
OverallSDProcessStatusDesc Status Description TEXT20
CriticalityCode null
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
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
  • Client
  • Customer Account Group
  • C_OPENQUOTATIONS_F2200.MANDT == T077D.MANDT
  • C_OPENQUOTATIONS_F2200.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • C_OPENQUOTATIONS_F2200.MANDT == TKUKL.MANDT
  • C_OPENQUOTATIONS_F2200.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_OPENQUOTATIONS_F2200.MANDT == TVKOV.MANDT
  • C_OPENQUOTATIONS_F2200.SALESORGANIZATION == TVKOV.VKORG
  • C_OPENQUOTATIONS_F2200.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • C_OPENQUOTATIONS_F2200.MANDT == TVTA.MANDT
  • C_OPENQUOTATIONS_F2200.SALESORGANIZATION == TVTA.VKORG
  • C_OPENQUOTATIONS_F2200.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_OPENQUOTATIONS_F2200.ORGANIZATIONDIVISION == TVTA.SPART
Sales group
  • Client
  • Sales group
  • Sales office
  • C_OPENQUOTATIONS_F2200.MANDT == TVBVK.MANDT
  • C_OPENQUOTATIONS_F2200.SALESGROUP == TVBVK.VKGRP
  • C_OPENQUOTATIONS_F2200.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • C_OPENQUOTATIONS_F2200.MANDT == TVKO.MANDT
  • C_OPENQUOTATIONS_F2200.SALESORGANIZATION == TVKO.VKORG
Order type in order header
  • Sales Document Type
  • Client
  • C_OPENQUOTATIONS_F2200.SALESQUOTATIONTYPE == TVAK.AUART
  • C_OPENQUOTATIONS_F2200.MANDT == TVAK.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • C_OPENQUOTATIONS_F2200.MANDT == KNA1.MANDT
  • C_OPENQUOTATIONS_F2200.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_OPENQUOTATIONS_F2200.MANDT == TCURC.MANDT
  • C_OPENQUOTATIONS_F2200.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • Sales office
  • C_OPENQUOTATIONS_F2200.MANDT == TVKBZ.MANDT
  • C_OPENQUOTATIONS_F2200.SALESORGANIZATION == TVKBZ.VKORG
  • C_OPENQUOTATIONS_F2200.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_OPENQUOTATIONS_F2200.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_OPENQUOTATIONS_F2200.SALESOFFICE == TVKBZ.VKBUR