topic read statement in Application Development and Automation Discussions

read statement

Former Member — Wed, 18 Apr 2007 06:57:36 GMT

Hi,

can anyone explain to me why read table statement is not working in the followinf code:

data: begin of it_lfb1 occurs 10,

lifnr like lfb1-lifnr,

bukrs like lfb1-bukrs,

end of it_lfb1.

select *

from lfb1

into corresponding fields of it_lfb1.

append it_lfb1.

read table it_lfb1 into wa_lfb1 with key lifnr = '100'.

write:/ wa_lfb1-lifnr,

wa_lfb1-bukrs.

endselect.

when i am executing the read statement without key, its fetching first record.

Regards

vivek

Re: read statement

Former Member — Wed, 18 Apr 2007 07:00:15 GMT

Hi,

data: begin of it_lfb1 occurs 10,

lifnr like lfb1-lifnr,

bukrs like lfb1-bukrs,

end of it_lfb1.

select lifnr bukrs from lfb1

into table it_lfb1.

Loop at it_lfb1.

if it_lfb1-lifnr = '100'.

write:/ it_lfb1-lifnr,

it_lfb1-bukrs.

endif.

endloop.

regards,

Anji

Message was edited by:

Anji Reddy Vangala

Re: read statement

Former Member — Wed, 18 Apr 2007 07:00:33 GMT

Hi,

data: begin of it_lfb1 occurs 10,
lifnr like lfb1-lifnr,
bukrs like lfb1-bukrs,
end of it_lfb1.
select *
from lfb1
into corresponding fields of table it_lfb1.


looat it_lfb1 into wa_lfb1 where lifnr = '100'.
write:/ wa_lfb1-lifnr, wa_lfb1-bukrs.
endloop.

Re: read statement

Former Member — Wed, 18 Apr 2007 07:01:26 GMT

Hi,

Try this.

LIFNR = '0000000100'.

Regards,

Suresh.

Re: read statement

Former Member — Wed, 18 Apr 2007 07:02:19 GMT

Hi..,

check this !! it is working !!..

data: begin of it_lfb1 occurs 10,

lifnr like lfb1-lifnr,

bukrs like lfb1-bukrs,

end of it_lfb1.

select *

from lfb1

into corresponding fields of table it_lfb1.

loop at it_lfb1 where lifnr eq '0000000100'.

write:/ it_lfb1-lifnr,

it_lfb1-bukrs.

endloop.

The output contains all the records where lifnr = 100.

regards,

sai ramesh

Re: read statement

Former Member — Wed, 18 Apr 2007 07:05:07 GMT

Hi Vivek,

try with this line

read table it_lfb1 into wa_lfb1 with key lifnr = '0000000100'

you need to pad zeros as many number according to size of the field. lifner length of the field is 10. so you need to pad 7 zeros befor '100'. It may solve your problem

Regards,

venkat

Re: read statement

Former Member — Wed, 18 Apr 2007 07:23:39 GMT

Hi,

Try this...

data: begin of it_lfb1 occurs 10,

lifnr like lfb1-lifnr,

bukrs like lfb1-bukrs,

end of it_lfb1.

select *

from lfb1

into corresponding fields of it_lfb1.

append it_lfb1.

data wa_lfb1 like line of it_lfb1.

read table it_lfb1 into wa_lfb1 with key lifnr = '0000000100'.

write:/ wa_lfb1-lifnr,

wa_lfb1-bukrs.

endselect.

Re: read statement

Former Member — Wed, 18 Apr 2007 07:25:59 GMT

Hi Vivek,

As LIFNR as the conversion exit, so pad zeros prior to 100 to get the record.

If you doesnt specify WITH KEY then it will display the first record only. Dont use READ statements inside your SELECT statement.

data: begin of it_lfb1 occurs 10,

lifnr like lfb1-lifnr,

bukrs like lfb1-bukrs,

end of it_lfb1.

select *

from lfb1

into corresponding fields of it_lfb1.

append it_lfb1.

read table it_lfb1 into wa_lfb1 with key lifnr = '0000000100'.

write:/ wa_lfb1-lifnr,

wa_lfb1-bukrs.

endselect.

(or)

data: begin of it_lfb1 occurs 10,

lifnr like lfb1-lifnr,

bukrs like lfb1-bukrs,

end of it_lfb1.

select lifnr bukrs from lfb1

into table it_lfb1.

Loop at it_lfb1 where lifnr = '0000000100'.

write:/ it_lfb1-lifnr,

it_lfb1-bukrs.

endif.

endloop.

Thanks,

Vinay

Re: read statement

Former Member — Wed, 18 Apr 2007 12:38:02 GMT

hi,

try this u include the read statement inside the loop..this is internal table with

select *

from lfb1

into corresponding fields of it_lfb1.

append it_lfb1 to wa_lfb1.

loop at it_lfb1 into wa_lfb1.

read table it_lfb1 into wa_lfb1 with key lifnr = '100'.

write:/ wa_lfb1-lifnr,

wa_lfb1-bukrs.

endloop.