Perform a manual table check with a delete statement

Hello Gurus,

Im really a begginer so dont be harsh if im wayoff . Im asked to apply a delete on a Z DB where the table check are not verified .

I thought a bout doing a select where each field not in table check but i cant find any syntax to perform such manoeuvre.

Im thinking about smth like this please correct me if i'm wrong.

select PLTYP
from T189
into table LT_PLTYP.

select MATKL
from T023
into table LT_MATKL.

select PRODH
from T179
into table LT_PRDHA.

select PSTRA
from TWPS
into table LT_PSTRA.

select KLART
from TCLA
into table LT_KLART.

select CLINT
from KLAH
into table LT_CLASS.

THEN performing something like this with a correct syntax

select * from ZRET_PRICE_STRGY
WHERE NOT
PLTYP IN LT_PLTYP
OR MATKL IN LT_MATKL
OR PRDHA IN LT_PRDHA
OR PSTRA IN LT_PSTRA
OR KLART IN LT_KLART

into it_ZRET_PRICE_STRGY.

Finishing by a a delete ZRET_PRICE_STRGY from it_ZRET_PRICE_STRGY

Thank you for advance any help will be much appreciated