C_SalesQuotationByOpenStatus

Open Sales Quotations | view: CSLSQUOTOPNSTS | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBKD, VEDA, VBAK, KNA1, T006, T006A
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)
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
CustomerName Name of Customer TEXT80
SlsQtanConversionRateInPct Sales Quotation Conversion Rate PRZ52
SlsQtanDueDateCriticality null
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == TVKOV.MANDT
  • C_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESQUOTATIONBYOPENSTATUS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == TVTA.MANDT
  • C_SALESQUOTATIONBYOPENSTATUS.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVTA.VKORG
  • C_SALESQUOTATIONBYOPENSTATUS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Sales office
  • Client
  • Sales group
  • C_SALESQUOTATIONBYOPENSTATUS.SALESOFFICE == TVBVK.VKBUR
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == TVBVK.MANDT
  • C_SALESQUOTATIONBYOPENSTATUS.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == TVKO.MANDT
  • C_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVKO.VKORG
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESQUOTATIONBYOPENSTATUS.SALESQUOTATIONTYPE == TVAK.AUART
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == TVAK.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESQUOTATIONBYOPENSTATUS.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • C_SALESQUOTATIONBYOPENSTATUS.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_SALESQUOTATIONBYOPENSTATUS.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESQUOTATIONBYOPENSTATUS.MANDT == TVKBZ.MANDT
  • C_SALESQUOTATIONBYOPENSTATUS.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESQUOTATIONBYOPENSTATUS.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG