I_SalesQuotationSituation

Sales Quotation Situation | view: ISDSLESQTANST | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBPA, VBPA, CVI_CUST_CT_LINK, BUT0ID, BUT000, USR21, CVI_CUST_LINK, CVI_VEND_LINK, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL
Column Name Description
SalesQuotation Sales Quotation
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
CnvrtdSalesQuotationNetAmount Converted Sales Quotation Net Amount
Column Name Description
Column Name Description
CreationDate Date on which the record was created
SalesQuotationDate Document Date (Date Received/Sent)
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
TodayDate null
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
Column Name Description Domain name
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SlsQtanConversionRateInPct Quotation Conversion Rate in percentage
PrdtvSlsQtanCnvrsnRateInPct Predicted Quotation Conversion Rate in Percent
SlsQtanPeriodDueDays Days Before Expiry of Quotation INT4
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_SALESQUOTATIONSITUATION.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_SALESQUOTATIONSITUATION.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_SALESQUOTATIONSITUATION.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_SALESQUOTATIONSITUATION.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • I_SALESQUOTATIONSITUATION.MANDT == TVV3.MANDT
  • I_SALESQUOTATIONSITUATION.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • I_SALESQUOTATIONSITUATION.MANDT == TVV4.MANDT
  • I_SALESQUOTATIONSITUATION.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • I_SALESQUOTATIONSITUATION.MANDT == TVV5.MANDT
  • I_SALESQUOTATIONSITUATION.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Customer Group
  • Client
  • Customer Group
  • I_SALESQUOTATIONSITUATION.MANDT == T151.MANDT
  • I_SALESQUOTATIONSITUATION.CUSTOMERGROUP == T151.KDGRP
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • I_SALESQUOTATIONSITUATION.MANDT == TVKOV.MANDT
  • I_SALESQUOTATIONSITUATION.SALESORGANIZATION == TVKOV.VKORG
  • I_SALESQUOTATIONSITUATION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • I_SALESQUOTATIONSITUATION.MANDT == TVTA.MANDT
  • I_SALESQUOTATIONSITUATION.SALESORGANIZATION == TVTA.VKORG
  • I_SALESQUOTATIONSITUATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESQUOTATIONSITUATION.DIVISION == TVTA.SPART
Address key assignment to users
  • Client
  • Sales Employee User ID
  • Sales Employee User ID
  • I_SALESQUOTATIONSITUATION.MANDT == USR02.MANDT
  • I_SALESQUOTATIONSITUATION.SALESEMPLOYEEUSERID == USR02.BNAME
  • I_SALESQUOTATIONSITUATION.RESPONSIBLEEMPLOYEEUSERID == USR02.BNAME
Order type in order header
  • Sales Document Type
  • Client
  • I_SALESQUOTATIONSITUATION.SALESDOCUMENTTYPE == TVAK.AUART
  • I_SALESQUOTATIONSITUATION.MANDT == TVAK.MANDT
Address key assignment to users
  • Client
  • Sales Employee User ID
  • Sales Employee User ID
  • I_SALESQUOTATIONSITUATION.MANDT == USR02.MANDT
  • I_SALESQUOTATIONSITUATION.SALESEMPLOYEEUSERID == USR02.BNAME
  • I_SALESQUOTATIONSITUATION.RESPONSIBLEEMPLOYEEUSERID == USR02.BNAME
Sales group
  • Client
  • Sales group
  • Sales office
  • I_SALESQUOTATIONSITUATION.MANDT == TVBVK.MANDT
  • I_SALESQUOTATIONSITUATION.SALESGROUP == TVBVK.VKGRP
  • I_SALESQUOTATIONSITUATION.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESQUOTATIONSITUATION.MANDT == TVKO.MANDT
  • I_SALESQUOTATIONSITUATION.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_SALESQUOTATIONSITUATION.MANDT == KNA1.MANDT
  • I_SALESQUOTATIONSITUATION.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • I_SALESQUOTATIONSITUATION.MANDT == TCURC.MANDT
  • I_SALESQUOTATIONSITUATION.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales Organization
  • Distribution Channel
  • Sales office
  • Division
  • I_SALESQUOTATIONSITUATION.MANDT == TVKBZ.MANDT
  • I_SALESQUOTATIONSITUATION.SALESORGANIZATION == TVKBZ.VKORG
  • I_SALESQUOTATIONSITUATION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESQUOTATIONSITUATION.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESQUOTATIONSITUATION.DIVISION == TVKBZ.SPART