topic Re: read table in Application Development and Automation Discussions

read table

Former Member — Fri, 03 Aug 2007 09:30:53 GMT

Hi,

I want to write a read stmt to select the row from itab where condition type (kschl) starts with 'J....'

And my loop at table doesnt have this field so i cant specify where clause there.

Read table itab into wa with key kschl = 'all condition types starting with J'

I tried writing

read table itab into wa with key kschl = 'J%'.

it didnt work.

Pls help me.

Message was edited by:

sonali shahasane

Re: read table

VXLozano — Fri, 03 Aug 2007 09:34:24 GMT

From other post, answer from Rich Heilman

LOOP AT itab INTO wa WHERE kschl LIKE 'J%'. "or *, I cannot remember :P
  EXIT.
ENDLOOP.

Re: read table

Former Member — Fri, 03 Aug 2007 09:35:14 GMT

better to use where condition of loop statement.

loop at it where kschl like 'j%'.

.............

exit.

endloop.

don't forget to reward

Sameer

Re: read table

Former Member — Fri, 03 Aug 2007 09:35:18 GMT

Hi Sonali,

Change your code like,

read table itab into wa with key itab-kschl = 'J%'.

Thanks.

Re: read table

Former Member — Fri, 03 Aug 2007 09:36:05 GMT

Hi,

U can't read multiple records from the internal table using READ TABLE statement. In this case u can use loop at..where.

LOOP AT ITAB INTO WA WHERE KSCHL EQ 'J%'.

......

ENDLOOP.

Regards,

Sankar

Re: read table

Former Member — Fri, 03 Aug 2007 09:45:58 GMT

hi sonali,

read statement requires that the comparison operator to be used must be "=" and for the value, it compares the entire string specified (in your case it will try to fetch if J% is actually present.

so, instead of trying to read a value, do select into a temporary internal table where kschl = all conditions starting with j.

like this...

DATA: TEMP(4) VALUE 'J%'.

SELECT * FROM KONP

INTO CORRESPONDING FIELDS OF TABLE IT_KONP

WHERE KSCHL LIKE TEMP.

and then do a read for whatever condition type is required.

reward points if it helps.

Re: read table

Former Member — Fri, 03 Aug 2007 09:50:22 GMT

hi Sanker,

thanks for ur reply,

but the problem is my loop at table doesnt have this field. Field is only in my read itab.