Show TOC

 View Grouping: Multichannel Sales Item Data

 

The views within this grouping provide sales item data from the point-of-sale (POS) system combined with sales data from sales documents accessed by SAP Customer Activity Repository from a source SAP ERP system.

Structure

Reuse Views

This view grouping contains the following main reuse views:

  • Multichannel sales item (MultichannelSalesItem)

    This view combines sales item data from the POS transaction and sales documents. It exposes information for all items with common attributes across all channels (Walk In (store), Web, and so on).

  • Sales order item (SalesOrderItem)

    This view obtains sales order item data and information about the sold-to party from SAP ERP sales documents.

  • Sales document order channel (SalesDocumentOrderChannel)

    This view obtains the origin of the sales document, and maps the sales order, document type, and distribution channel attributes of the sales order to an order channel as defined in Customizing in SAP Customer Activity Repository.

  • POS Log Item Analytic (POSLogItemAnalytic)

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

  • Plant (Plant)

    This view provides general data, such as the plant name and address, customer and vendor numbers, and distribution channel.

  • Sales document header (SalesDocumentHeader)

    This view provides data from sales document headers from SAP ERP.

  • Sales document item (SalesDocumentItem)

    This view provides data from sales document items from SAP ERP.

  • Sales document schedule line (SalesDocumentScheduleLine)

    This view provides data from schedule lines of sales documents from SAP ERP.

Business Objects

These views are built on the following business objects:

  • POS transaction

  • Sales order

  • Sales document

Measures and Attributes

Some important measures and attributes are:

  • Multichannel sales item (MultichannelSalesItem) view

    • The view provides general data such as the store ID, plant, order channel, sold-to party, promotion ID (if applicable), material number and group, sales organization, distribution channel, the sales order category, type and item, and the SAP CRM document universal unique identifier.

    • The view provides information about values, such as the sales amount, tax-excluded amount, distributed taxes amount, and the quantity, total net amount and tax amount for the sales order item quantity.

  • Billing document item (BillingDocumentItem) view

    • The view provides general data such as the billing document item and date, article name, international article number (EAN), sales item type and category, the order channel, the material group, and the purchase date.

    • The view provides information about values such as the sales net amount, tax amount, return amount, and promotion amount.

  • Sales document order channel (SalesDocumentOrderChannel)

    The view provides general data such as the sales organization, distribution channel, sales document type, and order channel.

  • POS Log Item Analytic (POSLogItemAnalytic)

    • 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 you multichannel sales item data, it is important to understand the calculation of certain measures included in this view grouping:

Measure

Explanation of Calculation

ItemQuantity

This measure shows the number of items that were sold or returned for POS transactions, and the number of items that were ordered or returned for sales orders.

TotalNetAmount

In view MultiChannelSalesItem, this measure reflects the item net amount including all taxes for POS items and sales order items.

In view SalesOrderItem, this measure reflects the item net amount.

Filters

The views use the following filters:

  • The multichannel sales item (MultiChannelSalesItem) view filters void and training transactions, so that only sales and return transactions are included in the data.

  • The sales order item (SalesOrderItem) view filters the sales document category (SDDocumentCategory is C or H). The category can be either an order or a return.

Used Tables and Views

The views select data from the following tables:

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

  • VBAK (sales document header) — SAP ERP for Retail

  • VBUK (sales document header status) — SAP ERP for Retail

  • VBAP (sales document item) — SAP ERP for Retail

  • VBUP (sales document item status) — SAP ERP for Retail

  • T001W (plant) — SAP ERP for Retail

  • /CAR/SALESDOCOC (sales document order channel) — SAP Customer Activity Repository