topic Re: Dump at INSERT Statement in Application Development and Automation Discussions

Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 09:20:24 GMT

Hello All,

Im reading data from a local file to a internal table. The internal table is also getting populated with those values. With this internal table Im inserting records into a Database Table. This internal table is having same structure as Database table.

But Im getting the following dump.

"RSQL error 13 when accessing table "Y16V_AO_LEVEL_IN ".

Plese find my code beow:

DATA: G_T_Y16V_AO_LEVEL_IN TYPE TABLE OF
          Y16V_AO_LEVEL_IN WITH HEADER LINE.

      INSERT y16v_ao_level_in FROM TABLE g_t_y16v_ao_level_in.

Good answers will be appreciated.

Thanks in advance.

Best Regards,

Sasidhar Reddy Matli.

Re: Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 09:24:17 GMT

You need to specify all the fields present in database table and put the data in all fields before inserting the data...

Paste some more piece of code wherein you are moving the data to the database table before insert statement...

Also, correct the code as

Insert into <database table> from table <workarea>.

Re: Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 09:24:48 GMT

Hi,

Check whether database table structure is same as internal table. Also there might be the data present with same key field.

Thanks.

Swati

Re: Dump at INSERT Statement

Sathish — Tue, 23 Sep 2008 09:26:28 GMT

Use

INSERT INTO dbtab FROM TABLE itab_wa.

Re: Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 09:29:53 GMT

Hi,

The dump might be because of duplicate entries or records have the same key fields in the table with your using to insert.

Thanks & Regards

Vijaya

Re: Dump at INSERT Statement

naveen_inuganti2 — Tue, 23 Sep 2008 09:31:46 GMT

Hi...

Declare one work area and try to upload the entries.

Or..,

This may occurs because if you try to update the same file second time.

Hope you understand with following analysis..,

If you use an ABAP/4 Open SQL array insert to insert a record in
 the database and that record already exists with the same key,
 this results in a termination.

Thanks,

Naveen.I

Re: Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 09:39:05 GMT

your query is correct.But the problem is data while yoy are inserting into the table it violates the key relation.

Here there might be two reasons

1.Already some data might be there in the table with same key fields which you are going to insert from the internal table

2.Otherwise in your internal table some duplicate records may be there

regrads

venkat

Re: Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 09:39:24 GMT

Dear Sasidhar,

try this

Tables: ZEMP.

DATA: BEGIN OF ITAB OCCURS 0,

NAME TYPE ZEMP-NAME,

END OF ITAB.

DATA: WA LIKE LINE OF ITAB.

UPLOAD ALL THE DATA INTO ITAB.

LOOP AT ITAB INTO WA.

ZEMP-NAME = WA-NAME.

INSERT ZEMP.

COMMIT WORK.

CLEAR WA.

ENDLOOP.

Re: Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 09:55:15 GMT

hi,

it may be due to duplicate entries or records have the same key fields in the table .

you can use modify statement insead of insert.

Re: Dump at INSERT Statement

Former Member — Tue, 23 Sep 2008 13:31:40 GMT

I can suggest u donot use INSERT statement but use MODIFY Statement so that if that record exist then the previous record is to be modified .and not exist then it will be inserted in the table.

rewards if useful..

regards

Sachhi