Skip to Content
avatar image
Former Member

SAP Query - delete adjacent duplicates

Hi Experts,

I am facing the scenario how to remove duplicate values from Query report.

When i am typing the code in report it is giving the Error. My question is the is it wrong coding ?? and if it is then what should be the correct one.

Regards,

Qamber Abbas

Error.png (65.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 07, 2016 at 06:30 AM

    hi,

    Dtab u declared as a structure.

    try the following

    data: dtab type table of quals-prueflos.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi noufal,

      system takes the code but still in report it odes not sort and delete the duplicate value.

      You can go though screen shot.

      regards,

      Qamber Abbas

      Report.png (43.9 kB)
  • avatar image
    Former Member
    Apr 07, 2016 at 06:44 AM

    DATA: dtab type table of qals.

    *populate dtab first

    delete adjacent duplicates from dtab comparing prueflos.

    Add comment
    10|10000 characters needed characters exceeded