Test if line exist in table

[Former Member]

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

Greets Volker

[Former Member]

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]

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]

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

ec

[Former Member]

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]

Database table or internal table?

Rob