topic Re: Update terminate during return sales order creation (Delivery processing) in Application Development and Automation Discussions

Update terminate during return sales order creation (Delivery processing)

roger_colaco2 — Fri, 21 Aug 2009 15:52:49 GMT

Hi,

I have having issues with a scenario while creating delivery in a 4.7 system. When creating a return order (using FM SD_SALESDOCUMENT_CREATE) our system is configured to automatically generate deliveries for the return SO.

The scenario we are facing an issue in is, during data processing, a delivery is created using FM W_FRM_DELIVERY_CREATE_GENERAL, delivery is then processed for picking and PGI using FM WS_DELIVERY_UPDATE.

For the next record, a return order is created using FM SD_SALESDOCUMENT_CREATE, which also automatically tries to create the delivery. At this point we get an update terminate upon COMMIT and dump says SAPSQL_ARRAY_INSERT_DUPREC pointing towards form VBFA_BEARBEITEN.

Based on my analysis, while updating table VBFA the internal table DA_XVBFAI also has document flow for the previously processed regular sales order for which the system tries to insert a record in VBFA. This is a duplicate record and the update is terminated. The buffer nees to be refreshed and I tried using FM SHP_DELIVERY_BUFFER_REFRESH and LE_DELIVERY_REFRESH_BUFFER. None of these seem to refresh the VBFA buffer.

I would appreciate if anyone can share their experience with this issue. Thanks for your help!

-Roger

Re: Update terminate during return sales order creation (Delivery processing)

jaideepsharma — Fri, 21 Aug 2009 16:27:56 GMT

Hi,

Try using one of these function modules BUTX_FRG0010_CLEAR_BUFFER or CK_F_SHARED_BUFFER_DELETE or COM_IL_DB_RESET_BUFFER or SNC_USER_FLUSH_BUFFER .

KR Jaideep,

Re: Update terminate during return sales order creation (Delivery processing)

roger_colaco2 — Fri, 21 Aug 2009 19:46:07 GMT

I checked these functions and none of these refresh the delivery buffer.

Re: Update terminate during return sales order creation (Delivery processing)

roger_colaco2 — Wed, 02 Sep 2009 17:54:56 GMT

This issue was resolved by calling function RV_DELIVERY_INIT

Re: Update terminate during return sales order creation (Delivery processing)

Former Member — Thu, 28 Jul 2011 06:13:59 GMT

May I know how you used this fm as right now we also encountered the problem of SAPSQL_ARRAY_INSERT_DUPREC during the delivery processing.

Thank you.

Re: Update terminate during return sales order creation (Delivery processing)

Former Member — Wed, 22 Jan 2014 14:15:08 GMT

Hi Roger, you resolved my question, thanks very much

Re: Update terminate during return sales order creation (Delivery processing)

former_member733573 — Fri, 26 Mar 2021 05:27:53 GMT

This suggestion solve my problem too. I used FM BAPI_CUSTOMERRETURN_CREATE to create Sales Document and Delivery, But I was getting an error because delivery is saved in update tasking. I have tried a lot of solution and FM. But this one solved my problem. Tks.

Re: Update terminate during return sales order creation (Delivery processing)

Manuel_Hurtado — Thu, 13 May 2021 21:58:08 GMT

Me too, solved with RV_DELIVERY_INI just before of call bapi.