CK40N Error during Explosion

[Former Member]

Hi All,

While doing BOM Explosion ( CK40N) level 0, we get an error "SAPSQL_ARRAY_INSERT_DUPREC" ...."The ABAP/4 Open SQL array insert results in duplicate database records.....

Any idea on what is causing this Error....

Thanks for your help.

[Former Member]

Hi,

Between the selection and the structure explosion you might have changed the quantity structure.

Make sure that the quantity structure is not changed between the selection and the structure explosion.

Restart the selection and then execute the structure explosion. Please let me know the result.

Regards,

Dr. Ravi Surya Subrahmanyam, PhD Finance

Manager SAP Practice

The Hackett Group India Ltd

[Former Member]

Hi Vijoy,

Please let me know how this was resolved. I read the note and i did not understand how to fix it.

Thanks.

Preetham S

[former_member188826]

Make sure that the quantity structure is not changed between the selection and the structure explosion.

Restart the selection and then execute the structure explosion.

[Former Member]

There a 11 notes listed on OSS for key words CK40n and

SAPSQL_ARRAY_INSERT_DUPREC

Most seem to deal with materials with no cost and corrections are listed.

Review them and see if any fit your situation .

award points if helpful