POS DT&A – Analyze POS Transaction

This view grouping contains the following main reuse views:

• Operator qualifier (OperatorQualifer) : This view obtains data from the transaction log (TLOG) that identifies the POS operator.

• Item ID qualifier (ItemIDQualifer) : This view obtains information about the item ID qualifier, such as the SAP material number, EAN/UPC, free-text entry, and so on, from the TLOG.

• Flag (Flag) : This view obtains data for generic yes-no flag used in several POS transactions in the TLOG.

• Debit flag (DebitFlag) : This view obtains data indicating whether the transaction is a sale or return (credit or debit).

• Business type (BusinessType) : This view obtains data for the business type (categorization of POS transactions, such as sales transaction or financial movement), as defined in SAP Customer Activity Repository Customizing. The most interetesting Type is usualy 1 for Sales Transaction.

• Data status (DataStatus) : This view obtains the status of the quality of the POS transaction data, such as whether a master data check error is present. You would be interested in Data status 3 only if you use the task to determine status in transaction and tick the checkbox “Data Status Relevant” into In-Memory Analytics section of the task

• Customer qualifier (CustomerQualifier) : This view obtains data that identifies the customer from the TLOG.

• POS segments classification (POSSegmentsClassification) : This view obtains data from the TLOG providing the business classification of the categories and subcategories available for a POS transaction segment.

• Transaction type (TransactionType) : This view obtains data regarding the classification of a POS transaction type (sale, goods movement, and so on) from the TLOG.

• Retail reason (RetailReason) : This view obtains data providing the reason for the sale of the item as defined in SAP Customer Activity Repository Customizing.

• Retail type (RetailType) : This view obtains data providing the type of sale for the item (for example, sale, return, and so on) as defined in SAP Customer Activity Repository Customizing.

• Order channel (OrderChannel) : This view obtains Customizing data defining the channel in which the order was received (Web, in-store, and so on).

moreover, the main POS data repository has also some views

This view grouping contains the following main reuse views:

• POS log header (POSLogHeader) : This view obtains transactional data from the transaction log header from the transaction log (TLOG).

• POS log loyalty (POSLogLoyalty) : This view obtains the loyalty information on transaction or item level from the TLOG.

• POS Log Item Analytic (POSLogItemAnalytic) : This view obtains the transaction item information from the TLOG.

They provide from table /POSDW/TLOGF some important measures and attributes :

• POS log header (POSLogHeader) view

  • The view provides general data, such as the order channel, store ID, transaction date, time, and number, department, operator ID, partner ID, transaction status, data status, and the customer number.

  • The view provides information about values, such as the transaction amount.

• POS log loyalty (POSLogLoyalty) view

  • The view provides general data, such as the store ID, transaction date, time, status, and number, department, operator ID, partner ID, business type and location, customer number, loyalty number, customer card number, loyalty program, customer cardholder name, card type, and the card validity dates.

  • The provides information about values, such as the transaction turnover amount, value of the loyalty points awarded, eligible sales value, eligible quantity, value of the loyalty points redeemed, and the total value of the loyalty points.

• 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.

If you’ve activated the PLOGF (flat log option) you should be able to analyze status of each step (task) for transactions as well as the related messages.

Regards

Amaury