How do you tell your FWB that you don't want to do it anymore? Will it affect the friendship?

Just tell him or her you don't want to do it anymore. I can't imagine that it WON'T be awkward or affect the friendship, I suppose it depends on a lot f factors. But be prepared for hurt feelings.