Skip to Content

ABAP Program Giving SAPSQL_ARRAY_INSERT_DUPREC Dump While Inserting Entries

Hi Experts,

I had z table in which i had made three fields as primary key combination , i also had a custom program in which i am inserting values into the z table using Insert statement. during the execution of the program it is going for a short dump giving "SAPSQL_ARRAY_INSERT_DUPREC" With Exception CX_SY_OPEN_SQL_DB.

The Delivery Class of the Table is "C".

The thing is that i want if 1st field is "ORG ID" second Field is "Material" & the third field is "Type Id". then the system should allow entries like

-


ORG ID

Material Id

Type Id

-


|"0001" | "100'' | "R1" |

-


"0001"

"100''

"R2"

-


|"0001" | "100'' | "R3" |

-


"0001"

"100''

"R4"

-


Is there any OSS note for Corrections.

Thanks & regards

Priyesh Shah.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Oct 27, 2011 at 04:03 PM

    Did u check if the table already has the entries that you are trying to insert? You cannot insert a new row with the same key.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 27, 2011 at 06:15 PM

    Solved By Myself

    priyesh Shah

    Add comment
    10|10000 characters needed characters exceeded