topic Re: Copy data between dbtables in Application Development and Automation Discussions

Copy data between dbtables

Former Member — Wed, 23 May 2007 10:37:12 GMT

Hi experts,

Is it correct? I want to copy the data to another dbtables:

select *

from /BIC/AZ99OS03300

INTO Z99BW033A

where GL_ACCOUNT between '5200000000' and '5299999999'

AND COMP_CODE ='S00'.

MODIFY Z99BW033A FROM /BIC/AZ99OS03300.

endselect.

Re: Copy data between dbtables

Former Member — Wed, 23 May 2007 10:40:31 GMT

If both the DB tables are having same fields the you can use

select *

from /BIC/AZ99OS03300

INTO IT_Z99BW033A

where GL_ACCOUNT between '5200000000' and '5299999999'

AND COMP_CODE ='S00'.

MODIFY Z99BW033A FROM it_Z99BW033A.

endselect.

Reward points if useful

Regards

Anji

Re: Copy data between dbtables

alex_m — Wed, 23 May 2007 10:42:18 GMT

If both the table having smae fields then your select statement is valid. But u have to add TABLES statement in top for the work area.

Re: Copy data between dbtables

Former Member — Wed, 23 May 2007 10:42:22 GMT

Hi Marc,

data: itab like Z99BW033A occurs 0.

select *

from /BIC/AZ99OS03300

INTO table itab

where GL_ACCOUNT between '5200000000' and '5299999999'

AND COMP_CODE ='S00'.

if sy-subrc = 0.

MODIFY Z99BW033A FROM table itab.

endif.

Regards,

Vidya.

Re: Copy data between dbtables

Former Member — Wed, 23 May 2007 10:42:52 GMT

Hi,

Donot use endselect as it raises a performance issue.

select *

from /BIC/AZ99OS03300

INTO table it_Z99BW033A

where GL_ACCOUNT between '5200000000' and '5299999999'

AND COMP_CODE ='S00'.

MODIFY Z99BW033A FROM it_Z99BW033A.

Re: Copy data between dbtables

Former Member — Wed, 23 May 2007 10:43:10 GMT

Hi Marc

Change your query to

select *

from /BIC/AZ99OS03300

INTO it_Z99BW033A

where GL_ACCOUNT between '5200000000' and '5299999999'

AND COMP_CODE ='S00'.

MODIFY Z99BW033A FROM it_Z99BW033A.

Regards,

Atish

Re: Copy data between dbtables

dev_parbutteea — Wed, 23 May 2007 10:44:29 GMT

HI,

you are selecting from /BIC/AZ99OS03300 into Z99BW033A. so, why do you want to modify Z99BW033A which has not been modified .