Skip to Content

How to delete column duplicates in report

Hello All,

Duplicates are popping up in alv report in Project Description Cloumn. as shown in image.

Only for required wbs element only it should fetch short description.

Delete adjacent statement was not working, i.e, lot of records getting deleted it should not be done.

duplicates.jpg (137.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • POST1 is not the project, it's the WBS description!

    In PRPS you have PSPHI as Project number!
    And still i do not understand which duplicates you want to remove, since it's clear to me that the keys of your table are Employee (PERNR) and Trip Number (REINR).

    It's perfect logic that the same person, with different trips has costs assigned to the same WBS!

    Which are the duplicates you think they are wrong? And why do you thing they are wrong?

    As side note: why don't you put these tables in join?

  • My Apologies,
    Yes POST1 is WBS description.

    Here for wbs element respective description is coming but it was continuing till next wbs element appear.

  • So... it's not a matter of duplicate data, but a matter of "dirty" output.

    A little suggestion: put a clear after the append of your internal table or, better, before filling your wa_... structure.

  • Follow
  • Get RSS Feed

2 Answers

  • Jul 16, 2018 at 10:18 AM

    It's clear there is another key field (at least!) you are not showing in your picture: you should investigate which is the aim of this report and which are the actual output fields.

    From the little snapshot, i doubt removing rows will be a wise solution.

    By the way, you want to remove rows and not columns!

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 17, 2018 at 05:16 PM

    Thanks for suggestion SimonMilesi.

    issue got solved.

    Yes problem with clearing work area.

    Thanks for all for your valuable suggestions.

    Add comment
    10|10000 characters needed characters exceeded