topic Re: Read Internal Table based on Multiple Values for Key Field in Application Development and Automation Discussions

Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 12:47:17 GMT

Hi Gurus,

i have one query can you tell me how read an internal table it_kna1 for multiple values of land1 DE US IND etc.

i had tried as below but i could not can you try and let me knwo at the earliest.

here i want read the values with DE or US and want further prosess them.

REPORT YC001.

tables kna1.

select-options: cust for kna1-kunnr.

data: begin of it_kna1 occurs 0,

kunnr like kna1-kunnr,

name1 like kna1-name1,

land1 like kna1-land1,

end of it_kna1.

select kunnr name1 land1 into table it_kna1 from kna1 where kunnr in cust.

read table it_kna1 with key land1 = ( 'DE' OR 'US' ) .

can anybody suggest me some solution.

Thanks,

Jeevi.

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 12:51:56 GMT

hi Jeevi,

You cannot use Or with READ, you have to loop,

loop at itab where land1 eq 'DE' Or
                           land1 eq 'US'.

endloop.

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 12:52:25 GMT

Hi,

Use

read table it_kna1 with key land1 = 'DE'

land1 = 'US' .

Reward if helpful.

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 12:52:34 GMT

Hi Jeevi,

By using the Read statement you are trying to select only one record, so you can try doing that in the below mentioned way too..

read table............ land1 = 'DE'.

if sy-subrc ne 0.

read table........... land1 = 'US'.

if sy-subrc ne 0.

read table........... land1 = 'IND'.

if sy-subrc eq 0.

< process your code>

endif.

Reward points if this helps,

Kiran

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 12:53:41 GMT

hi jeevi,

when ur using list of values use OPERATORS as LIKE, IN, BETWEEN ..........

and change ur code as

read table it_kna1 with key land1 in ( 'DE' ,'US' ) .

read table it_kna1 with key land1 like 'DE%' OR 'US%' .

if helpful reward some points.

with regards,

Suresh Aluri.

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 12:53:46 GMT

read table itab with kunnr = itab2-kunnr.

if itab1-land1 eq IN or itab1-land1 eq US .

do any thing

endif.

Regards

Peram

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 12:56:07 GMT

Hi,

try this:

TABLES KNA1.

SELECT-OPTIONS: CUST FOR KNA1-KUNNR.

DATA: BEGIN OF IT_KNA1 OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

NAME1 LIKE KNA1-NAME1,

LAND1 LIKE KNA1-LAND1,

END OF IT_KNA1.

SELECT KUNNR NAME1 LAND1 INTO TABLE IT_KNA1 FROM KNA1 WHERE KUNNR IN CUST.

read table it_kna1 with key land1 = ( 'DE' OR 'US' ) .

LOOP AT IT_KNA1 WHERE LAND1 = 'DE'

OR LAND1 = 'US'.

WRITE: / IT_KNA1-KUNNR, IT_KNA1-NAME1, IT_KNA1-LAND1.

ENDLOOP.

Regards, Dieter

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 15:49:53 GMT

This should be what you need:


REPORT ztest NO STANDARD PAGE HEADING LINE-SIZE 80 MESSAGE-ID 00.

TABLES kna1.

SELECT-OPTIONS: cust FOR kna1-kunnr.

DATA: BEGIN OF it_kna1 OCCURS 0,
        kunnr LIKE kna1-kunnr,
        name1 LIKE kna1-name1,
        land1 LIKE kna1-land1,
      END OF it_kna1.

DATA: itab_index LIKE sy-tabix.

SELECT kunnr name1 land1
  INTO TABLE it_kna1
  FROM kna1
  WHERE kunnr IN cust.

SORT it_kna1 BY land1.
READ TABLE it_kna1 WITH KEY
  land1 = 'DE'
  BINARY SEARCH.

itab_index = sy-tabix.
WHILE sy-subrc = 0.
  itab_index = itab_index + 1.
  WRITE: /001 it_kna1-kunnr, it_kna1-land1, it_kna1-name1.
  READ TABLE it_kna1 INDEX itab_index.
  IF it_kna1-land1 <> 'DE'.
    sy-subrc = 99.
  ENDIF.
ENDWHILE.

SKIP 1.

READ TABLE it_kna1 WITH KEY
  land1 = 'US'
  BINARY SEARCH.

itab_index = sy-tabix.
WHILE sy-subrc = 0.
  itab_index = itab_index + 1.
  WRITE: /001 it_kna1-kunnr, it_kna1-land1, it_kna1-name1.
  READ TABLE it_kna1 INDEX itab_index.
  IF it_kna1-land1 <> 'US'.
    sy-subrc = 99.
  ENDIF.
ENDWHILE.

Rob

Re: Read Internal Table based on Multiple Values for Key Field

Former Member — Mon, 27 Aug 2007 15:51:35 GMT

Hi All,

My query has been answered, thanks for your quick response and the precious time spent by the contributors.

thanks,

Jeevi.