Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

UPDATE termination in VA01 transaction.

Hello Experts,

I am stuck in one place. could you please help me for the same.

I am uploding data in ZVA01 transaction using batch input session.

while uploading 82-83 line items, and save it, i am getting the error. "SAPSQL_ARRAY_INSERT_DUPREC".

i checked the error. it is from the include :LV45UF0K and this is the standard code.

the code is given below :

FORM KONV_BEARBEITEN.

CHECK: FKONV_GEAENDERT NE SPACE OR

VORGANG = CHARH.

IF VORGANG NE 'H'.

DELETE FROM KONV WHERE KNUMV = VBAK-KNUMV.

ENDIF.

LOOP AT FXKOMV.

FXKOMV-MANDT = VBAK-MANDT.

FXKOMV-KNUMV = VBAK-KNUMV.

MODIFY FXKOMV.

ENDLOOP.

INSERT KONV FROM TABLE FXKOMV.

IF SY-SUBRC NE 0.

MESSAGE A100 WITH 'KONV' SY-SUBRC.

ENDIF.

ENDFORM.

. error is : it is try to insert the duplicate entry in the KONV table. i dont know why the error is comming and in which code the error is.

i splitted the line items into 2-3 parts and then uploaded, this time it is uploading properly.

i want to upload all line items in one time (82-83 line items).

could you please suggest, what is the error ?.

Thnaks in advance.

RH

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question