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: 

select from jcds all status begin with E

Former Member
0 Kudos

Hello Experts,

i need to select all rows that the status begin with E.

how can i do that?

thanks,

Michal.

1 ACCEPTED SOLUTION

kesavadas_thekkillath
Active Contributor
0 Kudos

Example:

SELECT objnr stat udate utime INTO TABLE it_time[] FROM jcds FOR ALL ENTRIES IN it_aufk[]

WHERE objnr EQ it_aufk-objnr AND ( stat LIKE 'E%' ).

4 REPLIES 4

kesavadas_thekkillath
Active Contributor
0 Kudos

Example:

SELECT objnr stat udate utime INTO TABLE it_time[] FROM jcds FOR ALL ENTRIES IN it_aufk[]

WHERE objnr EQ it_aufk-objnr AND ( stat LIKE 'E%' ).

Former Member
0 Kudos

Hi michal

select * from <table > into table <Itab> where status like 'E%'.

<table> - data base table.

<itab> - Internal table which is declared in program.

Regards,

Sateesh

Former Member
0 Kudos

Use WILD Card %.

former_member217316
Contributor
0 Kudos

Hi Michal

Use the wild card character '%' in the where clause.

Select * from DBTABLE

INTO TABLE itab

where Stat LIKE 'E%'.

Hope this helps.

Harsh

Edited by: Harsh Talesra on Jun 8, 2009 1:48 PM