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.
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
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.
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.
These views are built on the following business objects:
POS transaction
Billing document
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.
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 |
---|---|
|
|
|
|
|
|
|
|
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
/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.