Open Sql

[Former Member]

How to write open sql query for this .

Do select COUNT(*) from R.TFRSOUT where I_APT = in_MATERIAL NO.

If COUNT(*) > 0,

record is present.

endif.

[Former Member]

How to write open sql query for this .

Do select COUNT(*) from R.TFRSOUT where I_APT = in_MATERIAL NO.

If COUNT(*) > 0,

record is present.

endif.

[Former Member]

Hi,

Did you try something like...

SELECT COUNT( * ) INTO LV_COUNT FROM ....
WHERE I_APT = IN_MATERIAL_NO.
IF LV_COUNT > 0.
  ...
ENDIF.