SAP Query - delete adjacent duplicates

[Former Member]

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

[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

[Former Member]

hi,

Dtab u declared as a structure.

try the following

data: dtab type table of quals-prueflos.

[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

[Former Member]

DATA: dtab type table of qals.

*populate dtab first

delete adjacent duplicates from dtab comparing prueflos.

[Former Member]

It is now showing the new error, Please Type complete correct coding for my help.

[Former Member]

Change your data delcaration to

DATA: dtab type table of qals.

[Former Member]

I have change the statement but still i got the same issue.

[Former Member]

data dtab type TABLE OF qals.

SELECT * FROM qals into TABLE dtab.

DELETE ADJACENT DUPLICATES FROM dtab COMPARING prueflos.

[Former Member]

It works for me thanks.

Regards,

Qamber Abbas