Supplying POS In-Memory Analytics with Distributed Transaction Data

In this process, you distribute the discount, tax, and tender information contained on the header level of a POS transaction to the individual transaction line items. This distribution reduces the execution time of POS In-Memory Analytics queries.

Caution Caution

The distribution performed in this process assumes a standard implementation of the SAP POS DM and does not take into consideration any custom sales item types or distribution requirements. Distribution can significantly impact analytic reports built on POS In-Memory Analytics Content; ensure that the standard distribution calculations fulfill your business requirements.

End of the caution.

By default, the distribution is performed during the POS Inbound process by the following activated BAdI:

BAdI

Implementation

Transaction Data Enhancement Description

POS Transaction Data Distribution to Item Level

/POSDW/ANALYTIC_DIST_ITEM_IMP

The discount, tax, and tender information contained on the header level of a POS transaction is distributed to the individual line items. The distributed figures are stored in dedicated fields of the /POSDW/TLOGF table.

The distribution is performed based on the line item's sales amount within a transaction as follows:

line item discount amount = transaction discount amount * [ | line item sales amount | ÷ (sum of all | transaction line item sales amounts |) ]
Discounts are not distributed to line item types for which the Remove f. Distr. of Header Discounts option of the POS Inbound Processing POS Transactions Define Sales item Types Customizing activity is enabled.
line item tax amount = transaction tax amount * [ | line item sales amount | ÷ (sum of all | transaction line item sales amounts |) ]
Excluded taxes are not considered in the distribution. In the SAP POS DM Customizing under POS Inbound Processing→ POS Transactions→ Define Tax Types, use the Tax Included checkbox to specify if a tax type is “included” or “excluded”.

Furthermore, taxes are not distributed to line item types for which the Remove Item fr. Distr of Header Tax option of the POS Inbound Processing POS Transactions Define Sales item Types Customizing activity is enabled.
line item tender amount = transaction tender amount * [ | line item sales amount | ÷ (sum of all | transaction line item sales amounts |) ]
Tenders are not distributed to line item types for which the Remove from Distribution of Tender option of the POS Inbound Processing POS Transactions Define Sales item Types Customizing activity is enabled.

Note Note

Absolute values are used for the line item and transaction sales amounts to ensure that the ratio between the two results in a positive value.

End of the note.

If you disable the execution of this BAdI during the POS Inbound process, you can still perform the data distribution by using task 8002 Supply Analytics Cont. with Distributed Transaction.

For more information about the BAdI listed above, see its accompanying documentation in the Customizing under Customer-Specific Enhancements and BAdI Implementations Enhancements for In-Memory Analytics .

Prerequisites

SAP POS DM implemented on SAP NetWeaver BW powered by SAP HANA.
If you are using task 8002 Supply Analytics Cont. with Distributed Transaction, you have made the following settings in PIPE Customizing:
- You have set the Type of Task to be carried out under Tasks One-Step Processing Define Tasks as required for your implementation and you have checked the correctness of the other task settings.
- Under POS Transactions , you have checked the task group that is assigned to the relevant POS transaction and you assign a task group if required.
- You have ensured that the task group, which is assigned to the transaction type of your POS transaction, exists under Tasks Define Task Group .
- You have ensured that the task to be carried out is assigned to the relevant task group under Tasks Assign Tasks to Task Group .

Process

By default, the BAdI implementation for data distribution is activated in the POS Inbound process.

If you have chosen to deactivate the BAdI implementations for data distribution, you can use task 8002 Supply Analytics Cont. with Distributed Transaction Data to perform the data distribution on transactions in the TLOGF table. For more information, see Task Processing.