topic Re: Insert internal table into datbase table in Application Development and Automation Discussions

Insert internal table into datbase table

Former Member — Tue, 11 Aug 2009 09:38:54 GMT

Hi,

I want to insert internal table into database table.

i have use following code


loop at it_header.
  INSERT ZTAB from table it_header accepting duplicate keys.
endloop.

but above code insert only first line not multipal.

Thanks in Advance.

Sam

Re: Insert internal table into datbase table

former_member404244 — Tue, 11 Aug 2009 09:41:08 GMT

HI,

Try this

MODIFY ZTAB from table it_header.

If sy-subrc eq 0.

Commit work.

endif.

Regards,

Nagaraj

Re: Insert internal table into datbase table

former_member188827 — Tue, 11 Aug 2009 09:45:57 GMT

first of all you dont need to use insert statement inside loop endloop.

secondly,

If the addition ACCEPTING DUPLICATE KEYS is specified, all rows are inserted for which this is possible. The remaining rows are rejected and sy-subrc is set to 4. The system field sy-dbcnt is set to the number of lines that are inserted. you must be passing values from internal table with same key as records of your ztable.that is shy system is inserting only one row.

Re: Insert internal table into datbase table

Mohamed_Mukhtar — Tue, 11 Aug 2009 09:46:12 GMT

Hi,


"Dont write this statment in LOOP....ENDLOOP
INSERT ZTAB from TABLE it_header[]  ACCEPTING DUPLICATE KEYS.
IF sy-subrc = 0.
MESSAGE 'Data Successfully saved into Database table' TYPE 'S'.
ENDIF.

Thanks

Re: Insert internal table into datbase table

Former Member — Tue, 11 Aug 2009 09:47:04 GMT

Hi,

You dont have to loop at it_header. You can directly use this


INSERT ZTAB FROM TABLE IT_HEADER ACCEPTING DUPLICATE KEYS.

Regards,

Vik

Re: Insert internal table into datbase table

MarcinPciak — Tue, 11 Aug 2009 09:49:38 GMT

accepting duplicate keys will prevent the program from dumping out. It will however not insert duplicating records as this violates DB restriction (only unique records can be stored in relational DB). But only one record (from two or three duplicating one) will be inserted in fact.

MODIFY (as suggested above) will handle the entires with same key in DB ( this is just insert+update statements in one ) but will also not solve it entirely, due to same reason.

Regards

Marcin

Re: Insert internal table into datbase table

Former Member — Tue, 11 Aug 2009 09:59:58 GMT

Hi,

Try to use Work Area in MOVE-CORRESPONDING statement.

Hope it is helps.

Saurabh Goel

Re: Insert internal table into datbase table

Former Member — Tue, 11 Aug 2009 10:05:12 GMT

Hi,

I have use your code.


INSERT ZTAB from TABLE it_header[]  ACCEPTING DUPLICATE KEYS.
IF sy-subrc = 0.
MESSAGE 'Data Successfully saved into Database table' TYPE 'S'.
ENDIF.

but it insert one record not multiple.

Thanks & Regards.

Sam.

Re: Insert internal table into datbase table

Former Member — Tue, 11 Aug 2009 10:06:42 GMT

Hi SAM,

Creating a SingleRecord -

>>>>

INSERT INSERT INTO <dbtab> VALUES <wa>.

Eg. DATAwa_spfliTYPEspfli.

...

wa_spfli-carrid = 'LH'.

wa_spfli-connid = '0007'.

wa_spfli-cityto = 'SINGAPORE'.

...

INSERT INTO spfli VALUES wa_spfli.

Fsy-subrc NE 0.

Creating Several Records---->>>>

INSERT <dbtab> FROM TABLE <itab>.

Eg.

DATA:it_spfli TYPE STANDARD TABLE OF spfli,

wa_itab LIKE LINE OF it_spfli.

...

wa_itab-carrid= 'LH'.

wa_itab-connid= '0009'.

wa_itab-cityto= 'HONGKONG'.

...

APPEND wa_itab TO it_spfli.

....

APPEND wa_itab TO it_spfli.

INSERT spfli FROM TABLE it_spfli.

IFsy-subrc NE 0.

....

Re: Insert internal table into datbase table

Former Member — Tue, 11 Aug 2009 10:11:50 GMT

Hi,

make sure that the records in the internal table it_header from where you are trying to insert do not contain data which has the key field values in the database table repeated. In that case 1 record will be added as the database has to main the database integrity of single record per key fields. Accepting duplicate keys prevents a runtime error, if removed you receive a dump that means you are trying to insert multiple records with the same key.

Hope this helps.

regards,

Sachin