2lis_11_v_ssl extractor and behaviour with rush orders

[Former Member]

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

[Former Member]

Mark,

I have exactly the same issue.

Besides having set up the keyfigures to summation do you have any code to handle the images in the start routine (of the transformation from 2lis_11_v_ssl to the ods) ?

Regards,

Magesh

[Former Member]

Magesh,

We have no code in the start routines to deal with the images.

We did think about this, but we could never be sure as to what data came in on the source packages from R3 (eg if there was an update delay etc).

By changing the rules in the DSO to summation from overwrite this issue is completely resolved.

Regards,

Mark

[Former Member]

We found that the issue was caused due to overwrite / summation issues for the key figures on the extractor.

This extractor only works if the key figures are set to summation.