Show TOC

 View Grouping: POS Aggregated Sales Data for Demand Data Foundation

 

The views in this grouping are used to provide aggregated sales item data from the point-of-sale (POS) system. In addition, these views are reused in integration scenarios with Demand Data Foundation (DDF), as they can be used to obtain sales data for use in demand planning. This was possible previously only through SAP POS Data Management reporting to SAP Demand Management Foundation (DMF).

Structure

Reuse Views

  • POS aggregated sales for DDF (POSAggregatedDDFSales)

    This view obtains sales item data from POS transactions, and aggregates the data based on the applicable attributes. It exposes information for all items with common attributes across all channels (in-store, Web, and so on).

  • POS aggregated sales data (POSAggregatedSales)

    This view obtains the transactional sales item data from POS transactions, and aggregates the data based on the applicable attributes.

  • POS Log Item Analytic (POSLogItemAnalytic)

    This view obtains the transaction item information from SAP Customer Activity Repository.

  • POS log item offer determination (POSLogItemOffer)

    This view obtains the transaction item information from SAP POS Data Management, and determines the specific offer for each retail line item. If no offer is available, then no results are provided for the retail line item. If multiple offers are found for a single retail line item, then the system determines and selects the most relevant offer.

  • Promotion product (PromotionProduct)

    This view provides promotion data for non bonus buy products, the promotion and bonus buy identifiers, the validity date range for the promotion, and the underlying DDF offer.

  • Promotion bonus buy product (PromotionBonusBuyProduct)

    This view provides promotion data for bonus buy products, the promotion and bonus buy identifiers, the validity date range for the promotion or bonus buy, and the underlying DDF offer.

Business Objects

These views are built on the POS transaction business object.

Measures and Attributes

Some important measures and attributes are:

  • POS aggregated DDF sales (POSAggregatedDDFSales) view

    • The view provides general data such as the store ID, plant, order channel, material number, sales organization, distribution channel, and the offer ID.

    • The view provides information about values, such as the gross sales amount, retail sales net amount, revenue tax, revenue net, and unit sales. The currency provided as an input parameter (P_DisplayCurrency) is used to display all measures, and any currency conversion is performed automatically based on the exchange rate type provided as an input parameter (P_ExchangeRateType).

  • POS aggregated sales item (POSAggregatedSales) view

    • The view provides general data such as the plant, the order channel, the transaction and store currencies, the material number and base unit-of-measure, the retail item category and subcategory, the transaction business date, index and row key.

    • The view provides information about values such as the sales quantity in base unit-of-measure, sales amount, item tax-included amount, item tax-excluded amount, item discount amount, distributed discount amount, distributed header tax-included amount, and distributed header tax-excluded amount.

  • POS transaction item offer (POSLogItemOffer) view

    • The view provides the offer determined for a specific POS transaction retail line item.

  • Promotion bonus buy product (PromotionBonusBuyProduct) view

    The view provides general data, such as the sales organization, distribution channel, bonus buy ID, product ID, promotion ID, offer ID, and the promotion validity dates.

  • POS Log Item Analytic (POSLogItemAnalytic) view

    • The view provides general data, such as the customer number, item category and subcategory, material number and group, promotion ID (if applicable), item ID, transaction date, time and status, partner ID, operator ID, transaction number, date and time, store ID, and the order channel.

    • The view provides information about values such as the quantity, sales amount, normal sales amount, cost amount, tax-included and tax-excluded amount, and the distributed discounts, taxes, and tender amounts.

Calculation of Measures

To interpret the POS aggregated DDF sales data, it is important to understand the calculation of certain measures included in this view grouping:

Measure

Explanation of Calculation

UnitSalesSquared

This measure shows the unit sales for POS transactions multiplied by itself.

UnitSalesCubed

This measure shows the unit sales for POS transactions multiplied by itself and then again.

In view POSAggregatedDDFSales, this measure is used for DDF forecasting.

TransactionCount

In view POSAggregatedDDFSales, this measure shows the number of transactions applicable.

GrossSalesValue

In view POSAggregatedSales, this measure shows the gross sales amount for sale or return items, excluding any distributed discount amount but including any item tax excluded amount or distributed header tax-excluded amount.

RetailSalesNetValue

In view POSAggregatedSales, this measure shows the net retail sales amount for sale or return items, excluding any distributed discount amount, any item tax-included amount, or distributed header tax-included amount.

Filters

The views use the following filters:

  • The POS aggregated sales item (POSAggregatedSales) view filters the following:

    • Input parameter SAP client (SAPClient is P_SAPClient)

    • Input parameter plant (Plant is P_Store)

    • Input parameter business day date (BusinessDayDate is between P_StartDate and P_EndDate)

    • Business type (BusinessTypeis 1). The business type must be a type of sale or return.

    • Void and training transactions, so that only valid sales and return transactions are included in the data

    • Debit transactions, so that only credit transactions are included in the data

    • POS retail line item category (RetailItemCategory is A). The category should be a sale.

  • The transaction item offer (POSLogItemOffer) view filters the POS transaction for the following:

    • Business type (BUSINESS_TYPE is 1). The business type must be a type of sale or return.

    • Void and training transactions, so that only valid sales and return transactions are included in the data

    • Record qualifier (RECORDQUALIFER is 6 or 11 or 5). The record qualifier must be a retail line item level discount, a header level discount, or a retail line item.

    • The promotion product (PromotionProduct) and promotion bonus buy product (PromotionBonusBuyProduct) views used within the transaction item offer (POSLogItemOffer) view filters the offer (OfferId is not empty), so that only promotions or bonus buys with an associated offer are considered.

Used Tables and Views

The views select data from the following tables:

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

  • WALE (material to store assignment to promotion) — SAP ERP for Retail

  • WAKP (promotion item data) — SAP ERP for Retail

  • KOTN203 (sales organization, sales channel, plant, bonus buy, material,sales) — SAP ERP for Retail

  • KONBBYH (bonus-buys header) — SAP ERP for Retail

  • T001W (plant) — SAP ERP for Retail