topic Re: read table using range in Application Development and Automation Discussions

read table using range

kiran_k8 — Fri, 14 Dec 2007 09:47:48 GMT

Hi Folks,

I had declared a range for s_witht and wanna read the table tempx w.r.t to the belnr in printtab and range of values declared in s_witht.

loop at printtab.

READ TABLE TEMPX WITH KEY BELNR = PRINTTAB-BELNR

WITHT IN S_WITHT

MOVE TEMPX-WT_QBSHH TO PRINTTAB-EDUCS.

modify printtab.

endloop.

loop at printtab.

READ TABLE TEMPX WITH KEY BELNR = PRINTTAB-BELNR

if tempx-witht in s_witht

MOVE TEMPX-WT_QBSHH TO PRINTTAB-EDUCS.

endif.

modify printtab.

endloop.

But it is not reading the values in the range.Where am I going wrong.

Thanks,

K.Kiran.

Re: read table using range

former_member386202 — Fri, 14 Dec 2007 09:54:04 GMT

Hi,

While selecting data from database table into intarnal table check slect options in where condition.

then do like this

loop at printtab.

READ TABLE TEMPX WITH KEY BELNR = PRINTTAB-BELNR

if sy-subrc eq 0.

MOVE TEMPX-WT_QBSHH TO PRINTTAB-EDUCS.

endif.

modify printtab.

endloop.

Regards,

Prashant

Re: read table using range

Wil_Wilstroth — Fri, 14 Dec 2007 09:54:46 GMT

Hi Kiran,

Maybe you can try this:

IF tempx-witht BETWEEN s_witht-low AND s_witht-high.

Process

ENDIF.

I hope it helps you...

Thanks

William Wilstroth

Re: read table using range

JozsefSzikszai — Fri, 14 Dec 2007 09:57:38 GMT

hi Kiran,

by READ TABLE you can only use EQ (or =). IN, NE, etc are not allowed.

Re: read table using range

Former Member — Fri, 14 Dec 2007 09:59:04 GMT

Hi kiran,


"second condition looking OK.. try like this..

DATA : idx LIKE sy-tabix.

LOOP AT printtab.
idx =  sy-tabix.
READ TABLE tempx WITH KEY belnr = printtab-belnr.
IF sy-subrc EQ = 0.
  CHECK tempx-witht IN s_witht.
  MOVE tempx-wt_qbshh TO printtab-educs.
  MODIFY printtab INDEX idx.
ENDIF.
ENDLOOP.

Re: read table using range

Former Member — Fri, 14 Dec 2007 10:05:11 GMT

Hi,

'Read' statement fetches a single record that mathces the key field specification.

You cannot pass a range for 'Read' Statement.

Here is your code...

loop at printtab.

READ TABLE TEMPX WITH KEY BELNR = PRINTTAB-BELNR

if tempx-witht in s_witht

MOVE TEMPX-WT_QBSHH TO PRINTTAB-EDUCS.

endif.

modify printtab.

endloop.

You can modify it as follows.

Instead you can get the range of values into an internal table , say it_range. i.e. it_range will have the range of values of s_witht.

Specify the read statement inside the loop of it_range.

loop at printtab.

loop at it_range into wa_range.

READ TABLE TEMPX WITH KEY BELNR = PRINTTAB-BELNR

witht = wa_range-witht.

MOVE TEMPX-WT_QBSHH TO PRINTTAB-EDUCS.

modify printtab.

endloop.

Hope this would solve your purpose...

Message was edited by:

P Sreenivasulu

Re: read table using range

jayanthi_jayaraman — Fri, 14 Dec 2007 10:06:22 GMT

Hi,

loop at printtab.

READ TABLE TEMPX WITH KEY BELNR = PRINTTAB-BELNR.

if sy-subrc eq 0."Check the sy-subrc here

if tempx-witht in s_witht

MOVE TEMPX-WT_QBSHH TO PRINTTAB-EDUCS.

endif.

modify printtab.

endif.

endloop.

Another way is to try using loop.

loop at TEMPX where BELNR = PRINTTAB-BELNR

and WITHT IN S_WITHT.

...endloop.