Key Figures: Sales and Distribution 

Sales Volume

There are a number of ways in which data relating to sales is written to the information structures of the Retail Information System. (For more information, see POS Interface.)

Sales data is written to these information structures either in aggregated form via the POS interface by means of the billing document, or via the normal Sales and Distribution processes (order, delivery, billing).

Sales data is written to these information structures by means of the POS interface. No documents are generated here.

Sales in the Information Structures S077-S086, S105-S106, S110, S123, S124

Note that the use of billing documents via the POS interface causes a stock reduction in the Inventory Management interface in the SAP System.

You need to keep to an appropriate pricing schema in order for sales figures to be updated correctly.

This key figure can have a number of different values (quantity, cost, rtlT, rtl).

Sales in the Information Structures for the POS Interface

Quantities sold at the POS. In RIS, values for this key figure are displayed in terms of the sales unit and the base unit of measure. Here the quantity is transferred without changing the POS. The quantity is always posted for a transaction item.

Net sales including/excluding tax. The sales value without tax is calculated on the basis of the sales including tax. The sales volume is always posted for a transaction item.

Sales at cost price excluding tax. The sales value is determined by the billing process.

Prerequisite :

The condition type VPRS (transfer price) must be set in the pricing procedure.

The following is true for this sales audit key figure:

If an information structure has the characteristic condition and a transaction item with two or more conditions, then the following special feature applies:

When drilling down the characteristic condition, the quantity is distributed proportionately between the respective conditions.

The distribution rule is as follows:

Proportional quantity = (Condition price reduction / Total price reduction) * Quantity

Averages sales per POS transaction. The key figure is calculated by dividing the sales at cost price including tax by the number of transactions.

This key figure cannot be calculated if an article-dependent drill-down (for example, merchandise category, article, condition) or an article-dependent selection has taken place. If you, for instance, drill down by article, the POS transaction is distributed among the articles. This changes the view of the data, which means that the system is unable to calculate the key figure.

Promotion Sales

Promotion sales means those sales that are linked to a promotion. In RIS, the promotion sales is expressed in terms of the following: cost, rtl, rtlT, quantity.

Sales (Absolute)

The absolute sales comprises all sales to customers.

Sales are a result of POS sales or from Sales and Distribution processes. This key figure expresses the absolute sales, that is, POS returns or credit memos from Sales and Distribution do not reduce this key figure.

Internal sales (for example, when the distribution center delivers goods to a site) are not taken into account.

In RIS, the absolute sales is expressed in terms of the following: cost, rtlT, rtl, quantity.

Third-Party Sales

Third-party sales refer to sales resulting from third-party order processing.

This key figure expresses the balanced sales, that is, credit memos from third-party order processing reduce this key figure. This key figure is expressed as a separate entity and does not increase the actual sales involving the customer, as no delivery of goods takes place. This key figure has particular significance for the wholesale trade.

The third-party sales is expressed in terms of the following: cost, rtlT, rtl, quantity.

The customer orders directly from the vendor and the invoice goes to the wholesaler. The wholesaler then bills the customer. The sales from these third-party transactions are written to the key figure ‘third-party sales’.

Sales Deviation

Sales deviation means the deviation in price between the price charged at the POS including discounts and the price designated in the R/3 System. The price deviation is determined by the billing process.

This key figure can only be supplied with values, if the total price deviation has been transferred to the field KZW13 in the pricing procedure. In the SAP standard system, the sales deviation can be found in the information structures article/add-on and STRPS, and is the sum of the key figures ‘price reduction’ and ‘price difference’ from the information structures for the sales audit.

Third-Party Orders

Order volumes resulting from customer orders in Sales and Distribution sales order processing that should be processed per third-party. A third-party order exists when the customer places an order directly with the vendor, and settlement is performed by the assigned wholesaler.

Third-party orders are expressed as a separate entity from sales orders. The allocation of period units is based on the entry date.

In RIS, the third-party orders are expressed in terms of the following: number of transactions, cost, rtlT, rtl, quantity.

Sales Orders

Total sales orders resulting from purchase orders made by customers in Sales and Distribution order processing.

Updating is performed on the basis of the entry date.

In RIS, the sales orders are expressed in terms of the following: number of transactions, cost, rtlT, rtl, quantity.

Open Orders

The volume of sales orders is determined at regular intervals, that is, the volume of open orders is calculated and displayed for each period.

The volume of open orders increases when a sales order is created in Sales and Distribution and is then reduced accordingly when the delivery is created.
Updating takes place on the entry date.

In the standard analyses, the open orders are expressed in terms of quantity and value.

Return Orders

Total volume of orders resulting from customer return orders from Sales and Distribution processing.

Updating is performed on the basis of the entry date.

In the standard analyses, the return orders are expressed in terms of the following: number of transactions, cost, rtlT, rtl, quantity.

Credit Memos

Credit memos given to the customer due to the return of goods to the point of sale or from Sales and Distribution processing.

The billing document needs to be used to carry out pricing, so that this key figure is updated correctly in all its various forms. Updating takes place on the billing date.

In the standard analyses, the credit memos are expressed in terms of the following: cost, rtlT, rtl, quantity.

Credit memo deviation

The credit memo deviation shows the difference between the potential credit memos and those credit memos granted.

Deliveries

Volume of deliveries to the customer resulting from sales orders from Sales and Distribution processing.

Updating takes place on the date of goods issue. Value determination is not performed for the delivery.

In the standard analyses, the deliveries are expressed in terms of quantity and value.

Return Deliveries

Volume of deliveries returned by customers resulting from sales orders from Sales and Distribution processing.

Updating takes place on the date of goods issue. The volume of return deliveries is expressed in base unit of measure or as the number of delivery items. Value determination is not performed for the return delivery.

In the standard analyses, the return deliveries are expressed in terms of quantity and value.

See also:

How Key Figures Are Calculated