topic Re: SAP Query - delete adjacent duplicates in Application Development and Automation Discussions

SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 06:25:07 GMT

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

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 06:30:48 GMT

hi,

Dtab u declared as a structure.

try the following

data: dtab type table of quals-prueflos.

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 06:40:40 GMT

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

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 06:44:56 GMT

DATA: dtab type table of qals.

*populate dtab first

delete adjacent duplicates from dtab comparing prueflos.

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 06:50:41 GMT

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

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 06:54:42 GMT

Change your data delcaration to

DATA: dtab type table of qals.

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 06:58:04 GMT

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

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 07:11:28 GMT

data dtab type TABLE OF qals.

SELECT * FROM qals into TABLE dtab.

DELETE ADJACENT DUPLICATES FROM dtab COMPARING prueflos.

Re: SAP Query - delete adjacent duplicates

Former Member — Thu, 07 Apr 2016 07:48:25 GMT

It works for me thanks.

Regards,

Qamber Abbas