repeatable

[Former Member]

hi guru's,

i want to disply repeatable records ,which will available in database.how to retrive only repeatable records.

give me code corresponding that

thanks in advance

[Former Member]

probably you mean duplicate reports?

[former_member582701]

Hi surendra,

I think it doesnt exist. You have to retrieve all table and do a loop.

Select * from DATABASE into itab.

Sort itab order by fields.

Read table itab index 1 into wa2_itab.

numrecords = 0.

Loop at itab into wa_itab.

if wa_itab <> wa2_itab. " or fields you need to compare

if numrecords = 1.

append wa2_itab into otab2.

endif.

move wa_itab to wa2_itab.

numrecords = 1.

else.

numrecords = numrecords + 1.

endif.

endloop.

reward points if it help u

best regards

[Clemenss]

Hi surendra raju,

what is your personal definition of "repeatable records"?

Not given any context at all...

Regards,

Clemens

[Former Member]

probably you mean duplicate reports?

[Former Member]

probably you mean duplicate reports?

[Clemenss]

duplicate re<b>p</b>orts?

duplicate re<b>c</b>or<b>t</b>s can not exist in the database because that would imply a duplicate key. Duplicate keys are not defined in relational database.

Regards,

Clemens