Queue failure"The document cannot be deleted” caused due to deletion of EWM delivery for LE delivery

[PrasannaG]

Introduction:

A failed Queue with an error message as “The document cannot be deleted” occurs in SAP EWM whenever we delete EWM delivery for a Logistic execution delivery with the status as Distributed. 

Process leading to Queue Failure:

Step 1: Logistic execution outbound delivery created and distributed to EWM.

Step 2: EWM delivery deleted:

a) Select the line tem and then click on the edit option.

b) Then click on the delete option.

Step 3: Queue Failure occurs with the error message “The document cannot be deleted.”

Solution:

To process the failure queue, we have two options:

Option 1:

1. Required to change the value of LIKP table field VLSTK from B (Distributed) to space  (Not Relevant) for the delivery in debugging mode using transaction code /h
2. Change the LE delivery quantity to Zero and reprocess the failed Queue.

Option 2:

1. Need to change the value of LIKP table field VLSTK from B (Distributed) to space (Not Relevant) for the delivery using SQL query.

         [select VBELN, VLSTK from LIKP where VBELN IN ('0511540000');

         update sapabap1.LIKP set VLSTK='' “ where VBELN IN (('0511540000');]

     2. Change the LE delivery quantity to Zero and reprocess the failed Queue.

Option 1 Process:

Step1:

Need to change the value of the LIKP table field VLSTK from B (Distributed) to space (Not Relevant) for the delivery in debugging mode using transaction code /h.

Go to Transaction code SE16, enter the table LIKP, and provide the outbound delivery 511540000.

Click on Icon ‘Execute’

Step 2: Keep the Cursor on the Delivery line item and Click on “Display’ as shown above.

Click on ‘Next Screen’

The value B (Distributed) is displayed for the field VLSTK.

Step 3: To change the value of the LIKP table field VLSTK from B (Distributed) to space (Not Relevant) for the delivery, enter the transaction code /h and click on the enter key twice.

The debugger screen is displayed.

In the debugger screen, click on show in the code.

Then click on the change content option, change the value from “SHOW” to “EDIT,” and click on the enter key.

The LIKP table is displayed automatically with the field values in editable mode.

Then, change the value for VLSTK from B (Distributed) to Space (Not Relevant) and click the save button.

Step 4: Change the LE delivery quantity from one to Zero.

Reprocess the failed Queue.

Delivery 511540000 is deleted.

Conclusion:

Failed Queue with an error message: “The document cannot be deleted” is processed.