SAP Sales DemoCube: Overview (SAP Library

SAP Sales DemoCube: Overview

SAP Sales DemoCube: Overview offers you analysis – scenarios that allow you to measure and assess the sales business processes within a company.

You can assess these business processes with the help of so-called Key Performance Indicators. These are key figures that reveal the processes that are crucial to the success of the company, so that you can measure and control them. Examples of this are incoming orders, sales and returns.

The workbooks, queries and data that are also delivered show, by way of example, how a decision-maker would analyze the various profit-making factors of his/her area of responsibility.

Elements of the SAP Sales DemoCube: Overview

Source system: SAP_DEMO

InfoSource: 0D_SD_C03_TD

Application component: 0D_SD

Characteristics:

InfoObject	Description	Attributes
0D_CO_CODE	Company code (SAP Demo)	0D_COUNTRY
0DIS_CHAN	Distribution channel (SAP Demo)	No
0D_INDUSTRY	Industry key (SAP Demo)	No
0D_PLANT	Plant (SAP Demo)	No
0D_SALE_ORG	Sales organization (SAP Demo)	0D_COUNTRY
0D_SALE_GRP	Sales group (SAP Demo)	No
0D_SHIPTO	Ship-to party (SAP Demo)	No
0D_SOLD_TO	Sold-to party (SAP Demo)	0D_COUNTRY 0D_INDUSTRY
0D_VERSION	Version (SAP Demo)	No
0D_VTYPE	Value type for report (SAP Demo)	No
0D_DIV	Division (SAP Demo)	No
0D_MATERIAL	Material (SAP Demo)	No
0D_PAYER	Payer (SAP Demo)	No
0D_DOCCLASS	Document class order/delivery/invoice (SAP Demo)	No
0D_DEBCRED	Credit/debit posting (SAP Demo)	No
0D_COUNTRY	Country (SAP Demo)	No
0D_REGION	GIS region (SAP Demo)	No

Time-characteristics:

InfoObject	Description
0CALYEAR	Calendar year
0CALMONTH	Calendar year/month
0FISCVARNT	Fiscal year variant

Key Figures:

InfoObject	Description	Units - InfoObject	Aggregation process
0D_OORQTYBM	Open order quantity (SAP Demo)	0BASE_UOM	Summation
0D_OORVALSC	Open order net value (SAP Demo)	0STAT_CURR	Summation
0D_QUANT_B	Quantity in base units of measure (SAP Demo)	0BASE_UOM	Summation
0D_DOCUMENT	Number of documents (SAP Demo)		Summation
0D_DOCITEMS	Number of document items (SAP Demo)		Summation
0D_NETVAL_S	Net value (SAP Demo)	0STAT_CURR	Summation
0D_COSTVALS	Cost value (SAP Demo)	0STAT_CURR	Summation
0D_GR_WT_KG	Gross weight in kg (SAP Demo)	(Kilograms)	Summation
0D_NT_WT_KG	Net weight in kg (SAP Demo)	(Kilograms)	Summation
0D_VOLUMCDM	Volume in CDM (SAP Demo)	(Cubic decimeters)	Summation

Units:

InfoObject	Description	Type
0STAT_CURR	Statistics currency	Currency
0BASE_UOM	Base unit of measure	Base UM

Queries

The queries described here are examples. As well as the completed queries delivered by SAP, you can, of course, create new queries that are based on the SAP Sales DemoCube: overview, and the corresponding data.

Delivered queries: Technical name:

Returns per customer and month (0D_SD_C03_Q003)
Incoming orders (0D_SD_C03_Q004)
Credit memos (0D_SD_C03_Q005)
Deliveries (0D_SD_C03_Q006)
Billing documents (0D_SD_C03_Q007)
Fulfillment rates (0D_SD_C03_Q008)
Order- and sales values (0D_SD_C03_Q009)
Order-, delivery- and sales quantities (0D_SD_C03_Q010)
Correct sales order processing (0D_SD_C03_Q011)

Workbooks

Assigning the delivered workbooks

	(A) Sales Manager	(B) Key Account Manager	(C) Sales Employee	(D) Product Manager	(E) Sales Controller	(F) Sales planner
(1) Short-term profit	Incoming orders per division	Incoming orders per customer	Incoming orders per sales org.	Incoming orders – product analysis
(2) Long-term profit	Sales org. fulfillment rate Correct order processing – sales org. Order- and sales values per sales org.	Correct order processing – customer analysis			Order- and sales values per customer Fulfillment rate per customer
(3) Determining profit for the period	Billing documents per sales org.		Order-, delivery- and sales quantities per customer		Order-, delivery- and sales values per sales org. Billing documents – product analysis
(4) Early-warning information	Credit memos per sales org.	Credit memos per customer Returns per customer	Returns per sales org.	Credit memos – product analysis Returns by product		Deliveries per sales org. Deliveries – customer analysis

(A) Sales Manager

Short-term profit: (A1) The workbook Incoming orders per division shows the Sales Manager how the incoming orders quantity and –values, or the corresponding purchase order costs, are distributed among the divisions of his/her company. The selection takes place on a monthly basis and uses the value type (actual).

(2) Long-term profit: (A2) The workbook Sales organization fulfillment rates contains information on incoming order quantities, open purchase order quantities and the fulfillment rates of the individual sales organizations.

The workbook Error-free order processing – sales organization contains details on, among others, incoming order- and return quantities, as well as on order and return values.

The workbook Order- and sales values per sales organization shows the incoming order-, return-, billing document- and credit memo values of the sales organizations. The selection takes place with all three workbooks on a monthly basis and uses the value type (actual).

(3) Profit for the period: (A3) The workbook Billing documents per sales organization allows, for example, an insight into billing document quantities and -values, and the billing document costs of the sales organizations. The selection takes place on a monthly basis and uses the value type (actual).

(4) Early-warning information: (A4) The workbook Credit memos per sales organization provides the Sales Manager and others with information on credit memo quantities and –values in relation to the billed quantities and values. The selection takes place on a monthly basis and uses the value type (actual).

(B) Key Account Manager

Short-term profit: (B1) The workbook Incoming orders per customer shows the Key Account Manager how the incoming order quantities and –values, or the corresponding purchase order costs, are shared between the customers. The selection takes place on a monthly basis and uses the value type (actual).

(2) Long-term profit: (B2) The workbook Error-free order processing – customer analysis contains, for example, details on incoming order- and return quantities, as well as order and return values per sold-to party. The selection takes place on a monthly basis and uses the value type (actual).

(4) Early-warning information: (B4) The workbook Credit memos per customer provides the Key Account Manager and others about credit memo quantities and –values in relation to the billed quantities and values. The selection takes place on a monthly basis and uses the value type (actual).

The workbook Returns per customer reveals the relationship between returns quantity and incoming orders quantity, or returns value and incoming orders value for the sold-to party. The selection takes place on a monthly basis and uses the value type (actual).

(C) Sales Employee

Short-term profit: (C1) The workbook Incoming orders per sales organization shows the Sales Employee how the incoming orders quantity and –values, or the corresponding purchase order costs, behave in the sales organization. The selection takes place on a monthly basis and uses the value type (actual).

(3) Profit for the period: (C3) The workbook Order- and delivery- and sales quantities per customer gives the Sales Employee an overview over incoming orders-, delivery-, billing documents-, returns-, return delivery- and credit memo quantities, and how they are divided among the individual customers. The selection takes place on a monthly basis and uses the value type (actual).

(4) Early-warning information: (C4) The workbook Returns per sales organization reveals the relationship between returns quantity and incoming orders quantity, or returns value and incoming orders value, per sales organization. The selection takes place on a monthly basis and uses the value type (actual).

(D) Product Manager

Short-term profit: (D1) The workbook Incoming orders – product analysis shows the Sales Manager how the incoming orders quantities and –values, or the corresponding purchase order costs, are made up for the individual products. The selection takes place on a monthly basis and uses the value type (actual).

(4) Early-warning information: (D4) The workbook Credit memos - product analysis provides the Sales Manager and others with information on credit memo quantities and –values in relation to the billed quantities and values of the products. The selection takes place on a monthly basis and uses the value type (actual).

The workbook Returns by product reveals the relationship between returns quantity and incoming orders quantity, or returns value and incoming orders value, for the individual products. The selection takes place on a monthly basis and uses the value type (actual).

(E) Sales Controller

(2) Long-term profit: (E2) The workbook Order- and sales values per customer shows the incoming orders-, returns-, billing document- and credit memo values of the customers.

The workbook Fulfillment rates per customer contains information on incoming order quantities, open purchase order quantities and the fulfillment rates for the individual customers. The selection takes place with all three workbooks on a monthly basis and uses value type (actual).

(3) Profit for the period: (E3) The workbook Order-, delivery- and sales quantities per sales organization assigns the incoming order-, delivery- return-, return delivery-, billing document- and credit memo quantities to the sales organizations.

The workbook Billing documents – product analysis allows, for example, an insight into sales quantities and –values that were reached when the products were sold. The selection takes place with both workbooks on a monthly basis and uses the value type (actual).

(F) Sales Planner

(4) Early-warning information: (F4) The workbook Deliveries – customer analysis gives the Sales Planner information about delivery quantities, gross and net weight of the delivery, as well as the delivery volume. These statistics can be analyzed per customer.

In the workbook Deliveries per sales organization, the Sales Planner can see the delivery quantities, the delivery gross and net weight, as well as the delivery volumes for the sales organizations. The selection takes place with both workbooks on a monthly basis and uses the value type (actual).