POS DT&A – Analyze POS Transaction

Hello

we’re going to study the main fields for Point of Sales Transaction in table /POSDW/TLOGF and its foreign keys provider.

As you already probably know, this table contains the main information related to your POS Transactions.

During customizing step, you’ve defined some grouping fields and named the items as well as the groups for those items. For each of them, there are HANA views available

POSDTA POS Transactions settings

According to official support SAP Documentation, Those values provide the necessary bind keys for the views which select data from the following tables:

  • D007L (domains)
  • D007T (domains)
  • /POSDW/ITMS (classification of POS segments)
  • /POSDW/ITMST (classification of POS segments)
  • /POSDW/TRANT (transaction type)
  • /POSDW/TRANTYT (transaction type text)
  • /POSDW/REASON (retail reason)
  • /POSDW/REASONT (retail reason text)
  • /POSDW/RETTY (retail type)
  • /POSDW/RETTYT (retail type text)
  • /POSDW/TENDTY (tender type)
  • /POSDW/TENDTYT (tender type)
  • /DSMFD/ORDERC (order channel)
  • /DSMFD/ORDERCT (order channel)
  • /CAR/SALESDOCOC (sales document order channel)

From those tables you’ll find

Measures and Attributes

Some important measures are:

  • POS segments classification (POSSegmentsClassification) view : The view provides general data, such as the structure type, and the item category and subcategory.

  • Transaction type (TransactionType) view : The view provides general data, such as the profile type and transaction type code.

  • Retail type (RetailType) view : The view provides general data, such as the profile type and retail type code.

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.