Skip to Content
1
Former Member
Aug 03, 2007 at 07:45 PM

Q: sourceField NOT IN InternalTable expression

21 Views

Hi,

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

FROM /BI0/PMAT_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.

DELETE SOURCE_PACKAGE.

ELSE.

....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,

Mikael