topic Reg Select Query in Application Development and Automation Discussions

Reg Select Query

Former Member — Wed, 20 Dec 2006 09:31:25 GMT

Hi Guys,

I need a help on the select query...could you please help me out, here is my requirement.

I need to pick up all the ztables from the table DD02L so for this I wrote a select statement as follows..

data : begin of i_table occurs 0,

tabname like dd02l-tabname,

end of i_table.

select tabname from dd02l into table i_table where tabname = 'z*' .

write:/ .

but I am getting sy-subrc as 4...

points will be rewarded ..

Regards,

Ravi Ganji

Re: Reg Select Query

Former Member — Wed, 20 Dec 2006 09:33:25 GMT

Please use CAPS and pattern:

select tabname from dd02l into table i_table where tabname LIKE 'Z%' .

Kind Regards

Eswar

Re: Reg Select Query

Former Member — Wed, 20 Dec 2006 09:33:35 GMT

data : begin of i_table occurs 0,

tabname like dd02l-tabname,

end of i_table.

select tabname from dd02l into table i_table where tabname LIKE 'Z%' .

write:/ .

REGARDS

SHIBA DUTTA

Message was edited by:

SHIBA DUTTA

Message was edited by:

SHIBA DUTTA

Re: Reg Select Query

Former Member — Wed, 20 Dec 2006 09:34:31 GMT

Hello Ravi,

U need to do like this.

data : begin of i_table occurs 0,

tabname like dd02l-tabname,

end of i_table.

select tabname from dd02l into table i_table where tabname like 'Z*' .

select tabname from dd02l into table i_table where tabname like 'Z%' .

If useful reward

Vasanth

Re: Reg Select Query

Former Member — Wed, 20 Dec 2006 09:34:54 GMT

Hi ,

Use this Select query .

select tabname from dd02l into table i_table where tabname like 'Z%' .

Regards ,

Senthil

Message was edited by: Senthil

senthil kumar

Re: Reg Select Query

anversha_s — Wed, 20 Dec 2006 09:37:37 GMT

hi,

do this

data : begin of i_table occurs 0,
tabname like dd02l-tabname,
end of i_table.

data : i_z_table like i_table .

select tabname from dd02l into table i_table.

loop at i_table.

if  i_table-tabname+0(1) =  'Z'..
append i_table to i_z_table.
endif.

endloop.

in i_z_table contain all ztables.

Rgds

Anver

Re: Reg Select Query

Former Member — Wed, 20 Dec 2006 09:50:04 GMT

Hi Ravi ,

Use the command

select tabname from dd02l into table i_table where tabname like 'Z%'.

Regards

Arun