I_SalesQuotationPipeline_F2200

Sales Quotation Pipeline | view: ISQP_F2200 | TRAN | Extraction: Not supported | Component: Sales Analytics
Tables used: VBKD, VEDA, VBAK, KNA1, T000, TVBST
Column Name Description
SalesQuotation Sales Quotation
Column Name Description
Column Name Description
Column Name Description
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
CurrentDate null
TomorrowDate null
SalesQuotationDate null
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
StatusDescription Status Description TEXT20
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
NumberOfExpiredSlsQuotations null
NmbrOfInWeekExpiringSlsQtans null
NmbrOfAfterWeekExprgSlsQtans null
NmbrOfUndefinedExprgSlsQtans null
TextOutputID null
CriticalityCode null
Master Data Relations Join Conditions
Customer Account Group
  • Customer Account Group
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == T077D.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.SALESORGANIZATION == TVKOV.VKORG
  • I_SALESQUOTATIONPIPELINE_F2200.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == TVKOV.MANDT
Division in order header
  • Sales Organization
  • Division
  • Distribution Channel
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.SALESORGANIZATION == TVTA.VKORG
  • I_SALESQUOTATIONPIPELINE_F2200.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESQUOTATIONPIPELINE_F2200.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == TVTA.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.SALESOFFICE == TVBVK.VKBUR
  • I_SALESQUOTATIONPIPELINE_F2200.SALESGROUP == TVBVK.VKGRP
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.SALESORGANIZATION == TVKO.VKORG
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == TVKO.MANDT
Order type in order header
  • Sales document type (not converted)
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.SALESQUOTATIONTYPE == TVAK.AUART
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == TVAK.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Sales office
  • Division
  • Distribution Channel
  • Client
  • I_SALESQUOTATIONPIPELINE_F2200.SALESORGANIZATION == TVKBZ.VKORG
  • I_SALESQUOTATIONPIPELINE_F2200.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESQUOTATIONPIPELINE_F2200.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SALESQUOTATIONPIPELINE_F2200.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESQUOTATIONPIPELINE_F2200.MANDT == TVKBZ.MANDT