Skip to Content
author's profile photo Former Member
Former Member

Internal Table Manipulation:: Urgent

Hi all,

I have an internal table having 150 fields.Now there are duplicate records in my internal table having the same values for all the 150 fields ( Exactly the same value in the entire row ) ..My requirement is to delete all those duplicate records and my internal table must have only one unique row of record..

Suppose i have four rows having the same value for all the fields.I want to have only one row after my manipulation of the internal table..

Please suggest how i can achieve the same..

Itz urgent and all uselful answers will be rewarded..

Thanks & Regards,

Arun Chaudhary

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Dec 03, 2007 at 01:29 PM

    hi Arun,

    use: DELETE ADJACENT DUPLICATES ...

    ec

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 01:29 PM

    Hi,

    Do like this

    DELETE ADJUCENT DUPLICATES FROM ITAB COMPARING <KEY FIEDLS>.

    Regards,

    Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 01:29 PM

    Hi Arun,

    1. Simple

    2. Sort the inernal table.

    3. then write code

    DELETE ADJACENT DUPLICATES FROM ITAB.

    (since you want all fields to be compred for duplicate checking,

    the above statment is enough)

    (The system will compare all fields for duplicate checking)

    4. If u want only some fields for duplicate checking, then u can

    add the suffix

    ..... COMPARING FIELD1 FIELD2 FIELD5.

    Regards,

    Amit Mittal.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 01:29 PM

    Just to delete adjacent duplicates from itab.

    Albert

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 01:30 PM

    Hi,

    Check the following code:

    Sort itab.
    delete adjacent duplicates from itab

    .

    Hope this helps,

    Erwan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 01:33 PM

    Use the code:

    Delete adjacent duplicates from itab comparing all fields.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.