topic Insert Queries Which Insert Duplicate Data Into Database in Application Development and Automation Discussions

Insert Queries Which Insert Duplicate Data Into Database

Former Member — Tue, 11 Sep 2007 12:55:36 GMT

Dear Sir,

I Have One Issue That in My Internal Table Same VBELN(Keyfield)Field Has Three Different Rows Conating There Diiferent Data. I want The Three Rows Should Be Insert In database Table With Specified Key(VBELN).

Can Anybody Help me...

internal table coming in folowing format--

VBELN matnr maktx meins

123 hghjfd hfg kg

123 iotuyt jki pc

123 9867ii bnm pc

I want All Rows should be saved in database ztable ..

what is sql queries i have written...plz help me...

Re: Insert Queries Which Insert Duplicate Data Into Database

Former Member — Tue, 11 Sep 2007 13:32:02 GMT

Hi,

You can not insert the duplicate record in the table with the same primary key.

If you want to insert multiple rows in the database having same value of VBLEN, then dont mark that field as a key.

The syntax of sql is something like this.

insert <table_name> from table <itab_name>.

Hope this will help you.

~ Ramanath.

Re: Insert Queries Which Insert Duplicate Data Into Database

Former Member — Tue, 11 Sep 2007 13:38:12 GMT

Hi,

If the DB table has VBELN as the only key field(other than MANDT) then you cannot do that.

If it has some other key field as well then you can do so by using INSERT statment.

INSERT <DB tablename> from <internal table name>

Regards,

Amit

Message was edited by:

Alvaro Tejada Galindo

Re: Insert Queries Which Insert Duplicate Data Into Database

Former Member — Tue, 11 Sep 2007 20:40:04 GMT

You'll have to change the table to include MATNR as well as VBELN as the primary key.

Rob