Skip to Content
-2
Oct 03, 2020 at 08:52 PM

Select-option in select query condition

152 Views

Dears,

Is there any elegant way to know which entries in select-option have not fetched records as where condition in Select statement?

I mean without comparing tables contents. if possible.

For example which matnr in so_matnr have not fetch records:

SELECT a~infrn a~matnr a~lifnr b~ekorg
INTO TABLE itab
FROM eina AS a
INNER JOIN eine AS b on a~infnr = b~infnr
WHERE a~matnr IN so_matnr
AND a~lifnr = p_lifnr
AND b~ekorg = p_ekorg.

thanks, Raj