Missing Documents numbers in LO delta extraction

[#1]

We are using SAP standard extractors to extract the data from ECC system.  the following extractors are used to extract the SD numbers in BW

2LIS_11_V_SSL

2LIS_11_VAITM

2LIS_11_VAHDR

Daily delta extractions are happening successfully however we observed that on 2 instances few documents both created on changed on related to sales header, line item and schedule lines were missed in delta even though the bihourly delta extraction were successful on that day. Also, we noticed few billing documents which are extracted using 2lis_13 extractors are also missing for SD documents changed or created on the same days.

The deleted records were also missed in Delta as these are not updated in application table, so we are not able to recover the same.  Is there is any solution to recover the deleted records and update record deletion flag in BW. We have investigated on ECC end the LBWQ, SMQ1 and RSA7 and we could not find any documents stuck in the queue but found no failures.

Your immediate help is highly appreciated.

[Colin4]

Hi,

Based on my experience with SD, I believe the below may be the issue.

Check notes 178328 & 208010.

In sd userexits, the code works with X & Y
tables, both tables
have to be maintained. What happens usually is that
customers update the X and forget the Y table.

449137 BW extraction SD: Extracting documents without changes
757361 Additional data records in BW when document changed
216448 BW/SIS: Incorrect update / SD user exit
901512 - User exits in Sales Order Processing

When deleting and saving the document, place a breakpoint in the
below programs.
SD Userexits on the application side (Application 11)
MV45AFZZ,
MV45AFZA
MV45AFZB

userexit_save_document_prepare

here the X and Y tables should be filled.

SD Billing Userexits on the application side (Application 13)

RV60AFZZ
RV60AFZA
RV60AFZB

SD Delivery Userexits on the application side (Application 12)

MV50AFZ1 User Exit as of 21D for Delivery Processi
MV50AFZ2 User Exit for Batch Determination
MV50AFZ3 User Exit Delivery Processing for 3.0A Us
MV50AFZK
MV50AFZL
MV50AFZP
MV50AFZT
MV50AFZZ User Exit for Batch Determination

415716 - User exits in delivery processing
901992 - Goods issue posted without being updated in BW

FM called to update queue
MCEX_UPDATE_CALL_11

regards,

Colin