topic Re: Append records to datatable in Application Development and Automation Discussions

Append records to datatable

Former Member — Fri, 05 Jan 2007 05:18:10 GMT

Hi ,

I created a datatable in SE11 with 4 columns and i need to update data into it using ABAP can u please help me on this.

Regards,

naveen

Re: Append records to datatable

Former Member — Fri, 05 Jan 2007 05:21:16 GMT

it is standared table or ztable if it is ztable make maintinance view and upload data...

Re: Append records to datatable

Former Member — Fri, 05 Jan 2007 05:21:27 GMT

Hi Naveen,

You can use the command INSERT <dbtab> FROM TABLE <itab> to create several rows in a database table.

The internal table <itab> that you should specify here must have the same line structure as the corresponding database table and the new data records. The client field that might exist in the internal table <itab> will only be taken into consideration if the CLIENT SPECIFIED addition is specified. If there is no CLIENT SPECIFIED addition, the current execution client applies. If it is possible to create all the lines, sy-subrc is automatically set to zero.If, however, even one data record cannot be created, a runtime error occurs. This means that the entire insertion operation is discarded (database rollback). If, in such a case, you want to have records that can be inserted actually inserted, use the command addition ACCEPTING DUPLICATE KEYS. If there is an error, this addition suppresses the runtime error (and thus also the database rollback), sets the return code (sy-subrc) to 4, and inserts all the records without errors.The sy-dbcnt system field contains the number of rows that were successfully inserted in the database.

Regards,

Balaji Reddy G

***Rewards if answers are helpful

Re: Append records to datatable

jayanthi_jayaraman — Fri, 05 Jan 2007 05:25:56 GMT

Hi,

If you want to insert records into database table,

data : itab type standard table of ztable,

wa type ztable.

wa-f1 = 'ABC'."some valid value according to your fields

wa-f2 = 'CDE'."some valid value according to your fields

wa-f3 = 'EFG'."some valid value according to your fields

wa-f4 = 'GEH'."some valid value according to your fields

append wa to itab.

...."append similarly other records

insert ztable from table itab.