I_SalesAnalyticsCube

Analytics - Sales Volume and Open Sales | view: ISDSLSANACUBE | TRAN | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPVBRPVBRKSCAL_TT_DATELIKPLIPSVBKDVEDAVBAKFPLTVBAKVBAPVBKDVEDAVBAKVBAPVBKDVEDAVBEPBUT000T001TKA02TKA01KNA1T042ZT042ZTT001WKONATVKOT000T001LUSR21
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line Number
BillingPlan Billing plan number / invoicing plan number
BillingPlanItem Item for billing plan/invoice plan/payment cards
DeliveryDocument Delivery
DeliveryDocumentItem Delivery Item
BillingDocument Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OpnSOForOrdReltdInvcsNetAmount Open Sales Orders for Ord.Reltd Invoices Net Amount
OpnRetsForOrdReltdInvcsNetAmt Open Return For Order Related Invoices Net Amount
OpenSlsOrdersForDelivNetAmount Open Sales Orders for Deliveries Net Amt in Trans. Crcy
OpnSlsOrdsForInvcPlansNetAmt Open Sls Orders for Inv Plans Net Amt in Trns Crcy
OpnOutbDelivsForInvcNetAmt Net Amount of Open Deliveries for Invoices
ShpdNotInvcdDelivsNetAmount Value of Deliveries Shipped But Not Invoiced (inTC)
SalesVolumeNetAmount Net Value in Document Currency
SalesProfitMarginNetAmount Net Value in Document Currency
CustomerCreditMemoNetAmount Net Value in Document Currency
💲 Display Currency (DisplayCurrency):
OpnSOForOrdReltdInvcsNetAmtDC Open Sales Orders for Ord.Reltd Billing Net Amount IDC
OpnRetsOrdReltdInvcsNetAmtInDC Open Returns For Order Rel Invoices Net Amnt in Displ Curr
OpnSlsOrdsForDelivAmtInDspCrcy Open Sales Orders for Deliveries Net Amt in Displ. Crcy
OpnSlsOrdsForInvcPlansNetAmtDC Open Sls Orders for Billing Plans Net Amt in Displ. Crcy
OpnOutbDelivsForInvcNetAmtInDC Net Amount of Open Deliveries for Invoices(Display Currency)
ShpdNotInvcdDelivsNetAmtInDC Value of Deliveries Shipped But Not Invoiced (Display Curr.)
SlsVolumeNetAmtInDspCrcy Net Value of Invoiced Sales
SlsProfitMargNetAmtInDspCrcy Profit Margin Amount in Display Currency
CustCrdtMemoNetAmtInDspCrcy Net Value of Credit Memos
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OpnSlsOrdsForOrdReltdInvcsQty Open Sales Orders for Order-Related Billing Quantity
OpnRetsForOrdReltdInvcsQty Open Return For Order Related Invoices Quantity
OpnSlsOrdrsForDelivQuantity Open Confirmed Sales Orders for Deliveries Quantity in BU
OpnOutbDelivsForInvcQty Quantity of Open Deliveries for Invoices
ShpdNotInvcdDelivsQuantity Quantity of Deliveries Shipped But Not Invoiced (SKU)
SalesVolumeQuantity Sales Volume Quantity
CustCreditMemoQuantity Quantity of Credit Memos
Column Name Description
CalendarDate Billing Date
CreationDate Date on which the record was created
Column Name Description
SDDocumentCategory SD Document Category Show values
SDDocumentObject SD Document Object Show values
Column Name Description Domain name
SoldToParty Sold-to Party KUNNR
SoldToPartyName Name of Sold-to Party TEXT80
Customer Customer Number KUNNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ProfitCenter Profit Center PRCTR
BillingDocumentDateYear Year of Billing NUM4
BillingDocDateYearQuarter Quarter/Year of Billing NUM5
BillingDocDateYearMonth Month/Year of Billing NUM6
SalesDocumentType Sales Document Type AUART
ShippingPoint Shipping Point / Receiving Point VSTEL
BillingDocumentType Billing Type FKART
SalesOrder Sales Order VBELN
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SALESANALYTICSCUBE.MANDT == T006.MANDT
  • I_SALESANALYTICSCUBE.BASEUNIT == T006.MSEHI
Customer Group
  • Client
  • Customer Group
  • I_SALESANALYTICSCUBE.MANDT == T151.MANDT
  • I_SALESANALYTICSCUBE.CUSTOMERGROUP == T151.KDGRP
Material: order item
  • Client
  • Material Number
  • I_SALESANALYTICSCUBE.MANDT == MARA.MANDT
  • I_SALESANALYTICSCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SALESANALYTICSCUBE.MANDT == T023.MANDT
  • I_SALESANALYTICSCUBE.MATERIALGROUP == T023.MATKL
Material Entered
  • Client
  • Material Entered
  • I_SALESANALYTICSCUBE.MANDT == MARA.MANDT
  • I_SALESANALYTICSCUBE.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Product hierarchy: order item
  • Client
  • Product hierarchy
  • I_SALESANALYTICSCUBE.MANDT == T179.MANDT
  • I_SALESANALYTICSCUBE.PRODUCTHIERARCHYNODE == T179.PRODH
Sales District
  • Client
  • Sales District
  • I_SALESANALYTICSCUBE.MANDT == T171.MANDT
  • I_SALESANALYTICSCUBE.SALESDISTRICT == T171.BZIRK
Statistics currency
  • Client
  • Statistics currency
  • I_SALESANALYTICSCUBE.MANDT == TCURC.MANDT
  • I_SALESANALYTICSCUBE.STATISTICSCURRENCY == TCURC.WAERS
SD Document Currency
  • Client
  • SD Document Currency
  • I_SALESANALYTICSCUBE.MANDT == TCURC.MANDT
  • I_SALESANALYTICSCUBE.TRANSACTIONCURRENCY == TCURC.WAERS