Hi All,
I hope someone can help us with this issue.
We have standard sap extractor 2lis_11_v_ssl which pulls data into BI 7.0 into the PSA and then onto a dso (all v7 functionality).
For standard sales orders, all works perfectly. However, for rush sales orders we have issues.
The target DSO has as it's key sales order, sales order item, delivery and delivery item.
For a normal sales order in the delta queue we see the following sequence of records:
1) Sales Order Creation (only sales order and sales order item key parts filled)
2) Delivery Creation (sales order, sales order item, delivery and delivery item key parts filled)
3) Sales Order Creation cancellation image (sales order and sales order item filled and rec_deleted = X)
In the DSO we end up with 2 records - basically records 2 and 3. In our reports we use the rec_deleted flag = X to ignore those records.
For a rush sales order, the records end up in the delta queue in a different order. I presume this is because on sales order save, both the sales order and delivery are created at the same time - presumably the delivery save process completing first? We see this:
1) Sales Order Creation cancellation image (sales order and sales order item filled and rec_deleted = X)
2) Sales Order Creation (only sales order and sales order item key parts filled)
3) Delivery Creation (sales order, sales order item, delivery and delivery item key parts filled)
In our DSO, we end up with records 2 and 3 again - BUT - the rec_deleted flag = X from record 1 has been overwritten. This means the records are no longer ignored in our reports and we have double counting on several key figures (confirmed qty etc).
Has anyone seen this before? Can anyone suggest any ways in which we can solve this?
Many thanks in advance.
Mark