The program cancels with the following mistake in the select of the table EBAN:
Mistakes time execution: DBIF_RSQL_INVALID_RSQL
Exception: CX_SY_OPEN_SQL_DB
The SELECT is this:
SELECT *
FROM eban
INTO TABLE t_eban
WHERE ekgrp IN s_ekgrp AND
werks IN s_werks AND
ekorg IN s_ekorg AND
bsart IN s_bsart AND
banfn IN r_banfn AND
matnr IN s_matnr AND
matnr IN r_matnr AND
dispo IN s_dispo AND
ebeln IN s_ebeln AND
frgzu IN s_frgzu AND
statu IN s_statu AND
preis IN s_preis.
The Aim(Lens) is to modify the select extracting of the conditions the tables r_banfn and r_matnr, after the select to add the necessary thing to eliminate of the table t_eban the records that do not exist in the tables before mentioned.
Since I can do to eliminate these records?.
Thank you very much.