When you cancel the SD document , the accounting document generated automatically reverses the original FI document.
Let it reverse the original document and go FBRA and enter the clearing document number and click on "Reset cleared documents".
This will reset the reversal but will still have the offset posting.
Just note that in FBRA you need to enter the clearing document number, which is reversal document in this case.
Assign points if u find it useful.