P_SlsQtanPrdtvTrngBscData

Sales Quotation Predictive Training Basic Data | view: PSDSLSQPTBD | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP
Column Name Description
SalesQuotation FK Sales Quotation
SalesQuotationItem Sales Quotation Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OutlineAgreementTargetAmount Target Value for Outline Agreement in Document Currency
NetAmount Net Value of Sales Order Item in Transaction Currency
NetPriceAmount Net Price
TaxAmount Tax Amount in Document Currency
CostAmount Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
SalesQuotationNetAmount Net Value of the Order Item in Document Currency
CnvrtdSalesQuotationNetAmount Converted Sales Quotation Net Amount
Column Name Description
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
📏 Base Unit of Measure (BaseUnit):
SalesQuotationQuantity Quantity of Sales Quotation Items
CnvrtdSalesQuotationQuantity Converted Sales Quotation Quantity
Column Name Description
ItemCreationDate Date on which the record was created
ItemCreationTime Time at Which Record Was Created
ItemLastChangeDate Last Changed On
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
Column Name Description
SalesQuotationItemType Item Type Show values
HdrOrderProbabilityInPercent Sales probability Show values
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
QuotationRefSDDocumentCategory Document Category of Preceding SD Document Show values
ItemRefSDDocumentCategory Document Category of Preceding SD Document Show values
StatisticalValueControl Statistical Values Show values
SDProcessStatus Overall Processing Status (Item) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
PurchaseConfirmationStatus Purchasing Confirmation Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
DeliveryBlockStatus Delivery Block Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
SlsQtanToOrdProbltyInPercent Sales Quotation to Order Probability Show values
Column Name Description Domain name
ItemCreatedByUser Name of Person Responsible for Creating the Object USNAM
ItemCreationDateYear Year of Creation NUM4
ItemCreationDateYearQuarter Year/Quarter of Creation NUM5
ItemCreationDateYearMonth Year/Month of Creation NUM6
ItemCreationCalendarQuarter Calendar Quarter NUM1
ItemCreationCalendarMonth Calendar Month NUM2
ItemCreationCalendarWeek Calendar Week NUM2
ItemCreationCalendarDay Calendar Day NUM2
SalesQuotationType Sales Document Type AUART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
BindingPerdValdtyStartYear Calendar Year NUM4
BindingPerdValdtyStartQuarter Calendar Quarter NUM1
BindingPerdValdtyStartMonth Calendar Month NUM2
BindingPerdValdtyStartWeek Calendar Week NUM2
BindingPerdValdtyStartDay Calendar Day NUM2
BindingPerdValdtyEndYear Calendar Year NUM4
BindingPerdValdtyEndQuarter Calendar Quarter NUM1
BindingPerdValdtyEndMonth Calendar Month NUM2
BindingPerdValdtyEndWeek Calendar Week NUM2
BindingPerdValdtyEndDay Calendar Day NUM2
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
SalesInquiry Document number of the reference document VBELN
SalesInquiryItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SoldToParty Sold-to Party KUNNR
ResponsibleEmployeePersonnelID Employee Responsible PERNR
SalesEmployeePersonnelID Sales Employee PERNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
ShipToParty Ship-to Party KUNNR
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
SalesQuotationItemText Short text for sales order item TEXT40
NetPriceQuantity Condition Pricing Unit KPEIN
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.BASEUNIT == T006.MSEHI
Division
  • Client
  • Division
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == TSPA.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.DIVISION == TSPA.SPART
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == T148.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == TCURC.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVTRNGBSCDATA.ITEMTRANSACTIONCURRENCY == TCURC.WAERS
Volume unit
  • Volume unit
  • Client
  • P_SLSQTANPRDTVTRNGBSCDATA.ITEMVOLUMEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == T006.MANDT
Weight Unit
  • Client
  • Weight Unit
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.ITEMWEIGHTUNIT == T006.MSEHI
Material: order item
  • Client
  • Material Number
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == MARA.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_SLSQTANPRDTVTRNGBSCDATA.MATERIALGROUP == T023.MATKL
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == T023.MANDT
Condition Unit
  • Client
  • Condition Unit
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.NETPRICEQUANTITYUNIT == T006.MSEHI
Material Entered
  • Material Entered
  • Client
  • P_SLSQTANPRDTVTRNGBSCDATA.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == MARA.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • P_SLSQTANPRDTVTRNGBSCDATA.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == TVAG.MANDT
Sales document item category
  • Sales document item category
  • Client
  • P_SLSQTANPRDTVTRNGBSCDATA.SALESQUOTATIONITEMCATEGORY == TVPT.PSTYV
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == TVPT.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • SD Document Currency
  • P_SLSQTANPRDTVTRNGBSCDATA.MANDT == TCURC.MANDT
  • P_SLSQTANPRDTVTRNGBSCDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVTRNGBSCDATA.ITEMTRANSACTIONCURRENCY == TCURC.WAERS