SORT and DELETE ADJACENT
why do we need used the SORT and DELETE ADJACENT if there is a warning msg stated
"Before For ALL Entries internal tbl remove duplicate values" and what are the cause of the issue if we dun not put it ?
Sorting and deleting adjacent entries before select all entries statement will help in improving the performance of the select statement.
Also, if there are any duplicate entries in source table, it results in duplicate efforts to fetch the data from database. You can verify this by doing SQL trace ST05 on that query.
When you use for all entries, the system basically splits the query in multiple queries and fetches data and then deletes any duplicates from the resultant table if any.
Check this link which explains the process, the issue and solution.