Reg Select Query

[Former Member]

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

[Former Member]

Please use CAPS and pattern:

select tabname from dd02l into table i_table where tabname <b>LIKE 'Z%'</b> .

Kind Regards

Eswar

[Former Member]

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 <b>LIKE</b> 'Z%' .

write:/ .

REGARDS

SHIBA DUTTA

Message was edited by:

SHIBA DUTTA

Message was edited by:

SHIBA DUTTA

[Former Member]

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 <b>like</b> '<b>Z</b>*' .

or

select tabname from dd02l into table i_table where tabname <b>like</b> '<b>Z</b>%' .

If useful reward

Vasanth

[Former Member]

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

[anversha_s]

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

[Former Member]

Hi Ravi ,

Use the command

<b>select tabname from dd02l into table i_table where tabname like 'Z%'.</b>

Regards

Arun