- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
I_SalesAnalyticsCube_1
Sales Volume and Open Sales - Cube
| view: ISDSLSANACUBE1 | TRAN
| Extraction:
Not supported
| Component: Sales Analytics
- 🔑 Keys (9)
- 💰 Amounts (32)
- ∑ Quantities (7)
- 📅 Dates (3)
- ☰ Categorical (2)
- Other (24)
- 🔗 Relations (17)
| 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 | |
| CustCrdtMemoPrftMargNetAmt | Net Amount of Customer Credit Memo Profit MarginTrans Curr. | |
| Subtotal1Amount | Subtotal 1 from Pricing Procedure for Condition | |
| Subtotal2Amount | Subtotal 2 from Pricing Procedure for Condition | |
| Subtotal3Amount | Subtotal 3 from Pricing Procedure for Condition | |
| Subtotal4Amount | Subtotal 4 from Pricing Procedure for Condition | |
| Subtotal5Amount | Subtotal 5 from Pricing Procedure for Condition | |
| Subtotal6Amount | Subtotal 6 from Pricing Procedure for Condition | |
| 💲 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 | |
| Subtotal1AmountInDC | Subtotal 1 from Pricing Procedure for Condition (in DC) | |
| Subtotal2AmountInDC | Subtotal 2 from Pricing Procedure for Condition (in DC) | |
| Subtotal3AmountInDC | Subtotal 3 from Pricing Procedure for Condition (in DC) | |
| Subtotal4AmountInDC | Subtotal 4 from Pricing Procedure for Condition (in DC) | |
| Subtotal5AmountInDC | Subtotal 5 from Pricing Procedure for Condition (in DC) | |
| Subtotal6AmountInDC | Subtotal 6 from Pricing Procedure for Condition (in DC) | |
| CustCrdtMemoPrftMargNetAmtInDC | Credit Memo Profit Margin Net Value in Display Currency | |
| 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 | |
|---|---|---|
| BillingDocumentDate | Date of Billing | |
| 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 | |
| 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 | |
| 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 | |
| BillingDocDateCalendarQuarter | Calendar Quarter of Billing | NUM1 | |
| BillingDocDateCalendarMonth | Calendar Month of Billing | NUM2 | |
| 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 |
|---|---|
Material Group 1
| |
Material Group 2
| |
Material Group 3
| |
Material Group 4
| |
Material Group 5
| |
Base Unit of Measure
| |
Customer Group
| |
Material: order item
| |
Material Group
| |
Material Entered
| |
Material: order item
| |
Product Group
| |
Product hierarchy: order item
| |
Sales District
| |
Statistics currency
| |
SD Document Currency
|