No. When you use the button to put it into Sport mode you're changing the steering sensitivity, suspension and engine noise.
When you pull down on the shifter to put it into S, this raises the shift points.
You can be driving in Sport mode (button) and still have it in D, and vice versa...