Skip to Content
0
Former Member
May 13, 2009 at 08:23 AM

Insert values into DB Table

85 Views

Hi Guys,

I am trying to insert values directly in DB table using Insert statement.

Here is the example code.

INSERT zsd_ord_conf_log FROM TABLE it_log ACCEPTING DUPLICATE KEYS.

  • LOOP AT it_log INTO wa_log.

  • INSERT into zsd_ord_conf_log values wa_log. "ACCEPTING DUPLICATE KEYS.

  • COMMIT WORK.

  • CLEAR wa_log.

  • ENDLOOP.

I try both ways above, It insert one only record initially after that, its not allowing any.

MANDT is the only primary key in this table.

Is it anything I need to maintain at the technical settings.

Thanks