Skip to Content
0

problem of duplicate POS DW transaction numbers

Jun 06, 2017 at 10:04 AM

52

avatar image

Hi,

We have a problem with duplicates of POS transactions in POS DW module. Our landscape consist of three elements:

1) external system (cashes of our stores, who is sending the cheques)

2) SAP XI

3) SAP BW (POS DW component)

The cheque workflow is: "cash of store" -> "SAP XI" -> "POSDW". Sometimes, external system send the same cheque twice or thrice. And it is impossible to fix it.

The POS DW transaction number consist of three positions: "NNN.NN.NN", i.e. "cash.shift.cheque" numbers. And belong to certain posting date and certain store.

For example: cheque 101.99.20 by date 05.06.2017 and store Z1006. It CAN NOT be duplicated within the same "posting_date - store". But for DIFFERENT stores for the same posting date it may well.

The goal is to make control of POS DW transactions, so that eliminates the possibility of duplicates. Ideally, mark these duplicates in red ( /POSDW/MON0 ). Here is a screenshot of duplicates:

In POS DW I found the task "1001 - Check for Duplicate Transaction Numbers" which allegedly controls the duplicates. SAP article:

https://help.sap.com/saphelp_car100/helpdata/en/5c/63c4520c89a81ae10000000a44538d/content.htm

But I did not found, how it is to control that. By period? By store? Or completely through all of them?

We don't have the development system for SAP BW, therefore we can't do any tests. Maybe, someone faced with similar task. We will appreciate, if you comment this task "1001", or will offer your own method of control dublicates.

Best regards,

Sergey Hrapovitsky

uuo3b5pyqzo.jpg (103.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sergey Hrapovitsky Jun 23, 2017 at 02:16 AM
0
Share
10 |10000 characters needed characters left characters exceeded