select record

[Former Member]

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]

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

Regards

Gopi

[abdulazeez12]

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

[varma_narayana]

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]

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