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.
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.
These views are built on the following business objects:
POS transaction
Sales order
Sales document
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.
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 |
---|---|
| 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. |
| In view In view |
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.
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