Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Ways of checking if record exists in itab without loop?

Tags:

abap

Is there a shortcut or should I just loop at the table and check?

I mean I am using an internal table and I want to check if a value is contained in one field of the internal table and I don't want to loop the table to find the value. Is it possible?

like image 743
Mtok Avatar asked Sep 13 '12 05:09

Mtok


2 Answers

To check for a specific value without doing a loop or transferring values to a work area, you can use the READ statement with the addition TRANSPORTING NO FIELDS like so:

READ TABLE itab WITH KEY FIELD = 'X' TRANSPORTING NO FIELDS.
IF sy-subrc = 0.
  "Read was successful.
ENDIF.

UPDATE: From release 740 ABAP contains the predicate function LINE_EXISTS which is described in this blog post.

It's a built-in function to which you pass a table expression. Using the above example:

IF line_exists( itab[ field = 'X' ] ).
  "Do stuff
ENDIF.

Full syntax of table expression in that predicate see here: https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abentable_expressions.htm

like image 86
mydoghasworms Avatar answered Oct 02 '22 00:10

mydoghasworms


Selam,

If you are going to use loop in your algorithm, then you can use something like this:

LOOP ITAB WHERE FIELD = 'X'.

"code sample

ENDLOOP.

If you are not going to use a loop in your code, then i don't think there is a specific way to check for a specific value in itab.

Hope its helpful.

Talha

like image 29
Mtu Avatar answered Oct 02 '22 00:10

Mtu