10-31-2007 4:52 PM
Dear Frns,
I created a simple SAP query with quickviewer by table join option.
tables are MAST & STPO.
Link is only STLNR.
I am getting a duplicate extra line with same data.
Can anyone suggest me how it happened.
Is there anyway to remove these duplicate lines.
pl suggest
10-31-2007 4:57 PM
Hi,
You can sort the internal table and then delete the duplicate entries.
sort itab ascending by STLNR.
delete adjacent duplicates from itab comparing STLNR.
Reward points for useful answers.
10-31-2007 4:58 PM
10-31-2007 5:03 PM
Hi Gurus,
It is not in SQL .
It is in Quick viewer (SQVI) even in SQ02.
pl give ur valuable suggestions.
10-31-2007 5:07 PM
Hi Vijay,
There will be a <b>Code tab</b> for every query. You can write the code over there to delete the adjucent duplicates.
Reward if it helps,
Satish
11-01-2007 8:14 AM
Dear sathish,
i am not finding any code tab in quick viewer( SQVI).
The code tab is available only in SQ02.
When creating queries we will not store in any internal table.
so pl guide me what kind of code I can write to remove the duplicates.