I_SalesQuotationItemAnalytics

Sales Quotation Item Analytics | view: ISDSLSQTANITMANA | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of Sales Order in Transaction 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
SlsQuotationOpenNetAmount Net Amount of Open Sales Quotations
CnvrtdSalesQuotationNetAmount Converted Sales Quotation Net Amount
SlsQtanRejectedNetAmount Net Amount of Rejected Sales Quotation Items
Column Name Description
📏 Base Unit of Measure (BaseUnit):
RequestedQuantityInBaseUnit Requested Order Quantity in Base Unit
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
SalesQuotationQuantity Quantity of Sales Quotation Items
CnvrtdSalesQuotationQuantity Converted Sales Quotation Quantity
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesDocumentDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
ServicesRenderedDate Date on which services are rendered
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
TodayDate null
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type Show values
CompletionRule Completion Rule for Quotation / Contract Show values
ItemOrderProbabilityInPercent Order Probability of the Item Show values
StatisticalValueControl Statistical Values Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document 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
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
SDProcessStatus Overall Processing Status (Item) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
PurchaseConfirmationStatus Purchasing Confirmation Status 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
SDDocumentRejectionStatus Rejection Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
SDDocReferenceStatus Reference Status (Item) Show values
SlsQtanToOrdProbltyInPercent Sales Quotation to Order Probability Show values
Column Name Description Domain name
SalesDocumentItemUUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
SalesDocumentType Sales Document Type AUART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
MaterialByCustomer Material Number Used by Customer IDNEX
Plant Plant (Own or External) WERKS
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
SalesDocumentItemText Short text for sales order item TEXT40
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
PurchaseOrderByCustomer Customer Reference BSTKD
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
TargetToBaseQuantityDnmntr Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
TargetToBaseQuantityNmrtr Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
NetPriceQuantity Condition Pricing Unit KPEIN
ShippingCondition Shipping Conditions VSBED
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalValueDays Additional Value Days TAGE2
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
NmbrOfOpenSlsQuotationItems Number of Open Sales Quotation Items
NmbrOfRejectedSlsQtanItems Number of Rejected Sales Quotation Items
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVM1.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVM2.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVM4.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVM5.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T006.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.BILLINGCOMPANYCODE == T001.BUKRS
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T001.MANDT
Business Area
  • Client
  • Business Area
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TGSB.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.BUSINESSAREA == TGSB.GSBER
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVKT.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Customer Group
  • Client
  • Customer Group
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T151.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.CUSTOMERGROUP == T151.KDGRP
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T176.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVLS.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TPRIO.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.DELIVERYPRIORITY == TPRIO.LPRIO
Division
  • Client
  • Division
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TSPA.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.DIVISION == TSPA.SPART
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.INCOTERMSVERSION == TINCV.INCOV
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TINCV.MANDT
Volume unit
  • Client
  • Volume unit
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T006.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T006.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.ITEMWEIGHTUNIT == T006.MSEHI
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == MARA.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.MATERIAL == MARA.MATNR
  • I_SALESQUOTATIONITEMANALYTICS.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Product Group
  • Material Group
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T023.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.PRODUCTGROUP == T023.MATKL
  • I_SALESQUOTATIONITEMANALYTICS.MATERIALGROUP == T023.MATKL
Condition Unit
  • Client
  • Condition Unit
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T006.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.NETPRICEQUANTITYUNIT == T006.MSEHI
Material Entered
  • Client
  • Material Entered
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == MARA.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Payment Method
  • Client
  • Payment Method
  • ?
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T042Z.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.PAYMENTMETHOD == T042Z.ZLSCH
  • I_SALESQUOTATIONITEMANALYTICS.[column in domain "LAND1"] == T042Z.LAND1
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == MARA.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.MATERIAL == MARA.MATNR
  • I_SALESQUOTATIONITEMANALYTICS.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • Material Group
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T023.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.PRODUCTGROUP == T023.MATKL
  • I_SALESQUOTATIONITEMANALYTICS.MATERIALGROUP == T023.MATKL
Route
  • Route
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.ROUTE == TVRO.ROUTE
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVRO.MANDT
Sales District
  • Client
  • Sales District
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T171.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVPT.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVAG.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.SHIPPINGPOINT == TVST.VSTEL
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TVST.MANDT
Shipping Type
  • Shipping Type
  • Client
  • I_SALESQUOTATIONITEMANALYTICS.SHIPPINGTYPE == T173.VSART
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T173.MANDT
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T001L.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.PLANT == T001L.WERKS
  • I_SALESQUOTATIONITEMANALYTICS.STORAGELOCATION == T001L.LGORT
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == T006.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • Client
  • SD Document Currency
  • I_SALESQUOTATIONITEMANALYTICS.MANDT == TCURC.MANDT
  • I_SALESQUOTATIONITEMANALYTICS.TRANSACTIONCURRENCY == TCURC.WAERS