Question:
Is there an easy way (except for looping through the table and analysing the data) to eliminate any duplicates including the original entry when there are multiple entries for a particular condition.
For example I have a list of materials and associated contracts in an itab. If there is more than one contract for a material I do not want it. I can not use delete adjacent duplicates as this command will keep at least one entry for the material. I want to delete the material from the table completely if I have multiple contracts associated to it.
Thanks in advance.
Answer:
AFAIK there is no way to achieve this other than to loop through your table and analyse.
Don't forget that if you have many instances of the same data - DELETE <itab> WHERE <condition> might be useful to you.
_________________
Kind Regards
Rosie Brent
Please remember to search the forum and check the FAQ before posting questions, thank you.
Tuly Idiot most of the time, part-time Guru