topic Re: report in Application Development and Automation Discussions

report

Former Member — Thu, 22 Feb 2007 13:05:21 GMT

Hi ,

can u pls let me know

DELETE ADJACENT DUPLICATES FROM i_mat.

this should be within the LOOP and Endloop.

Re: report

Former Member — Thu, 22 Feb 2007 13:06:40 GMT

Hi,

NO.

This should be out of Loop.

Just after selecting data into int table use this.

Regards,

Anji

Re: report

Former Member — Thu, 22 Feb 2007 13:08:23 GMT

Hi Prakash,

This is not with in the loop but you need to Sort the Internal table before using this Delete Adjacent Statment

Regards

Sudheer

Re: report

Former Member — Thu, 22 Feb 2007 13:08:55 GMT

<b>outside the loop.</b>

DATA OFF TYPE I.

DATA: BEGIN OF LINE,

COL1 TYPE I,

COL2 TYPE C,

END OF LINE.

DATA ITAB LIKE STANDARD TABLE OF LINE

WITH NON-UNIQUE KEY COL2.

LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.

LINE-COL1 = 1. LINE-COL2 = 'B'. APPEND LINE TO ITAB.

LINE-COL1 = 2. LINE-COL2 = 'B'. APPEND LINE TO ITAB.

LINE-COL1 = 3. LINE-COL2 = 'B'. APPEND LINE TO ITAB.

LINE-COL1 = 4. LINE-COL2 = 'B'. APPEND LINE TO ITAB.

LINE-COL1 = 5. LINE-COL2 = 'A'. APPEND LINE TO ITAB.

OFF = 0.

PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

OFF = 14.

PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING COL1.

OFF = 28.

PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB.

OFF = 42.

PERFORM LIST.

FORM LIST.

SKIP TO LINE 3.

LOOP AT ITAB INTO LINE.

WRITE: AT /OFF LINE-COL1, LINE-COL2.

ENDLOOP.

ENDFORM.

Re: report

Former Member — Thu, 22 Feb 2007 13:09:05 GMT

Hi Prakash,

Try to use the Delete inside the select and endselect itself while getting the data into the internal table.

Regards,

Mallik.

Re: report

Former Member — Thu, 22 Feb 2007 13:10:29 GMT

hi prakash,

u need to write it outside loop....endloop.

example...

if not it_vbrk[] is initial.

delete adjacent duplicates from it_vbrk comparing vbeln.

endif.

regards,

priya.

Re: report

PS_1978 — Thu, 22 Feb 2007 13:16:34 GMT

Hi Prakash,

It should be before the loop and should have been sorted on the key fields that u r going to use in COMPARING clause.

Regards,

Phani.