deleting a record from the internal table (empty records should not be deleted)

[yalcin_mete]

Hello Masters,

I want to delete those that are not equal to s_dispo in the "gt_data lot" table, but those with empty "s_dispo(dispo)" in the "gt_data lot" table should not be deleted.

How can I do that ?

Thanks

[javier_alonso]

DELETE gt_lot_data WHERE dispo IS NOT INITIAL AND dispo NOT IN s_dispo.

[yalcin_mete]

Thank you 🙂

[DominikTylczyn]

delete gt_lot_data where dispo not in s_disp and dispo <> ''.

?

[yalcin_mete]

thank you 🙂