- 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)
C_SalesAnalyticsQry_1
Sales Volume and Open Sales - Query
| view: CSDSLSANALYTICQ1
| Extraction:
Not supported
| Component: Sales Analytics
- 🔑 Keys (9)
- 💰 Amounts (15)
- ∑ Quantities (7)
- 📅 Dates (1)
- ☰ Categorical (2)
- Other (20)
- 🔗 Relations (14)
| 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 | |
|---|---|---|
| 💲 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.) | |
| CustCrdtMemoNetAmtInDspCrcy | Net Value of Credit Memos | |
| SlsVolumeNetAmtInDspCrcy | Net Value of Invoiced Sales | |
| SlsProfitMargNetAmtInDspCrcy | Profit Margin Amount in Display Currency | |
| CustCrdtMemoPrftMargNetAmtInDC | Credit Memo Profit Margin Net Value in Display Currency | |
| OpenSalesOrdersNetAmountInDC | Open Sales Orders Net Amount In Display Currency | |
| OpenSlsOrdsForInvcsNetAmtInDC | Open Sales Orders for Invoices Net Amount in Display Crcy | |
| NetSlsVolumeNetAmtInDC | Net Sales Volume in Display Currency | |
| NetSlsProfitMargNetAmtInDC | Net Profit Margin Net Value in Display Currency | |
| NetSalesCostAmountInDC | Net Sales Cost Amount 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) | |
| CustCreditMemoQuantity | Quantity of Credit Memos | |
| SalesVolumeQuantity | Sales Volume Quantity | |
| Column Name | Description | |
|---|---|---|
| BillingDocumentDate | Date of Billing |
| 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 | |
| Customer | Customer Number | KUNNR | |
| 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 | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| Division | Division | SPART | |
| SalesOffice | Sales office | VKBUR | |
| SalesGroup | Sales group | VKGRP | |
| 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 | |
| SalesOrder | Sales Order | VBELN | |
| SalesProfitMargin | Profit Margin Ratio |
| 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: order item
| |
Product Group
| |
Product hierarchy: order item
| |
Sales District
|