topic Re: IS THIS CORRECT??? in Application Development and Automation Discussions

IS THIS CORRECT???

sachin_soni — Fri, 16 Feb 2007 03:36:21 GMT

Hi all !

can u tell me whether the following query is correct or not.

thanks,

sachin

Re: IS THIS CORRECT???

sachin_soni — Fri, 16 Feb 2007 03:37:03 GMT

oops i missed it ....sorry!

select kna1~loevm into gt_output-loevm1.

Re: IS THIS CORRECT???

Former Member — Fri, 16 Feb 2007 03:38:45 GMT

Guess the select statement is not complete. paste your complete code.

Cheers

Re: IS THIS CORRECT???

Former Member — Fri, 16 Feb 2007 03:41:13 GMT

select kna1~loevm into gt_output-loevm1 from kna1 <where condn if you want>.

endselect.

regards

shiba dutta

Re: IS THIS CORRECT???

Former Member — Fri, 16 Feb 2007 03:45:10 GMT

Hi,

The alias is required only if you are using a Join in your select query, otherwise use ordinary references.

When you use more than one table and the field is common in both the tables, to differentiate between the two, you use the alias reference.

kna1~loevm...

Regards

Subramanian

Re: IS THIS CORRECT???

Former Member — Fri, 16 Feb 2007 03:53:31 GMT

select kna1~loevm into gt_output-loevm1.

The select query should be as

select loevm FROM kna1
                   into corresponding fields of table gt_output
                   where ...............

If u are using two tables and making join then use as u specified with alias otherwise no need.

Re: IS THIS CORRECT???

Former Member — Fri, 16 Feb 2007 03:57:43 GMT

try this...

select loevm from kna1 into gt_output-loevm1 <where condn if you want>.

endselect.

Cheers

Re: IS THIS CORRECT???

sachin_soni — Fri, 16 Feb 2007 07:18:24 GMT

thanks all,

i think i got the idea.

sachin

Re: IS THIS CORRECT???

sreeramkumar_madisetty — Fri, 16 Feb 2007 07:24:31 GMT

Hi Sachin

if you satisfied the replies you got please close the thread by mark as completed.

Regards,

kumar