P_SalesQuotationByOpenStatus

Open Sales Quotations Due Days Calc | view: PSLSQUOTOPNSTS | Extraction: Not supported | Component: Sales
Tables used: VBKD, VEDA, VBAK
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
DueDays null
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • P_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVKOV.VKORG
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == TVKOV.MANDT
  • P_SALESQUOTATIONBYOPENSTATUS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Sales Organization
  • Division
  • Client
  • Distribution Channel
  • P_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVTA.VKORG
  • P_SALESQUOTATIONBYOPENSTATUS.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == TVTA.MANDT
  • P_SALESQUOTATIONBYOPENSTATUS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Sales office
  • Sales group
  • Client
  • P_SALESQUOTATIONBYOPENSTATUS.SALESOFFICE == TVBVK.VKBUR
  • P_SALESQUOTATIONBYOPENSTATUS.SALESGROUP == TVBVK.VKGRP
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • P_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVKO.VKORG
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == TVKO.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • P_SALESQUOTATIONBYOPENSTATUS.SALESQUOTATIONTYPE == TVAK.AUART
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == TVAK.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • P_SALESQUOTATIONBYOPENSTATUS.SOLDTOPARTY == KNA1.KUNNR
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • P_SALESQUOTATIONBYOPENSTATUS.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales Organization
  • Division
  • Client
  • Distribution Channel
  • P_SALESQUOTATIONBYOPENSTATUS.SALESOFFICE == TVKBZ.VKBUR
  • P_SALESQUOTATIONBYOPENSTATUS.SALESORGANIZATION == TVKBZ.VKORG
  • P_SALESQUOTATIONBYOPENSTATUS.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SALESQUOTATIONBYOPENSTATUS.MANDT == TVKBZ.MANDT
  • P_SALESQUOTATIONBYOPENSTATUS.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG