topic Re: select record in Application Development and Automation Discussions

select record

Former Member — Mon, 01 Oct 2007 08:39:17 GMT

Hi,

Now I have to select estat from TJ30T where estat starts with 'E'. Is it possible?

what is the efficient way?

Regards,

Subbu

gopi_narendra — Mon, 01 Oct 2007 08:42:14 GMT

DATA : it_tj30t TYPE TABLE OF tj30t INITIAL SIZE 0.
SELECT * FROM tj30t
            INTO TABLE it_tj30t
            WHERE estat LIKE 'E%'.

Regards

Gopi

abdulazeez12 — Mon, 01 Oct 2007 08:43:08 GMT

Select ESTAT from TJ30T into table itab where ESTAT like 'E%'.

varma_narayana — Mon, 01 Oct 2007 08:44:12 GMT

Hi..

Perform a wild card search using LIKE Operator

<b>select estat from TJ30T where estat LIKE 'E%'.</b>

<b>reward if helpful.</b>

Former Member — Mon, 01 Oct 2007 08:44:28 GMT

Hi Subba Reddy,

Please try this and tell me the result.

Modify the code according to your requirement...

TABLES : tj30t.

DATA : itab TYPE TABLE OF tj30t,

wa LIKE LINE OF itab.

SELECT * FROM tj30t INTO CORRESPONDING FIELDS OF TABLE itab WHERE estat LIKE 'E%'.

SORT itab BY estat.

LOOP AT itab INTO wa.

WRITE : / wa-estat.

ENDLOOP.

Regards,

Sai