Show TOC

 View Grouping: Multichannel Sales Comparison to Forecast

 

The views in this grouping combine multichannel sales data from SAP Customer Activity Repository and forecast data from Demand Data Foundation (DDF). These views enable performance measurement of sales by channel, for example, by allowing you to compare actual sales to forecasted sales for an article1 across multiple sales channels. As such, the views in this grouping allow you to react to deviations from forecasted sales, not to predict future sales.

Structure

Report Query Views

The multichannel sales versus forecast query view (MultichannelSalesVsForecastQuery) is included in this view grouping. This view allows users to display information about the articles actually sold through the different order channels in your business as compared to the forecasted sales.

Caution Caution

MultichannelSalesVsForecastQuery is a view that is intended to be used as a template and is not intended for productive use. It includes an extensive set of characteristics, measures and master data that may not be required for your business and that, as a result, can unnecessarily slow down the performance of the query view. Therefore, you can use the MultichannelSalesVsForecastQuery as a template to build several smaller, targeted query views which consume the reuse views listed below.

End of the caution.
Reuse Views

This view grouping contains the following main reuse views:

  • Multichannel POS sales forecast (MCPOSSalesForecast)

    This view obtains data from DDF. It exposes information for ExternalProduct, ExternalLocation, OrderChannel, TimeStampFrom, ForecastQuantityInBaseUnit, ForecastBaseUnit

  • Multichannel sales (MultiChannelSales_V2)

    This view obtains and combines sales data from the POS transaction log and sales documents from SAP ERP for Retail.

    Note that this view completely replaces its predecessor view, MultiChannelSales, which is now deprecated.

  • Material (Material)

    This view obtains master data regarding the material group from SAP ERP for Retail.

  • Plant (Plant)

    This view obtains master data regarding the plant from SAP ERP for Retail.

  • Material group (MaterialGroup)

    This view obtains master data regarding the material group from SAP ERP for Retail.

  • Date (Date)

    This view obtains the attributes of the calendar date on which the transaction occurred, for example, the week, month, or quarter, from SAP ERP for Retail.

  • Retail Article Hierarchy Node to article (RetailArticleHierNodeToArticle)

    This view provides data, such as the retail article and retail article hierarchy.

  • Order channel (OrderChannel)

    This view obtains Customizing data regarding the order channel from SAP Customer Activity Repository.

  • Unit of Measure Name

    This view provides data, such as names of the units of measure.

Business Objects

These views are built on the following business objects:

  • POS transaction

  • Billing document

Measures and Attributes

Some important measures and attributes are:

  • Forecast Quantity In Base Unit

    The measure provides information about forecast quantity in base unit of measure.

  • Sales Quantity in Base Unit

    The measure provides information about sales quantity in base unit of measure.

  • Net Sales Amount

    The measure provides information about net sales amount.

  • Net Sales Amount in Display Currency

    The measure provides information about net sales amount in display currency.

Calculation of Measures

To interpret the sales document aggregated sales data by article location, it is important to understand the calculation of certain measures included in this view grouping:

Measure

Explanation of Calculation

ForecastRevenu

ForecastQuantityInBaseUnit * (NetSalesAmount /SalesQuantityInBaseUnit)

ForecastRevenuIn DisplayCrcy

ForecastQuantityInBaseUnit * (NetSalesAmountInDisplayCrcy /SalesQuantityInBaseUnit)

ActualSalesVariance

(NetSalesAmount - ForecastRevenu ) / ForecastRevenu

ActualSalesUnitsVariance

SalesQuantityInBaseUnit -(ForecastQuantityInBaseUnit / ForecastQuantityInBaseUnit)

Filters

The views use the following filters:

  • Input parameter SAP client (SAPClient is P_SAPClient)

  • Input parameter Exchange Rate Type (P_ExchangeRateType) is used for currency conversion

  • Input parameter Display Currency (P_DisplayCurrency) is used to display in desired currency

  • Input parameter Validity Date (P_ValidityDate) is used for article hierarchy

Used Tables and Views

  • /POSDW/TLOGF (transaction log flat file) — SAP Customer Activity Repository

  • /DMF/UFC_TS (UDF forecast time series) — SAP Customer Activity Repository

  • /DMF/PROD_EXT_XR (product mapping to external system identifiers) — SAP Customer Activity Repository

  • /DMF/LOC_EXT_XR (location mapping to external system identifiers) — SAP Customer Activity Repository

  • /DMF/PROD (product) — SAP Customer Activity Repository

  • /DMF/LOC (location) — SAP Customer Activity Repository

  • T001W (plant) — SAP ERP for Retail

  • MARA (general article data) — SAP ERP for Retail

  • MAKT(article descriptions) — SAP ERP for Retail

  • T023 (merchandise categories) — SAP ERP for Retail

  • T023T (merchandise category descriptions) — SAP ERP for Retail

  • BI M_TIME_DIMENSION

  • WRF_MATGRP_HIER (Article Hierarchy Properties) — SAP ERP for Retail

  • /DSMFD/ORDERC (Order channel) — SAP Customer Activity Repository

1 The terms material, article and product, as well as the terms plant, store and location, are used interchangeably in the naming of SAP HANA views and fields, and, as a result, in this documentation.