Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to get the duplicate records in report rfbnum10

Hi Experts,

I am modifying the standard report RFBNUM10 copying it to another program name.

my requirement was to display duplicate reference number. i have completed the task but now i have one doubt that if we check the same amount check box and execute then how the report will display.

My input parameters are

Same amount check box  ( if check box is ticked Need to remove single values).

Same Ref check box  ( if check box is ticked Need to remove single values).

I am using delete adjustment duplicate logic and I am also trying at new (Amount and Ref ) but its not working properly.

 

Below is my example test data


SlAmountRef.
110001234
210001234
3200012345
420001234
5300012345
65000123



I wanted out put like this.

SlAmountRef.
110001234
210001234


Please help me out.


Regards

Shambuling Kulkarni

Former Member
Former Member replied

Hi Experts,

Issue has been solved the report is displaying data as per our expectations.

Thanks all for providing your valuable input and time.

below is the code which i used.

loop at  lt_itab into wa_itab1.

loop at it_itab into wa_itab where bukrs = wa_itab1-bukrs and

                       koart = wa_itab1-koart and

                       konto = wa_itab1-konto and

                       gjahr = wa_itab1-gjahr and

                       xblnr = wa_itab1-xblnr.

lv_cnt1 = lv_cnt1 + 1.

clear wa_itab.

endloop.

if lv_cnt1 = 1.

   wa_itab1-dele_flg = 'X'.

modify it_itab from wa_itab1 transporting dele_flg where bukrs = wa_itab1-bukrs and

                                                             koart = wa_itab1-koart and

                                                             konto = wa_itab1-konto and

                                                             gjahr = wa_itab1-gjahr and

                                                             xblnr = wa_itab1-xblnr.

endif.

clear :lv_cnt1,wa_itab1.

endloop.


delete it_itab where dele_flg = 'X'.


Regards

Shambuling

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question