Show TOC

 Virtual Data Model: Sales Orders

 

When you model and forecast demand in SAP Customer Activity Repository, you use the Unified Demand Forecast (UDF) module. For input, you need to provide historical demand data. You can use the virtual data model for sales orders (time series source SO_VDM) to provide this input. The VDM accesses historical sales orders stored in the SAP HANA content of SAP Customer Activity Repository.

Structure

The SO_VDM allows UDF to access historical sales orders (typically, Web purchases) in the data model of SAP Customer Activity Repository. The sales orders are aggregated to the level of product / location / sales organization / distribution channel / order channel / day. Note that this time series is not persisted in DDF (unlike POS_TS or CONS_TS, see Time Series).

Via this VDM, UDF consumes the SalesDocumentAggregatedSalesByArticleLocation view in the sap.is.retail.car SAP HANA content package. The view provides the demand modeling service with the data required to assess the effects of demand influencing factors (DIFs) on consumer demand.

For more information about the data consumed, see View Grouping: Sales Document Aggregated Sales Data by Article Location. You can also find there information about attributes, calculated measures, filters, and tables.

Integrating Promotional Information

With this VDM, you can also integrate promotions defined in SAP ERP and use them as input for demand modeling and forecasting. Providing promotional information as part of your demand data is very important because promotions can significantly impact consumer demand and thus, also the forecasted unit sales. You can use the SAP ERP promotions in addition to promotions defined in SAP Promotion Management for Retail, for example.

  • Prerequisite: Your SAP ERP system must have been set up to provide all the promotional information required for demand modeling and forecasting. To determine those requirements for your customer-specific system landscape, please contact your SAP consultant.

  • Integration: See the Introduction to Demand Data Foundation (DDF) section of the Administrator's Guide, Demand Data Foundation (DDF) with Unified Demand Forecast (UDF) on SAP HANA. You can find this guide on SAP Help Portal at Start of the navigation path http://help.sap.com/carInformation published on non-SAP site Next navigation step <your release> Next navigation step Integration Information End of the navigation path.

  • Implementation: UDF consumes the SAP ERP promotions via the RetailPromotionByArticleLocationExcludingBonusBuy view in the sap.is.retail.ecc SAP HANA content package. For more information about views with promotional information, see the SAP HANA Live for SAP ERP Views Required by SAP Customer Activity Repository section of the Installation Guide, SAP Customer Activity Repository. You can find this guide on SAP Help Portal at Start of the navigation path http://help.sap.com/carInformation published on non-SAP site Next navigation step <your release> Next navigation step Installation and Upgrade Information End of the navigation path.

More Information