Dear Friends,

There had been very limited help available for SAP POS Data Management (POS DM) for the person who is new to it. So this is just an attempt to provide a quick guide for the most desired feature in POS DM.

There are always instances where the transactions are transferred twice to POS DM due to various network related reasons. It is very much essential that we check the transactional data for duplication to avoid same transactions posted twice to ECC. This document demonstrate the steps to be taken to implement the duplication check in POS DM for transaction data.

In POS DM, all the processing are being executed by means of tasks. There are various tasks to be configured in order to aggregate the POS data and generate WPUTAB and WPUUMS IDoc for Collection and Sales respectively. To implement the duplication check in SAP POS DM, we can use task 1001 which standard SAP task. I am considering the following logic for my document to fulfill the duplication check.

  • When a new transaction is created in TLOGS, I will do the Sales audit in which I will validate whether the collection total and item total are same or not. This is to make sure that I am not processing the task which are not properly transferred as a whole.
  • Once the Sales Audit is completed, I will check whether the transaction is duplicate or not.
  • If the output duplication check is successful (means it is not duplicate), I will execute 0013 and 0014 task to create the IDocs.

Below steps are given by keeping the above logic. You can configure as per your requirement. The other alternative will be first check the duplication check followed by a Sales Audit task.

Please note that the duplication check will check for the combination of Store ID, Transaction Date, POS No, Transaction Number. If this combination is repeated, the transaction will be marked as duplicate.

Launch POS DM customizing environment by transaction code /POSDW/IMG.

Our first prerequisite is before we execute the duplication task (1001) we need to check whether the Sales Audit task (0002) is successful or not. There is a standard rule (0003) already available in POS DM which will indicate the status of Sales Audit task. Please see the below figure showing rule for Sales Audit.

Path: POS DM IMG: POS Data Management -> POS Inbound Processing -> Tasks -> Define Rules

SCN1.png

Next step is to use this rule code in our duplication task (1001). Navigate to standard configuration of task 1001 to attach this rule code. By attaching this rule code to task, we are ensuring that if the Sales Audit task is completed then only carry out duplication check.

Path: POS DM IMG: POS Data Management -> POS Inbound Processing -> Tasks -> One-Step Processing -> Define Tasks

SCN2.png

Select the duplication task 1001 for your profile and click on Details button on the toolbar.

SCN3.png

Following settings are required for task 1001. Please note below points.

  • For field Type of Task, we need to select Immediate Processing as we want to carry out the duplication check immediately after the transaction is created in TLOGS. There are some tasks for IDoc generations which are executed in batch mode. But for this, it will immediate processing.
  • In Rule code, we need to select 0003 rule which is to check the status of Sales Audit task. This will ensure that the task 1001 will be executed only if the output of rule 0003 is Successful.
  • Finally, we need to attach the filter for Precond BAdi. Please assign 0001 which is Check for Duplicate Transaction Numbers.

This completes the configuration of Duplication task and its prerequisite. Next step is use the status of Duplication task to carry out the next status.

For this, we have to create a rule in which we will mention that if the duplication check is positive (means it is duplication), the transaction should go in Error status otherwise it should be Completed status. To define this logic, let us configure our own rule in POS DM.

Path: POS DM IMG -> POS Data Management -> POS Inbound Processing -> Tasks -> Define Rules

SCN4.png

In this screen, click on New entries and configure you rule as per the given image below.

SCN5.png

In the rule definition we need to do the following settings.

  • First select the Rule Type. We need to select the value as Task Completed as this rule is a stand alone task and not used in combination.
  • In Control screen, Task for Rule Type 1, we need assign 1001 as the rule is being created for task 1001 which is duplication check.
  • We want that if the duplication check is fail, the transaction should go in Error status. For this we need to define the No Action filter. As failed duplication check to be acted with No Action. Assign action 0003 which is Error in POS Transaction. This assignment will ensure that duplication check failure will send the transaction in error status to avoid further processing.

Once the duplication check is passed, the transaction is to be executed for IDoc generation. For the same, please configure the task 0013 (Generate WPUAB IDoc) as per given image.

SCN6.png

Please see the encircled setting. We are making sure that the task 0013 should be executed only if the rule Z001 which we created above is successful. Save your settings.

Similarly you can configure task 0014 which is Generate WPUUMS IDoc.

Finally assign at least these 4 tasks to your profile.

  • 0002 – Sales Audit
  • 1001 – Duplication Check
  • 0013 – Generate WPUTAB IDoc
  • 0014 – Generate WPUUMS IDoc

Apart from this various other tasks can be configured as per the client’s requirement

This way you can achieve the duplication task implementation. If there are any duplicate transactions, the task overview will show an error. You can check the execution of this task. Open POS DM workbench and see the error transaction. If the transactions are duplication, the same will be recorded in the workbench. Select your transaction and click on Messages button.

SCN7.png

From error message you will see that the tasks are failed due to same POS No and Transaction Number combination.

SCN8.png

If you check the Task overview of this transaction you will see that task 0013 and 0014 are not processed due to failed status of 1001 task.

SCN9.png

This is the end of duplication check implementation and its confirmation that it is working.

I hope this will help our POS DM consultants as quick guide.

Thanks & Regards – Amit

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Venkatesan Balakrishnan

    Hi Amit, Very helpful document. Thank you!

    I have a question on 0RT_PA_TRAN_GDS_MOV data loading. I am able to configure it and executed the task ‘3001 – Inventory look up task’. Task execution was successful, but data are not getting loaded into the data source ‘0RT_PA_TRAN_GDS_MOV’. Do you have any idea about it?

    Thanks,

    Venkatesan.

    (0) 
    1. Amit Tunara Post author

      Hi,

      Please make sure that all these BI cubes are activated to receive the data.

      Let us know if you need any other information.

      Regards,

      Amit

      (0) 
  2. Venkatesan Balakrishnan

    Hi,

    Can we use the standard filter ‘0001 Check for duplicate transaction’ when creating task itself?

    Is there any difference between creating new rule and using the standard? Please help to understand.

    Thanks,

    Venkatesan

    (0) 
  3. Ramesh Duraisamy

    Hi Venkatesan,

    Yes, we can use the standard filter, when creating task.

    It wont make much difference creating new rule and using standard.

    Thanks and Regards,

    Ramesh D

    (0) 
  4. Arturo Santos

    Hi.

    When we have a duplicated transaction, it is marked as error. However, it affects the amount of total value, because the sum per mean of payment is affected twice.

    For example, if we duplicate a transaction for the cashier Johnny Walker with cash of $5.00, when go to MON0, Inbound monitor, posting date, store, total records, select Johnny Walker, and Balancing, the total value is $10.00 ($5 * 2).

    May someone help me about how can we avoid this situation? We need the total value to consider just transactions not duplicated.

    Best Regards

    Arturo Santos

    (0) 
  5. Sharmi G

    Hi,

    When i give the rule type Z001 under task wpuums and wputab then the transaction goes in error status for not duplicate transaction.

    Like for single transaction the task will be  in error. what is the issue?how can i process single transaction which dont have duplicate?

    Thanks,

    abaper

    (0) 

Leave a Reply