topic Re: Test if line exist in table in Application Development and Automation Discussions

Test if line exist in table

Former Member — Fri, 14 Dec 2007 14:54:40 GMT

How can i test if a line exists in a table?

Greets Volker

Former Member — Fri, 14 Dec 2007 14:56:56 GMT

hi Volker,

You can use Select single form database table with the where clause.

Eg : Select single form <DATABASETABLE> into <WORKAREA>

where <CONDITION>.

Regards

Sourabh Verma

JozsefSzikszai — Fri, 14 Dec 2007 15:02:39 GMT

hi Volker,

if you don't need the line, only the information if it is there, you can use:

SELECT COUNT( * ) FROM ... WHERE ...

IF sy-subrc EQ 0.

==> exists

ELSE.

==> does not exist

ENDIF.

the value in sy-dbcnt will show how many records were found.

hope this helps

Former Member — Fri, 14 Dec 2007 15:16:16 GMT

Hi,

if you know all the primary field values of that table then go for

select single from table XXXX where "Conditions".

else if you know some fields (not all primary keys) go for

select upto 1 rows from table XXXX where "Conditions".

if the select statement selects the record, that is the confirmation.

Reward if useful.

Thanks,

Sreeram.

Former Member — Fri, 14 Dec 2007 15:26:31 GMT

Database table or internal table?

Rob