topic Re: How to Move data into user-defined dbTable in Application Development and Automation Discussions

How to Move data into user-defined dbTable

Former Member — Thu, 16 Jun 2005 16:15:51 GMT

hi dudes,

I am new to ABAP programming and have a question. I know how to create internal tables and the dB tables.(Also to manipulate data in internal tables) Now i need to know how we can push data which is in the internal table into a dbTable? Can anybody help me out.

thanks,

anand.

Re: How to Move data into user-defined dbTable

Former Member — Thu, 16 Jun 2005 16:21:13 GMT

Hi Anand,

Please post this question in the ABAP Programming forum.

Thanks,

Kathy Meyers, SDN

Re: How to Move data into user-defined dbTable

Former Member — Thu, 16 Jun 2005 16:22:16 GMT

here's the link:

Re: How to Move data into user-defined dbTable

RichHeilman — Thu, 16 Jun 2005 16:42:19 GMT

It really depends on how the db table is structured and how your internal table is structured. If they are the same, then its this easy.

Data: itab like ztable.

INSERT ztable FROM TABLE itab.

Otherwise you will have to do a little more coding.



data: begin of itab occurs 0,
      f1 type c,
      f2 type c,
      f3 type c,
      end of itab.


loop at itab.
move-correponding itab to ztable.
insert ztable.
endloop.

Regards,

Rich Heilman

Re: How to Move data into user-defined dbTable

jayanthi_jayaraman — Fri, 17 Jun 2005 03:48:22 GMT

Hi,

Here I am suggesting one way.In this program,I assumed that zzz_mara is a table which is having some fields of mara table.I am selecting all the records from mara table into an internal table itab and then pushing those data in internal table itab1 and then inserting those records into zzz_mara table.

data : itab type standard table of mara,"internal table

itab1 type standard table of zzz_mara,"internal table for custom table

wa type mara,

wa1 type zzz_mara.

select * from mara into table itab .

loop at itab into wa.

move-corresponding wa to wa1.

append wa1 to itab1.

endloop.

INSERT zzz_mara FROM TABLE itab1.

Hope this helps you.

Regards,

J.Jayanthi

Re: How to Move data into user-defined dbTable

Former Member — Fri, 17 Jun 2005 06:00:53 GMT

Hi,

To be on the safer side you can use 'Modify' to insert/update entries into ztables from an internal table, if the internal table has some duplicate key fields then the insert gives a short dump, to avoid the dump we use Modify.

Modify acts like an insert & update depends on the scenario, the logic is similar to insert,

Modify dbtab from table itab.

Hope this helps,

Rgds,

Re: How to Move data into user-defined dbTable

Former Member — Sun, 19 Jun 2005 17:35:27 GMT

thanks rich,

the code which you explained solved my issue.

anand.