topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Fri, 21 Apr 2006 14:11:41 GMT

Hi friends,

I have an Internal table I_tab and j_tab with matnr as a field,

for each entry in I_tab, I need to check j_tab ,is there is repeating matnr in j_tab.

Re: Internal Table

Former Member — Fri, 21 Apr 2006 14:17:19 GMT

hi Karhik,

Use for all corresponding fields of j_tab statement in the select statement

sort: l_tab , j_tab.

loop at l_tab.

read table j_tab with key matnr = l_tab-matnr

endloop.

Regards,

Santosh

Re: Internal Table

suresh_datti — Fri, 21 Apr 2006 14:17:34 GMT

try this..


sort: l_tab,j_tab.
loop at l_tab.
read table j_tab with key matnr = l_tab-matnr
binary search.
if sy-sub rc eq 0.
* entry exists in j_tab.
endif.
endloop.

Regards,

Suresh Datti

Re: Internal Table

Former Member — Fri, 21 Apr 2006 14:18:04 GMT

Hi,

Loop at I_tab.

read table J_tab with key matnr = i_tab-matnr.

if sy-subrc = 0

Success

endif.

endloop.

If you are looking for more than one entry in J_tab ...

Loop at I_tab.

loop at J_tab where matnr = i_tab-matnr.

if sy-tabix = 2

Success

endif.

endloop.

Regards,

Ravi

Note : Please close the thread of the issue is resolved.

Re: Internal Table

Former Member — Fri, 21 Apr 2006 14:18:19 GMT

Hi,

Use the following code.

Loop at I_tab into wa_tab1.

Read table j_tab into wa_tab2

with key matnr = wa_itab1-matnr.

if sy-subrc eq 0.

There is an entry for matnr in both the tables
Do your processing

endif.

endloop.

Hope this helps.

Please reward some points if it helps.

Regards,

Amit Mishra

Message was edited by: Amit Mishra

Re: Internal Table

Former Member — Fri, 21 Apr 2006 14:19:40 GMT

You need to read j_tab with field MATNR

DATA: COUNT TYPE I.

LOOP AT I_TAB.

COUNT = 0.

LOOP AT J_TAB WHERE MATNR = ITAB-MATNR.

COUNT = COUNT + 1.

IF COUNT > 2. EXIT. ENDIF.

ENDLOOP.

max

Re: Internal Table

ferry_lianto — Fri, 21 Apr 2006 14:19:59 GMT

Hi Kalimuthu,

You can use ABAP command SEARCH itab.


SEARCH itab FOR pattern [IN {BYTE|CHARACTER} MODE] 
       [STARTING AT idx1] [ENDING AT idx2] 
       [ABBREVIATED] 
       [AND MARK].

and check the return value

SY-SUBRC Relevance

0 Pattern found in itab.

4 Pattern not found in itab.

Hope this will help.

Regards,

Ferry Lianto

Re: Internal Table

Former Member — Fri, 21 Apr 2006 14:24:09 GMT

Hi Ravi

You can't check SY-TABIX, because it indicates the number of the record you're elaborating and not how many records (with a certain value) are in the table.

max

Re: Internal Table

Former Member — Fri, 21 Apr 2006 14:27:24 GMT

Just to be different...


data: j_tab_temp LIKE j_tab OCCURS 0,
      count      TYPE i.

LOOP AT i_tab.
  j_tab_temp[] = j_tab[].
  DELETE j_tab_temp WHERE matnr <> i_tab-matnr.
  DESCRIBE TABLE j_tab_temp LINES count.
  IF count > 1.
*-- more than one entry exists in j_tab for this MATNR
  ENDIF.
  CLEAR j_tab_temp[].
ENDLOOP.

Re: Internal Table

Former Member — Fri, 21 Apr 2006 14:38:58 GMT

Have a look at <a href="/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops">this.</a>

Rob

Re: Internal Table

Former Member — Sat, 22 Apr 2006 12:13:15 GMT

Hi Kalimuthu,

You can use the following Logic. I have given the sample code.


DATA : count TYPE i.

SORT i_tab BY matnr.
SORT j_tab BY matnr.

CLEAR count.
LOOP AT i_tab.
  LOOP AT j_tab WHERE matnr = i_tab-matnr.
    count = count + 1.
    IF count GT 1.

      "Repeating matnr do your processing here

      EXIT.
    ENDIF.

  ENDLOOP.
  CLEAR count.  "Clear the count for next matnr in i_tab
ENDLOOP.

Regards,

Arun S.