Skip to Content
0
Former Member
Nov 13, 2006 at 07:16 PM

Exception: CX_SY_OPEN_SQL_DB

591 Views

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.