09-21-2005 10:04 AM
Hi all,
I want to see all purchage orders but not repeating.
Ex: take 5 purchage orders
1122580002
1122580002
1122580003
1122580003
1122580004
I want to c like
1122580002
1122580003
1122580004
which is not repeating.
can u please help me,
Thank you very much,
shashikanth.
09-21-2005 10:07 AM
You can use
SORT ITAB WITH EBELN.
DELETE ADJACENT DUPLICATES COMPARING EBELN.
09-21-2005 10:07 AM
You can use
SORT ITAB WITH EBELN.
DELETE ADJACENT DUPLICATES COMPARING EBELN.
09-21-2005 10:12 AM
u can either use sort ...and then delete adjacent duplicates....
u can also use AT NEW and AT END OF while looping on your internal table if u dont want to lose information by deleting table. Do take note of the restrictions with these control break extracts.
rgds,
PJ
09-21-2005 10:22 AM
hi sasi,
create an internal table with the field ebeln as the first field.
populate the internal table with the purchase order numbers.
sort the internal table.
within loop use AT NEW EBELN.
ok.good luck.
09-23-2005 4:18 PM
if your are two specfic of column position then you can try with on change of
loop at itab.
on change of <field>
..
endon.
endloop.
try this i hope this will also do.
09-24-2005 6:23 PM
Hi,
You can do like this also.
create a internal table <itab>.
select * from ekko into table itab.
loop at itab.
at new ebeln.
write : / itab-ebeln.
endat.
endloop.
Regards,
Sriram.