IS THIS CORRECT???

[sachin_soni]

Hi all !

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

thanks,

sachin

[sachin_soni]

Hi all !

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

thanks,

sachin

[sachin_soni]

oops i missed it ....sorry!

select kna1~loevm into gt_output-loevm1.

[Former Member]

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

Cheers

VJ

[Former Member]

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

<append gt_output if you want>

endselect.

regards

shiba dutta

[Former Member]

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

[Former Member]

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.

[Former Member]

try this...

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

<append gt_output if you want>

endselect.

Cheers

VJ

[sachin_soni]

thanks all,

i think i got the idea.

sachin

[sreeramkumar_madisetty]

Hi Sachin

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

Regards,

kumar