topic Dump in insert statement in Application Development and Automation Discussions

Dump in insert statement

Former Member — Sun, 16 Jul 2006 08:55:24 GMT

INSERT ZTABLE FROM TABLE FINAL.

ZTABLE CONTAINS 9 ENTRIES.

FINAL- INTERNAL TABLE CONTAINS ONLY THE KEY ENTRIES.

I have populated only the key entries (5 entries) in the internal table, I dont want rest of the four entries to get inserted into the ZTABLE.

Thanks in advance,

Vivenchandar R.

Re: Dump in insert statement

Former Member — Sun, 16 Jul 2006 09:06:57 GMT

What does the DUMP gives as the error.

Regards,

Ravi

Re: Dump in insert statement

Former Member — Sun, 16 Jul 2006 09:45:48 GMT

If you want to modify the non key feilds of the table please use the update statement.

If you only wish to enter new records in the transparent table use Insert statement.

Simple but performance inefficient way is to use a modify statement. It will insert new records and update existing records.

Re: Dump in insert statement

Former Member — Sun, 16 Jul 2006 09:55:00 GMT

Check if there you are trying to create a duplicate record with the same key.

Also, check if the field formats are the same.

Regards,

Sandeep

Re: Dump in insert statement

muhammed_nishad — Mon, 17 Jul 2006 03:49:12 GMT

hai,

I suppose your internal table has more than one record with the same key,in such case you could use "accepting duplicate keys".

what it does is ,it will insert the vaild entry with the key for the first time,if your internal tavble contains more than one record with the same key ,it will ignore.

START-OF-SELECTION.

wa_test-fileno = '3334'.
wa_test-status ='X'.

***

APPEND wa_test TO it_test.

***

INSERT z01test1 FROM TABLE it_test ACCEPTING DUPLICATE KEYS.

***

IF sy-subrc <> 0.
MESSAGE 'not insterted' TYPE 'I'.
ELSE.

INSERT z01test1 FROM TABLE it_test ACCEPTING DUPLICATE KEYS.

IF sy-subrc <> 0.
MESSAGE 'not insterted2' TYPE 'I'.
ELSE.
MESSAGE 'insterted2' TYPE 'I'.
ENDIF.

try wiht this , hope this will help you

thank you .