Show TOC

Process documentationDetermining Transaction Data Status Locate this document in the navigation structure

 

The POS In-Memory Analytics content allows you to perform analysis directly on the POS transactional data stored in the TLOGF table in the SAP HANA database.

In this process, you verify the transactional data stored in the database prior to querying it. As a result, a data status value is stored in the TLOGF table for each transaction. SAP POS DM maintains the data status of a transaction record:

  • During inbound processing and when the editor is started for a particular POS transaction within the POS Workbench.

    The data status is determined using the following BAdI, which is activated in the POS Inbound process by default:

    BAdI

    Implementation

    Transaction Data Enhancement Description

    POS Transaction Inbound Data Status Processing Enablement

    /POSDW/ANALYTIC_INB_DATASTATUS

    The data status is maintained for the 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  .

  • During task processing, using task 8003 Determine Transaction Data Status.

The data status of a transaction is set to one of the following values:

Data Status

Description

0 (Undefined)

This status is assigned to transactions on which no master data checks have been performed and no tasks have been processed.

1 (Error)

This status is assigned to transactions which fail a master data check or for which at least one processing task has resulted in an Error status.

2 (Master Data Check OK; No Tasks Processed)

This status is assigned to transactions that pass a master data check and for which no tasks have been processed.

3 (MD Check OK; One or More Tasks Processed, No Tasks in Error)

This status is assigned to transactions that pass a master data check and for which:

  • At least one task has been processed

  • All tasks that have been processed have no errors (not in Error state)

Prerequisites

  • SAP POS DM implemented on SAP NetWeaver BW powered by SAP HANA.

  • You have made the following settings in SAP POS DM 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 other task settings.

    • You have enabled the Data Status Relevant Flag under   Tasks   One-Step Processing   Define Tasks   for all tasks that process transactional data stored in the TLOGF table and which you consider to have impact on the data status.

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

    • You have defined a check profile to used for data status determination under   General Settings   Define Check Profiles  .

    • You have specified the identifier of a check profile in the Master Data Checks for Data Status Determination section of the   General Settings   Define Profiles   Customizing activity.

    • You have enabled the Checks Using Check Profiles checkbox under   General Settings   Define General Settings  .

      For more information , see Master Data Checks.

Process

Task 8003 Determine Transaction Data Status is available in the standard system for updating the data status of a transaction stored in the TLOGF table.

When using task 8003, we recommend that you also use rules to ensure that task 8003 is the last task to be executed on a transaction. For more information, see Task Processing.

Note Note

Manual task status changes in the POS Workbench are not detected by task 8003 Determine Transaction Data Status and will not trigger changes to the data status.

End of the note.