Update was terminated when Post Goods Issue

[Former Member]

Hi all,

When I post goods issue, I receive a message "Update was terminated".

Then, I use SM13 to check update requests, I see an error

900 USERNAME 20.11.2007 10:47:27 VL02N

double click on that line I see error at module

8 MB_POST_DOCUMENT V1 Error

more details:

Row 13 in report LMBMBU04

00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Finally, Error occurr at line:

INSERT mkpf FROM TABLE zmkpf.

Can anyone help me to solve this problem?

Thanks.

[Former Member · Accepted solution]

Hi Nam,

This probelm is becuase you are trying to enter a record for which primary key already exists in the table.

The insertion you are doing with a set of values which already exist and sap is getting this error that the "Duplicate record during insertion". try to check your insertion values and through se16 check if they already exist in the table mkpf.

To rectify the data or else change the table and add one more unique to the primary key.

Abhishek Purwar

http://abhishek.purwar.googlepages.com

[Lakshmipathi]

Dear Nam

I feel from the error it could be due to material document number range.

Check in MBNK whether you have assigned number range for Goods Movement. I am sorry I am not sure about this but only a suggestion.

Thanks

G. Lakshmipathi

[Former Member]

Hi Nam

No one post for this thread??

[Former Member]

I have found SAP note: 782447.

But I'm using SAP ECC 6.0, this error must be fixed?

Is there another way to fix this error?

[Former Member]

But ABAPer didn't change this module.

[Manoj_Mahajan78]

Nam,

Still you tell him to check above report details from His side.

Regds

MM

[Former Member]

Please ask ur ABAPER it is due to some problem in Insert Statement use in ABAP program .

Please check with ABAPER he will solve it.