I have a start routine in which I want to filter out and delete some data packages. I want to make sure to filter away all data where MAT_SALES is not in my internal table. I Have created the code below and I do not get any compilation error, but it does not seem to work.
data: i_mat_sales TYPE RANGE OF /BIC/AZBILCOPA00-MAT_SALES.
SELECT DISTINCT MAT_SALES
INTO TABLE i_mat_sales
WHERE /BIC/ZACCASGRP IN ('a', 'b', 'c').
LOOP AT SOURCE_PACKAGE into source_wa.
IF source_wa-MAT_SALES NOT IN i_mat_sales.
....code goes on...
Does somebody know if you can use the "sourceField NOT IN InternalTable" expression like this in ABAP or do I need to re-write my code?
Thank you in advance,