Skip to Content
0

Confusion on ECC Extractor Output (2LIS_11_V_SSL)

Jan 20, 2017 at 07:44 PM

184

avatar image

Hello Gurus,

I am facing in issue in my current project, let me explain you the system landscape first - We are having SAP ECC from which the data is flowing to SQL server using standard ECC Extractors (there is no BW in the picture). Now, let me try to clarify my issue with the help of examples.

Certain delivery document numbers were created in ECC as shown in the below attachment.

Now, after the partial delivery, when I checked my data source (2LIS_11_V_SSL), I could see the following in the delta queue.

Question

Now, I got confused on why i am getting 2 records for each delivery document (one with a X and one without for CANCEL INDICATOR. I think the records were not cancelled in ECC. Can anybody help me on understanding this? I think because of this, they are getting wrong data in their SQL server staging tables, which is as shown below.

Actual Final Quantity should be 4 for 50084, and 1 for 50019. But they are getting wrong values. Can anybody please help me on this?

Thanks a lot

Renju

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Raf Boudewijns Jan 24, 2017 at 07:07 AM
0

the entry with ROCANCEL = 'X' is the "before image", the other entry is the "after image"

I suggest you read up on this to understand how those extractors work...

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Raf,

Thanks for your reply.

But, according to my above screenshot, the user has created a partial delivery. Delivery 50084 (item 301) has initially 5 quantities, but he shipped 1 quantity from that via another delivery document no 50019.

In this case, we should get the below records from BW extractor

50084 301 -5 (before image)

50084 301 4 (after image)

50019 301 1 (after image)

But, instead of that, we are getting like below from the extractor-

50084 301 -4

50084 301 4

50019 301 -1

50019 301 1

This is where I am confused. Can you give me any inputs on this ?

Thanks

Renju

0
Raf Boudewijns Jan 27, 2017 at 07:49 AM
0

from your screenshots I can only see that you're extractor output (delta queue) looks fine, but it's not the same as your SQL server output

I have no clue what's going on in between...

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Raf,

Do you think that my extractor output (delta queue) is fine?? Can you please explain me how?

As I mentioned earlier, I have a delivery document (50084) with Qty 5 initially, and out of this, one unit was shipped via another delivery document (50019).

So, the delta queue should show the following right ?

50084 -5 (before image)

50084 4 (after image)

50019 1 (after image)

Am I right? If I am wrong, can you please correct me?

Heavily appreciate your precious time and support.

Thanks a lot

Renju

0
Frédéric Cincet Jan 27, 2017 at 04:20 PM
0

Your reasoning seems right to me.I guess you missed some delta records.

For instance, to make sense, the following underlined records (a before image) should have been preceded with the corresponding New or After image (if we receive a before image, there should have been a new image before):

Is this behavior reproductible on a new case ?

Regards,

Frederic


capture.png (62.1 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hey Frederic,

We tried it again and still getting the same output. Any idea why we are getting like this?

Also to note that, we are seeing this issue on Partial Delivery scenarios. We are trying this in Quality system and the functional consultant did the partial delivery using a program via IDOC. Is there anything related to this??

Thanks

Renju

0
RJ RENJITH Jan 30, 2017 at 03:33 PM
0

To be more specific towards my question, we have tried with 2 ways of doing partial delivery - 1, Manually and 2. using program.

We re-created the same scenario - We have a Delivery document (50084) with quantity 5, later it was reduced to 4 and shipped

1. Manual - We are getting the output in delta queue output properly by using manual method, but i believe that the users are not doing this in production.

50084 -5 (before image)

50084 4 (after image)

2. Using Program - We are facing the same issue in delta queue output.

50084 -4 (before image)

50084 4 (after image).


Can anybody help me on this ?

Thanks

Renju

Share
10 |10000 characters needed characters left characters exceeded
Frédéric Cincet Jan 31, 2017 at 08:14 AM
0

Ok, this was a good test.

You will have to look at the program (or Idoc), a part of the modification is lost by the delta queues. If this is a standard Idoc, raise a message, if not try to undestand why only some steps of the modification is reflected in the delta queue.

Regards,

Frederic

Share
10 |10000 characters needed characters left characters exceeded