Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

IS THIS CORRECT???

sachin_soni
Active Participant
0 Kudos

Hi all !

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

thanks,

sachin

1 ACCEPTED SOLUTION

sachin_soni
Active Participant
0 Kudos

oops i missed it ....sorry!

select kna1~loevm into gt_output-loevm1.

8 REPLIES 8

sachin_soni
Active Participant
0 Kudos

oops i missed it ....sorry!

select kna1~loevm into gt_output-loevm1.

0 Kudos

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

Cheers

VJ

0 Kudos

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

<append gt_output if you want>

endselect.

regards

shiba dutta

0 Kudos

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

0 Kudos

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.

0 Kudos

try this...

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

<append gt_output if you want>

endselect.

Cheers

VJ

0 Kudos

thanks all,

i think i got the idea.

sachin

0 Kudos

Hi Sachin

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

Regards,

kumar