HI Lokesh.
If you want these values in another table for processing later, we will create an internal table for that, or we will implement the processing (of deducting the value) in that loop itself.
begin of ty_final,
bukrs type bukrs,
belnr type belnr,
gjahr type gjahr,
buzei type buzei
dmbtr type dmbtr,
end of ty_final.
data it_Final type table of ty_final. "Required only if you want to collect all the details to a table.
data : wa_final type ty_final.
sort itab by bukrs belnr gjahr buzei.
clear wa_final.
loop at itab into wa_tab.
if wa_tab-dmbtr GT wa_final-dmbtr.
move corresponding wa_tab to wa_final
endif.
at end of belnr.
append wa_final to it_final. "Required only if you want to collect all the details to a table.
* If you can do the processing here itself, no need to append to the internal table
* Just do the deductions / calculations with the values in wa_final.
clear wa_final.
endat.
endloop.
Another option would be just to sort and do the calculations with the first line. for each belnr.
sort itab by bukrs belnr gjahr dmbtr descending.
loop at itab into wa_itab.
at new belnr.
*wa_itab will have the line item with maximum amount. Do your processing as required. Either append to another table or perform calculations with the values.
endat.
endloop.
