topic Select statement in Application Development and Automation Discussions

Select statement

Former Member — Thu, 16 Aug 2007 08:18:22 GMT

Hi Friends,

Can we select records from a database table into 2 internal tables using one select statement.

regards,

Re: Select statement

Former Member — Thu, 16 Aug 2007 08:19:26 GMT

Hi!

No, you can't select into 2 internal tables.

You can select into more fields, like this:

SELECT SINGLE matnr werks

FROM marc

INTO lv_matnr, lv_werks

WHERE matnr = '100001'.

Regards

Tamás

Message was edited by:

Tamás Nyisztor

Re: Select statement

Former Member — Thu, 16 Aug 2007 08:19:41 GMT

Hi chaitanya,

it is not possible.

Regards,

Murali Krishna K

Re: Select statement

Former Member — Thu, 16 Aug 2007 08:20:19 GMT

Hi,

It's not possible.

Hope this helps.

reward if helpful.

Regards,

Sipra

Re: Select statement

Former Member — Thu, 16 Aug 2007 08:20:53 GMT

Hi,

You cannot do it with into table statement , but with a select... endselect statement you can append in as many internal tables as you like.

Alternatively you can select the entire data once using into table statement , then transfer all the records to second internal table for avoiding load on the database.

Hope this helps.

Thanks,

imtiaz Syed

Re: Select statement

Former Member — Thu, 16 Aug 2007 08:21:02 GMT

Hi Chaitanya,

I hope its possible to put records into 2 internal table with a single select statement.

Re: Select statement

former_member378318 — Thu, 16 Aug 2007 08:32:41 GMT

Sathiya,

What kind of answer is "I hope its possible"??????

I hope I win the lottery but what are the chances of that, very slim I would imagine.

Surbjeet

Re: Select statement

Former Member — Thu, 16 Aug 2007 08:44:32 GMT

YOU DON'T HAVE ACCESS TO WRITE A SELECT QUERY FOR 2 INTERNAL TABLES

YOU CAN GET DATA FROM 2 DATABASE TABLES INTO ONE INTERNAL TABLE

ONE DATABASE TO 2 INTERNAL TABLES IN ONE SELECT QUERY IS NOT POSSIBLE

IF YOU WANT DATA IN 2 INTERNAL TABLES OF DIFFRENT DATA THEN YOU NEED TO WRITE TWO SELECT QUERYS

IFYOU WANT DATA IN 2 INTERNAL TABLES OF SAME DATA THEN 1ST WRITE A SELECT QUERY FOR ONE AND MOVE THAT DATA TO 2ND INTERNAL TABLE

REWARD IF USEFULL

Re: Select statement

Former Member — Thu, 16 Aug 2007 08:49:03 GMT

Hi Chaitanya...

Try this...

Select * from <table>

into corresponding fields of table <itab1>

where..

<b>itab1 and itab2 must and should have same structure.</b>

Rward If Helpful.

Regards

Sasidhar Reddy matli.