Code: Alles auswählen.
select
'100' as Mandant
"-" as Block
"D200" as Werk
"1000" as Lager
"-" as Block
" substring( a~matnr 11 8 ) as Material
a~charg as Charge
a~clabs as Menge
c~meins as Einheit
"NO_COUNT" as Benutzer
from mchb as a
inner join mara as c on a~matnr = c~matnr
into table it_sapin01p
where a~werks = f_werk and a~lgort = f_lager
and a~clabs > 0
and not exists
( select * from z001_sapin01p as b
where b~material = a~matnr and
charge = a~charg
and b~mandant = 100 ).
Liegt der Fehler bei den Konstanten oder woanders?DBIF_RSQL_INVALID_RSQL
CX_SY_OPEN_SQL_DB