I_SlsQtanConversionRateCube

Sales Quotation Conversion Rate - Cube | view: ISDSLSQTANCRC | TRAN | Extraction: Not supported | Component: Sales Analytics
Column Name Description
SalesQuotation FK Sales Quotation
SalesQuotationItem Sales Quotation Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
SalesQuotationNetAmount Net Value of the Order Item in Document Currency
CnvrtdSalesQuotationNetAmount Converted Sales Quotation Net Amount
PrdtvSlsQtanCnvrsnAmount Predicted Order Value in Transaction Currency
💲 Display Currency (DisplayCurrency):
SalesQuotationNetAmtInDspCrcy Sales Quotation Net Amount In Display Currency
CnvrtdSalesQtanNetAmtInDspCrcy Converted Sales Quoation Net Amount in Display Currency
PrdtvSlsQtanCnvrsnAmtInDspCrcy Predicted Order Value in Display Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
Column Name Description
Column Name Description Domain name
SalesQuotationType Sales Document Type AUART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SoldToParty Sold-to Party KUNNR
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
SlsQtanPeriodElapsedPercent Sales Quotation Period Elapsed Percent
SlsQtanPeriodDueDays Next Action in Days DUE_DAYS
PrdtvSlsQtanCnvrsnRate Predicted Sales Quotation Conversion Rate PRDTVSLSQTANCNVRSNRATE
Master Data Relations Join Conditions
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_SLSQTANCONVERSIONRATECUBE.MANDT == MARA.MANDT
  • I_SLSQTANCONVERSIONRATECUBE.MATERIAL == MARA.MATNR
  • I_SLSQTANCONVERSIONRATECUBE.PRODUCT == MARA.MATNR
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_SLSQTANCONVERSIONRATECUBE.MANDT == MARA.MANDT
  • I_SLSQTANCONVERSIONRATECUBE.MATERIAL == MARA.MATNR
  • I_SLSQTANCONVERSIONRATECUBE.PRODUCT == MARA.MATNR
SD Document Currency
  • Client
  • SD Document Currency
  • I_SLSQTANCONVERSIONRATECUBE.MANDT == TCURC.MANDT
  • I_SLSQTANCONVERSIONRATECUBE.TRANSACTIONCURRENCY == TCURC.WAERS