Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

yalcin_mete
Participant
0 Kudos

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



1 ACCEPTED SOLUTION

javier_alonso
Participant
0 Kudos
DELETE gt_lot_data WHERE dispo IS NOT INITIAL AND dispo NOT IN s_dispo.
4 REPLIES 4

javier_alonso
Participant
0 Kudos
DELETE gt_lot_data WHERE dispo IS NOT INITIAL AND dispo NOT IN s_dispo.

0 Kudos

Thank you 🙂

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

?

yalcin_mete
Participant
0 Kudos

thank you 🙂